9 SQL Core Concepts That Helped Me Get My First Data Analyst Job

I’m not a big fan of SQL, but most likely you will need SQL to pass the data science/analyst interview and regardless of your job title, you will use SQL quite often to create queries and interact…

The 5 SQL Transforms to Start Using

In prior posts, I analyzed data from the SQL Generator 5000 and outlined the 5 most popular SQL transforms. This time, I’m doing the opposite and looking at the 5 least popular. When I initially…

Automate PowerPoint Slides Creation with Python

Scenario You are a distribution planning manager in the logistics department of a fashion retail company. To perform analysis, you connect to the warehouse management system to extract and process…

How to Create a Professional Portfolio on GitHub That Will Help Land Your First Job in Data Science

Every piece of advice you reference for tips on landing a job in data science will talk about the importance of having a professional portfolio that showcases your…

How to Build a Successful Dashboard

At this point in my life, I think I have worked on more than a hundred different dashboards. As I grew more senior and started managing a team, I became more wary of these tasks — questioning the…

Jupyter Is Now a Full-fledged IDE: Annual Review

Jupyter Notebook 2023: A year in review. What changes and features did the team add to the popular interactive IDE.

4 Ways I’m Using Data Science Skills to Generate Income From Side Hustles

Over the past few years, the popularity of earning money online whilst maintaining a full-time 9–5 job has grown considerably, especially during the pandemic years. Some lucky few have managed to…

OpenAI Whisper Holds the Key to GPT-4

OpenAI has released the best automatic speech recognition model yet: Whisper is open source and could hold the key to GPT-4.

This Decorator will Make Python 30 Times Faster

How to use numba and JIT compilation to make python code faster. Particularly with pandas DataFrames.

Super Flexible Matplotlib Structure for Subplots

Matplotlib is one of the first libraries I learned about in my data science journey. I was amazed by how it allows for customizing almost everything on a visualization. This super flexible structure…