Hey!

Thanks for subscribing and here’s this weeks edition lesson:

Main Lesson: Using SQL for Better Data Analysis

Recently, I’ve made improvements to my SQL Skills from SQL for Data Analysis by Cathy Tanimura. One lesson for me was the importance of using less common SQL functions, like CROSS JOINs, for more flexible analyses. Here’s why this matters:

• What it is: CROSS JOINs allow you to combine all rows from two datasets, which is especially useful for filling in gaps, such as creating data for missing dates in time series analysis.
• How it helps: This technique ensures complete and accurate datasets for analysis, like for retention and cohort reporting.
• Why it works: By using functions like CROSS JOINs, I can focus on solving real business problems rather than spending time manually restructuring data.

For a full breakdown of my thoughts on the book, including what I liked, what could be better, and how I’ve applied its lessons in my work, check out this week’s blog post:

Bite-Sized Resources

📺 Video: [AI] Which Jobs Will Survive AI? from Tina Huang which goes into an analysis of specific job titles that will survive AI, great for anyone who is looking to learn more about the impact of AI on jobs.

💻 Resource: [SQL] SQL Calendar from Dawn Choo that’s a free 24 day SQL challenge that starts on December 1st, which will be great for anyone who wants to learn or practice their SQL.

📝 Post: [Business] LinkedIn Post from Andy Werdin on why it’s important to work with others in the business and tech teams.

Courses & Resources

📚 ​Excel Course​: A free course that teaches you Excel from beginner concepts like formulas and functions to more advanced concepts like Power Query.

📚 ​SQL Course​: Learn basic SQL in 4 hours going over things like aggregation, common analysis techniques and more.

📚 ​Python Course​: Goes into not only using Python to analyze data but also visualize it as well with libraries like Matplotlib.

📊 How to Become a Data Analyst: Check out my blog post on how you can become a data analyst.

📊 Data Analytics Resources: View all the resources (e.g. podcasts, courses, etc.) I used to learn data analytics.

The links for my courses are affiliate links. If you decide to purchase the course through this link, I may receive a small commission at no extra cost to you. This support helps me continue to provide content. Thank you for your support!

Until next time,

- Kelly