Today, I’m sharing the specific 4 tech skills that every data analyst must learn to earn more in their careers, plus the online resources to learn each one.
When I started working with data 15 years ago, I learned by trial and error. It was grueling. And I made a lot of mistakes along the way. I wasted a lot of time because I didn’t really know where to start.
This is probably the #1 question I get from people all the time. Where do I start? What should I get started with first?
Unfortunately, there’s SO MUCH information out there it can be hard to know the exact right steps.
Start learning SQL, Tableau, Excel, and Python from books and YouTube
Here’s what most career-changers that want to get into data do:
- Search online to start their journey
- Find a certificate course or Udemy course
- Make it halfway through the course (sometimes less)
- Get bored or frustrated
Fortunately, you can skip all the stress by learning from books and YouTube videos. I recommend this method because it works for me and is pretty tried and true.
There are absolutely some great online courses out there (Google comes to mind) and I will be launching my own courses next year (stay tuned!)
But I’m talking about the endless list of $15 Udemy courses that we purchase but never complete. Those are a waste of time!
Here are the exact resources I recommend:
Step 1: Learn SQL to work with data
Working with databases using SQL is part of the job description for every data analyst.
- Querying databases using SQL syntax
- Filtering, joining and creating metrics using SQL
- Understanding how data works in these underlying systems
The great thing about SQL is that once you learn it for one platform (or RDBMS, which stands for relational database management system) you know it for pretty much every other platform.
You can learn SQL on any of these platforms:
- MS SQL
PostgreSQL and MySQL are best for beginners because they are 100% free and open source and extremely popular for small businesses and even large businesses.
MS SQL and Oracle are used for huge enterprise-level databases and are a little harder to use when you are just getting started. If you’re not sure, then start with PostgreSQL.
Learn more about SQL:
- Buy this book: SQL Quickstart Guide ($10 Kindle)
- Watch this YouTube video: SQL for Data Analysts and Data Scientists IN 1 HOUR
- Free download: 7 SQL cheatsheets for handy reference (Twitter)
Step 2: Learn Tableau to visualize data
Data visualization is the best way to help people see and understand data. And Tableau is the data viz tool I recommend.
People are visual. You need to show them the data in a way that makes sense in their brain. The best way to do that is with a visualization tool.
here are other tools out there besides Tableau for data visualization. But I recommend Tableau:
- Tableau has a free version called Tableau Public
- Tableau has an AWESOME online community
- There are TONS of jobs and freelancing gigs available with Tableau
- It’s pretty easy to get the hang of Tableau, but it takes a LONG time to master the tool.
Don’t put yourself in a bind by looking for the “perfect” data visualization tool. If you learn Tableau first, you can learn the others. More importantly, you can put your Tableau skills to work immediately and start earning more in your job or freelancing.
Get started here:
- Buy this book: Storytelling with Data ($28 Paperback)
- Watch this YouTube video: Tableau Tutorials for Beginners
- Build your portfolio: 6 websites to fast-track your portfolio (Twitter)
Step 3: Learn Excel
Tons of people use Excel every single day. It’s stood the test of time even though other products have come and gone.
Excel is used to organize, filter, sort, and share data as part of a data analyst’s job.
- Quickly share datasets with coworkers
- Put together a quick report to share ideas
- Extract data from source systems
- Create financial models and perform calculations without having coding experience
Top Excel resources for beginners:
- Buy this book: Excel: Ultimate Beginner’s Guide ($20 Paperback)
- Watch this YouTube video: Excel Tutorial for Beginners
- Sharpen your skills: 7 websites to sharpen your Excel skills today (Twitter)
Step 4: Learn Python
Python is a slightly more advanced skill, but that makes it a MUCH more valuable skill.
Python is used in data prep, blending, exploration, analysis, automation, and more!
- Data prep: pull data from sources and clean it up
- Data blending: combine data from different sources
- Exploration: answer questions based on the data
- Analysis: analyze data using powerful tools like Pandas
- Automation: build complex data pipelines to get the job done
You get the picture: Python skills are super valuable for data analysts. You can even build full-blown web applications with Python. Really, the sky is the limit.
Best resources for Python data analytics:
- Buy this book: Python for Data Analysis ($23 Paperback)
- Watch this YouTube video: Basic Guide to Pandas
- Python Data Cheat Sheets: 12 Python Data Cheat Sheets for you to download now (Twitter)
Master these 4 tech skills to stand out from the crowd.
See you again next week!
Interested in starting with data?
Whenever you’re ready, there are 2 ways I can help you:
- How To Create An Awesome Online Data Analytics Portfolio
- Need specific advice? Book a 1:1 session with me