Kelly's Bytes - 7/19/24 (#103) - Why Your First Draft Won’t Be Perfect: A Data Project


KELLY'S BYTES

By Kelly J. Adams

Hey!

It's Friday, July 19, 2024 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 Post

My newest blog post, Why Your First Draft Won’t Be Perfect: A Data Project goes into:

  • Revisions improve data projects through constructive feedback.
  • Iteration is key to improving initial drafts.
  • Embrace feedback for better data projects.

View my blog here.


Bite-Sized Resources

📰 Article: [Data Analytics] 5 Types of Dashboards showcases 5 common types of dashboards. It gives an overview of each type of dashboard, when to use each, and why.

🎧 Podcast: Building a world-class data org | Jessica Lachs (VP of Analytics and Data Science at DoorDash) from Lenny’s Podcast. This episode goes into how to scale an analytics organization, how to pick the right metrics, and advice for data people.

📝 Post: [Interviews] LinkedIn post from Dawn Choo with 5 simple steps on how to answer the common interview question, “tell me about yourself”.


Content

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

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

📊 Start Here: Interested in data analytics but not sure where to start? Check out my blog post.


Courses

📚 Python Course: Is a full free course on Youtube with Luke Barousse to teach you Python focusing on data analytics. There is also an optional paid portion that gives you: 150 extra practice problems and a course certificate.

📚 SQL Course: On Youtube with Luke Barousse to teach you SQL in 4 hours. There is also an optional paid portion that gives you: 50 extra practice problems, detailed course notes, and a course certificate.

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 the next Friday,

- Kelly

Kelly's Bytes

Every other Friday, I share one practical lesson, highlight a blog post, and share 3 bite-sized resources to help you upskill and stay updated.

Read more from Kelly's Bytes

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...