🟢 From Analyst to Python Pro: Transform Your Data Skills with 3 Simple Steps (Even If You’re Not Sure How To Get Started)


Starting with Data

Actionable data analytics tips, tricks, and tutorials to increase your earning potential. Delivered right to your inbox every Saturday.

From Analyst to Python Pro: Transform Your Data Skills with 3 Simple Steps (Even If You’re Not Sure How To Get Started)

I've been there—sitting on the sidelines watching others get really good with Python.

Feeling stuck with just Excel and SQL. Not really knowing how to branch out. Meanwhile, everyone else moves forward.

And you're left behind:

  • Stuck working on boring reports
  • Trying to learn Python again (and again and again and again)
  • Waiting for something magic to just click for you so you can finally move on.

It’s exhausting.

It was for me a few years into my business analytics career anyway. I had a co-worker, Scott, who was AWESOME at Python and could do seemingly anything. He ended up getting promoted and I ended up taking over his boring, pre-canned Excel reports for our boss.

But then, I asked myself: what if it were EASY to learn Python?

I mean, what would that look like?

  • Being able to read and write Python code
  • Working with data sets quickly and easily
  • New skill sets and new opportunities

Well, here's how to get there:

1. Start with the Basics

Begin by learning the essential elements of Python, like variables, data types, and simple operations.

Don’t worry about complex algorithms. Familiarize yourself with the simpler, foundational concepts. It’s like learning to walk before you run.

Here are some quick start steps if you aren't sure where to start:

  1. Create a free Google Colab account and create a new notebook
  2. Write some basic code to get started
  3. Explore Python libraries for data analysis work
  4. Use sample datasets that are built into analytics libraries
  5. Practice different analytics tasks
  6. Get help online when you get stuck

Interested in a deep dive tutorial walkthrough of these steps? Let me know!

2. Practice Regularly

Don’t just read—implement.

Apply what you learn through small projects or tasks. Consistency is key. It's about practicing daily, even if it's just for a short amount of time. The more you practice, the more the concepts will sink in, making it easier over time.

Examples of Python projects for data analysts:

  1. Sales analytics: very common use case that you can apply to tons of different industries
  2. Customer segmentation analysis: crucial for personalized marketing (super relevant skill!)
  3. Time series forecasting: widely applicable to all sorts of careers, from finance to healthcare and everything in between.

Each of these projects is valuable on its own. Especially when you practice regularly. You'll work with different libraries. And work through different problems and use cases.

3. Seek Help

Connect with Python communities online, join forums, and don’t hesitate to ask questions, no matter how basic they seem.

Here are my go-to Python communities when I'm stuck:

  1. Stack Overflow: always useful when you're stuck and need help thinking through a problem
  2. Reddit r/Python: useful for new resources, tutorials, and guides to help you get started
  3. Python Discord: a dedicated community of very helpful Python enthusiasts (there are 50,000 people online right now!)

Python is a handy tool for people who work with data and want to increase their earning potential.

This guide is here to show you simple ways to start using Python, even if you’re really busy. Here’s a quick look back at what you’ve learned:

  1. Easy steps to start using Python without any complicated setups, focusing on saving time.
  2. Using Google Colab online to try Python without installing anything.
  3. Example Python projects like looking at sales data, studying customer groups, and predicting future trends, to help you use Python in real jobs.
  4. A few helpful online places where you can talk about Python and get help.

Now, you know the basics and can start using Python to make smarter business choices. Keep trying more with Python; each new thing you try helps you learn more.

So, what are you going to try next with Python?

Take 3 minutes to let me know what you want help with next.

Until next time,

Brian

PS: You may have noticed that Starting with Data hasn't been published in a few weeks. Sorry about that! I had some family matters come up – thanks to everyone who has had me in their thoughts and prayers. I really appreciate it! 🙏


Whenever you're ready, there are three ways I can help

  1. Get more data analytics tips in my previous newsletter articles
  2. Build your data analytics portfolio in 2 weeks with The Data Analytics Portfolio Playbook
  3. Join the waitlist for Solving with SQL, my 30-day cohort-based course (final cohort for 2023)

You are receiving this because you signed up for Starting with Data, purchased one of my data analytics products, or enrolled in one of my data analytics courses. Unsubscribe at any time using the link below.

600 1st Ave, Ste 330 PMB 92768, Seattle, WA 98104-2246
UnsubscribePreferences

Starting With Data

Learn to build analytics projects with SQL, Tableau, Excel, and Python. For data analysts looking to level up their career and complete beginners looking to get started. No fluff. No theory. Just step-by-step tutorials anyone can follow.

Read more from Starting With Data

Hey Reader, Over the past few weeks, I’ve shown you The Mister Rogers Blueprint in action using Summit Adventures, the fictional adventure travel company I built for teaching. You’ve seen real queries. Real business insights. Real data quality issues. Today I want to tell you why I built it this way. Because the reason matters more than you might think. The endless tutorial hamster wheel of death You know the pattern. You watch a Udemy course. It makes sense. The instructor shows you SELECT,...

Hey Reader, Last week I showed you The Mister Rogers Blueprint, the step-by-step guide to approaching unfamiliar dataset and delivering actionable insights. You might be thinking: “Okay, cool framework. But does this actually work?” Fair question. Let me show you what happens when people learn SQL this way. First, let’s talk about what doesn’t work. Jenn (a student and data coaching client of mine) paid $2,500 for an SQL course from an Ivy League university. She thought it would be robust,...

Hey Reader, Remember Mister Rogers? "Won't you be my neighbor?" That show taught me back in the day (and my now-grown kids more recently) along with millions of others young and old how to approach new situations with curiosity instead of fear. Turns out, that's exactly the mindset you need when someone drops an unfamiliar database on your desk. Here's the situation every analyst will face: You start a new job or project. Your manager says "Pull the customer data for Monday's meeting." You...