Skip to content

9 Things I Wish I Knew 15 Years Ago When I Was Starting In Data Analytics

Today, I’m sharing 9 things I wish I knew when I was just getting started in data analytics 15 years ago.

I’ve been working with data for the past 15+ years.

Unfortunately, there were times that I doubted the path I was on:

  • SQL joins were confusing
  • I didn’t get Python best practices
  • Excel pivot tables were hard to understand
  • Communicating with business partners and clients

Fortunately, I figured out things along the way and never looked back.

It’s easy to get tripped up if you don’t know what to watch out for.

You will waste a lot of time and energy:

  • Second-guessing the path you’re on
  • Believing you only have one shot
  • Not realizing your full potential
  • Getting mad and quitting

Fortunately, if you know what to look for, you can avoid all the hassle on your data analytics journey.

Here are the 9 things I wish I know 15 years ago:

1. Being a data analyst is like having a superpower

Your confidence increases as you solve more and more problems using data. Eventually, you become the “go-to” person for this stuff.

  • Working with data and SQL
  • Answering questions they never even thought to ask with Tableau
  • Creating simple (to you) but magic (to them) Excel docs
  • Automating tedious work with Python

2. Every industry needs data analysts

I like working in the financial services industry, especially with sales and marketing data. However: Every. Single. Company. has data and needs help.

Just have a look:

3. You don’t have to become a data scientist

Until recently, I assumed the career progression ended with becoming a data scientist. Since then, I’ve found a better path, getting into product management in strategic data analytics.

Other career paths as you advance in data analytics:

  • Tech lead
  • Team manager
  • Project manager
  • Senior data analyst
  • Software engineering
  • Data strategy and governance
  • Product management (my path)

4. It’s okay if it takes a while for things to click

Some of the skills you need as a data analyst are hard to learn! And that’s okay. For example, I remember SQL JOINs taking forever and then “clicking” one day.

Everyone learns at their own pace. Don’t bother comparing yourself to others. Just focus on taking one step at a time.

One tip: share what you are learning and what you are struggling with. Chances are that there is someone that can help you and someone that can learn from you.

5. Soft skills > technical skills

While it’s true that technical skills (like SQL, Tableau, Excel, and Python) are absolutely required, you’ll need to develop soft skills to grow in your career.

  • Communication
  • Collaboration
  • Problem-solving
  • Critical thinking

The best analysts take their 2-3 tech skills and layer on the soft skills. If you can do that, you are unstoppable!

6. You don’t need to know everything about data

I remember thinking I had to memorize long SQL formulas and know all of the normalization forms by heart. Nope. You can pick those things up when needed.

I compiled a list of cheat sheets/websites on Twitter:

7. Solving real business problems with data is fun!

Seeing an “aha moment” in your boss’s face or a client’s face when you share an insight from the data that they had no idea about is a magical feeling. 

Getting good at data analytics (to the point where you can take a brand new data set, play around for a while, and then derive some insights) just never gets old!

8. Your portfolio is the ultimate cheat code for interviews

Think about your last interview. How prepared did you feel? Chances are you prepared a lot, but still felt nervous.

Having an online data analytics portfolio takes that anxiety away:

  • The interview has already seen your work
  • You have ready examples of your best projects
  • You are able to speak to each project with confidence.

Never go into another interview without a rock-solid data analytics portfolio.

9. Writing well is the icing on the cake

Being able to write well is a MUST HAVE skill for data analysts these days:

  • Writing clearly and concisely
  • Project writeups for your boss or clients
  • Code and project documentation
  • Slack messages, emails, and more

By writing well, you will stand out from the crowd. The #1 thing I did this year is to enroll in Ship 30 for 30 (sign up today and save $100 for the final cohort for 2022 starting this month)

Next Steps

  1. Pre-order my new bookHow To Build An Awesome Online Data Analytics Portfolio in 14 Days (Preorder Special: 50% off until Oct 5th)
  2. Improve your soft skills by learning to write well

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