Kelly's Bytes - 5/24/24 (#99) - How I Saved 10 Minutes with a Python Script


KELLY'S BYTES

By Kelly J. Adams

Hey!

It's Friday, May 24, 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, How I Saved 10 Minutes with a Python Script goes into:

  • How I automated a financial report with Python.
  • How this simplified process saves time weekly.
  • What I learned and new insights.

View my blog here.


Bite-Sized Resources

📰 Article: [Data Analytics] Create datasets yourself! by Judith Okon that walks through how you can build a dataset yourself using Python.

🎧 Podcast: [Data Science] SDS 768: Is Claude 3 Better than GPT-4? from SuperDataScience Podcast, a short episode diving into Jon Krohn’s thoughts about Claude 3 vs. ChatGPT 4.

📝 Post: [Data Analytics] LinkedIn post from Jess Ramos about what you should specialize in one (or more) of 3 areas in data analytics.


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.


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

KELLY'S BYTES By Kelly J. Adams Hey! You might’ve noticed that I’ve changed the format of my newsletter. I’ve been spending the last few weeks really thinking about how I want to structure my content from now on. So each newsletter contains: Main Lesson: Something I’ve learned or am working on 3 bite-sized resources: Still related to data or learning new skills Main Lesson: SQL Functions Understanding how data flows into tables has been a game-changer for my SQL workflow. Here’s why:...