Skip to content

The Exact Steps I’d Take If I Were Starting Over In Data Analytics

Today, I’m going to share the exact steps I would take if I were starting over in data analytics.

Data analytics is a great career choice. I’m so happy I made the jump 15+ years ago and have stuck with it for all these years.

Unfortunately, when I was just getting started back in the mid-2000s, there were limited resources to get started:

  • Limited or no online courses. Definitely nothing free.
  • No YouTube. No Twitter. No Instagram.
  • Basic tools like Excel and Microsoft Access for most analytics projects.

Fortunately, data analysts starting today get all of the benefits of modern technology. 

There are two types of data analysts: action takers, and sideliners.

Data analysts that just sit on the sidelines don’t do well:

  • Never getting started
  • Bouncing from tutorial to tutorial
  • Endlessly saving Twitter threads to Notion
  • Stuck on the sideline, watching others take action

Fortunately, there are so many resources for you to take action in your data analytics career journey.

Here are the exact steps I’d take if I were getting started today:

Step 1: Start with SQL

Learning everything you need to know about data analytics all at once is impossible. 

Don’t even try. Instead, start with SQL. Head over to SQLBolt (it’s free) and start working on those practice problems. 

Just get started with 30 minutes. 

Then 30 minutes more tomorrow. After a few days, you will start to get the hang of it. Start sharing what you are learning and if you get stuck, reach out for help on Twitter. 

Unfortunately, many aspiring analysts just won’t stick to learning SQL.

They get distracted by other languages that so-called “experts” say are the next best thing. Don’t get distracted. Don’t procrastinate.

If you learn SQL first and share what you learn with others, it’s impossible to get stuck on the sidelines.

Step 2: Build In Public

So many aspiring data analysts just keep their journey to themselves.

But this is the wrong approach in so many ways. There are entire communities of people (my favorites are on Twitter) that absolutely love helping others. And you can benefit by sharing what you learn.

You don’t have to be an “expert” to share what you learn online. 

What does expert mean anyways? You can build in public as a learner and let others join in on the journey with you. It’s a lot more fun!

Step 3: Create An Online Portfolio

Having an online data analytics portfolio sets you apart from the crowd.

And they don’t have to be overcomplicated. You can create a simple website to host your portfolio, without having to code, and without having to spend a dime.

Now, you will need to have 5-10 projects to add to your portfolio. Here are some resources I recommend

You’ll also need to know how to write about each of your projects in a way that will gain attention.

Step 4: Learn How To Write Well

This last step might be the most important because it brings Steps 1-3 together.

It can be tempting to think that all you need is technical skills and recruiters will come knocking on your door. That might have been true in the past, but not anymore. 

Now you need to have both tech skills and soft skills:

  • Collaboration
  • Critical thinking
  • Communication
  • Problem-solving

These soft skills all require you to be able to write. And write well. Here’s what I mean:

If you can combine tech skills (SQL) and show your stuff (by building in public) in a collection of 5-10 projects (with your online portfolio) you are a few steps ahead of the game. Because very few people take the time to build an online portfolio.

Unfortunately, most aspiring data analysts stop there. They don’t realize how important soft skills are.

But learning how to write well is critical. And here are some resources I recommend:

Next Steps

  1. Head over to SQLBolt and practice for 30 minutes
  2. Share your journey on Twitter (DM me at @NewPrediction)
  3. Start working on 1 project for your portfolio
  4. Improve your soft skills by learning to write well

Whenever you’re ready, there are 3 ways I can help you:

Pre-order now: Master the basics of SQL with my Learn SQL Basics course.
Pre-order now: Sharpen your SQL skills with 48 exercises in Daily SQL Practice.
Need specific advice? Book a 1:1 session with me.

Leave a Reply

Your email address will not be published. Required fields are marked *

Tableau & Google Sheets Checklist

This one-page checklist PDF will help you learn how to upload your data into Google Sheets and build an awesome Tableau dashboard without wasting time.

You have Successfully Subscribed!

4 Things For Every Tableau Dashboard Creator

This free 4-page eBook PDF will walk you through the 4 most important steps for creating a Tableau dashboard

You have Successfully Subscribed!

Massive List of Tableau Tools

Tableau is even more powerful with these 20 tools you might not know about. The 2-page PDF includes a description and helpful links for each tool to get you started.

You have Successfully Subscribed!

Career Boosting Business Analytics Trends

Use this list as a road map to take you from boring data job to the GO-TO PERSON in your company that knows the answers to all the questions.

All set! Check your email :)

Massive List of Free Data Viz Books

List of 10 Awesome Data Visualization Books

All set! Check your email to download.

Tableau Dashboards
Beginner’s Guide

Get the full 2-page PDF with the 5 steps outlined in this guide + 3 bonuses to help you along the way

BONUS #1: 5 Beginner mistakes to avoid

BONUS #2: Video walkthrough

BONUS #3: Links to the the Google Sheet and final Dashboard

All set! Check your email :)

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.

 

All set! Check your email :)

Massive List of Tableau Web Data Connectors

Download the list of 21 different Web Data Connectors for Tableau in this Google Sheet (save a copy for yourself, too!) 

All set! Check your email :)

Slope Graph Examples PDF + Dashboard Walkthrough Video

4-page PDF showing 10 slope graph examples + a video walkthrough

All set! Check your email to download the bonus materials.

Tableau Tutorial Chart Redesign

Download the Tableau Tutorial PDF Checklist & Workbook

The step-by-step checklist for fixing busted charts with Tableau PLUS the full workbook with all of my formatting and calculations for free.

All set! Check your email to download.

Download the TableauHighlight Tables PDF Guide

The step-by-step guide for creating Tableau highlight tables
(plus direct links to the YouTube video walkthrough and link to final Tableau workbook)

You have Successfully Subscribed!

Tableau Scatter Plots: The Complete Guide

Get the step-by-step checklist guide to create scatter plots with Tableau

 

All set! Check your email :)

Rebuild a Busted Chart with Tableau

Enter your best email to get the PDF version of this tutorial + the companion Tableau workbook for free

All set! Check your email to download.

Download the Bonus Materials

Enter your best email to get the PDF checklist version of this guide and the companion Tableau workbook for free.

All set! Check your email :)