profile

Starting With Data

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

Published 7 months ago • 3 min read

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.

113 Cherry St #92768, Seattle, WA 98104
UnsubscribePreferences

Starting With Data

Weekly data analytics tutorials and guides. 5 minutes to read.

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

Business leaders are dumb. That's what a lot of business analysts think because they create something "awesome" with a dataset and then it gets ignored. Unfortunately, these types of business analysts don't realize that leaders aren't dumb. They are just busy. They are responsible for making decisions and making them quickly. And leaders need answers (based on data) more than anything. Think about it: if they need answers and you have the skills to provide those answers... You become their...

5 months ago • 5 min read

Starting with Data Actionable data analytics tips, tricks, and tutorials to increase your earning potential. Delivered right to your inbox every Saturday. Python Data Blending Made Easy: 3 Simple Steps to Combine Data Sets in Python (Even if You’re Not Sure Where to Start) Hey Reader, Have you ever been given a few different spreadsheets and had to combine them into one? Use clunky VLOOKUPs in Excel Copy and paste (hoping you don't break something) Give up and ask a more technical coworker...

5 months ago • 3 min read

Starting with Data Actionable data analytics tips, tricks, and tutorials to increase your earning potential. Delivered right to your inbox every Saturday. Stop Guessing, Start Visualizing: Turn Retail Data into Decision-Making Tools with Interactive Python Dashboards (Tutorial + Code) Hey Reader, You won't get noticed unless you are solving real-world business problems. find a problem create a solution share your work land your dream job Pretty simple. The hard part is knowing where to start....

5 months ago • 5 min read
Share this post