My newsletter where I share one practical lesson, highlight a blog post, and share 3 bite-sized resources to help you up skill and stay updated.
Kelly's Bytes - 11/3/23 (#86) - How to Learn SQL
KElly's BytesBy Kelly J. Adams |
Hey! It's Friday, November 3, 2023 which means another issue of Kelly's Bytes. Every other Friday I share: 1 new blog post from me; and 3 bite-sized resources related to topics like data analytics, switching careers or learning new skills. View past editions of my newsletter here. Blog PostThis Friday's blog post, How to Learn SQL, is about learning essential SQL skills through a step-by-step guide, from foundational tutorials to real-world projects and interview prep. View my blog here. Bite-Sized Resources📺 Video: [Data Analytics] Data Cleaning in Excel I Sports Store Sales Analytics Project (1/3) I Excel SQL Tableau from Chris French. This is part 1 of 3 of Chris French's series on creating a project focusing on sports store sales analytics. In this video he goes over the Excel portion of the project. 🎧 Podcast: [Data Analytics] Data Skeptic is a weekly podcast with that take a critical look at topics related to data science, statistics, machine learning and more. Episode lengths range from ~30 to ~45 minutes. 📝 Post: [Careers] LinkedIn post from Joe Squire with advice from 20+ individuals who are in the data field. This is a collection of advice for those at the beginning of their data journey. Other Content📊 How to Become a Data Analyst: Check out my ultimate guide on how you can become a data analyst. Check out my website here. Until the next Friday, - Kelly |
Kelly's Bytes
My newsletter where I share one practical lesson, highlight a blog post, and share 3 bite-sized resources to help you up skill and stay updated.
KELLY'S BYTES By Kelly J. Adams Hey! Thanks for subscribing and here’s this weeks edition lesson: Main Lesson: SQL User-Defined Functions One of the big improvement I’ve made in my SQL workflow recently is using User-Defined Functions (UDFs) in BigQuery. Here’s why: What it is: A UDF is a custom function you define to simplify repetitive logic in SQL queries. It can be written in SQL (my preference) or JavaScript. How it helps: Reduces redundancy, improves maintainability, and ensures...
KELLY'S BYTES By Kelly J. Adams Hey! Thanks for subscribing and here’s this weeks edition lesson: Main Lesson: T-Shaped Approach to Learning One of the biggest improvements I’ve made in my career planning is by adopting the T-shaped approach to skill-building. Here’s why it’s worth considering: What it is: A framework that balances deep expertise in one area (like data analytics) with broad knowledge across related areas (like business departments and industries). How it helps: It keeps your...
KELLY'S BYTES By Kelly J. Adams 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...