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 - 8/11/23 (#80) - 10 Things I've Learned in My First Month as a Data Analyst
KElly's BytesBy Kelly J. Adams |
Hey! It's Friday, Friday, August 11, 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, 10 Things I've Learned in My First Month as a Data Analyst, is about my top 10 lessons from my first month as a data analyst, giving insight into the real-world data analytics journey. View my blog here. Bite-Sized Resources📺 Video: Top 10 SQL interview Questions and Answers | Frequently asked SQL interview questions from Ankit Bansal with common SQL interview questions. A few of the questions are: difference between union and union all; how to delete duplicates; and find the second highest salary in each department. 🎧 Podcast: [Career] Mastering Your First 90 Days: A Guide to Success in a New Job l Ep. 269 from the How to Get a Job Podcast. It goes over tips on how to master your first 90 days on the job. They talk about the importance of your first 90 days and how to succeed. 📝 Post: [Career] LinkedIn post from Amy Miller with the resume that got her hired at Microsoft, Google, and Amazon. She emphasizes how clean and simple it is. She used Word and sent it in a .doc format every time. 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...