A 22-week curriculum to learn Data Analytics in 2022 + FREE Resources
It’s always day one in tech!
As the entire world countdowns to welcome the new year with hope and aspirations, I sit in front of my laptop making a roadmap to upskill and get job ready in 2022.
In this roadmap each week discusses a different topic and has roughly 4–5 hours of content so you can spend the rest of the time building things and not get stuck in tutorial hell. Always remember tech is NOT a pen paper industry, get your hands dirty, add those projects and build a portfolio.
Week 1: SQL
SQL is the meat and potatoes of data analytics and is used in almost any job in the data industry. A great tutorial for the same is -
[Mode SQL Tutorial | - Mode
Learn to answer questions with data using SQL. No coding experience necessary.mode.com](https://mode.com/sql-tutorial/ "mode.com/sql-tutorial")
Week 2: Tableau
Any one of the data visualization tool is a must have. You can choose any but I prefer Tableau because of it’s simplicity.
Week 3: Excel
Excel is a very important tool for Data Analysts. Be sure to take it all in with VBA, macros and learn while building.
Week 4–6: Statistics
Statistics is vast and immensely useful when it comes to data and it’s better to know how to whip out all the nitty gritty of the data in a giphy with it. Here’s a free tutorial by Udacity:
[Udacity
Edit descriptionclassroom.udacity.com](https://classroom.udacity.com/courses/st095 "classroom.udacity.com/courses/st095")
Week 7–8: Python Pandas
Python is a helpful tool to automate things and one can do almost everything ( visualization , data cleaning , wrangling , modelling ) with it’s vast set of libraries. Here is a free tutorial by Udemy :
https://www.udemy.com/course/master-data-analysis-with-python-intro-to-pandas/
Week 9: Power BI
Although you need just one data viz tool, I consider the basics of one more a plus.
Week 10: Google Analytics
Google Analytics is a great tool for data collection and analysis, and while it is not a must I consider it a win win. Google has a free course and certification for it .
[Google Analytics Academy
Improve your Analytics skills with free online courses from Google.analytics.google.com](https://analytics.google.com/analytics/academy/ "analytics.google.com/analytics/academy")
Week 11–12: Salesforce
This is not a must have and you can totally skip it. I read about it and found it’s a great tool to generate CRM reports a for Business Analysts, so I added it to the list.
Week 13: A/B Testing
A very important and useful application widely used by almost any firm. I just felt it required extra attention. Here’s a free course by Udacity -
[Udacity
Edit descriptionclassroom.udacity.com](https://classroom.udacity.com/courses/ud979 "classroom.udacity.com/courses/ud979")
Week 14–16: DSA in Python
As much as we hate DSA it is still an integral part of the hiring process for many organizations. It’s better to be safe and practice it at least in a familiar language Python. Here’s a free course by Google for it:
[Udacity
Edit descriptionclassroom.udacity.com](https://classroom.udacity.com/courses/ud513 "classroom.udacity.com/courses/ud513")
Week 17: Web Scraping
Now that you are familiar with all the tools it is necessary to know to get data and work with it. Internet is the biggest source of data and being able to get it out of any website puts you ahead.
Week 18: Numpy
Numpy is one of the most important libraries , it helps you transform and utilize numerical data to your liking.
Week 19: Matplotlib
Python has a lot of useful libraries. One of the essential ones for a Data Analyst is matplotlib which is used for data visualization.
Week 20: BigQuery
With Big Data emerging as the next big thing, analysts who can leverage it to gain insights would be extremely beneficial to the companies. Here’s a free SQL course on Google’s BigQuery platform:
[Learn Intro to SQL Tutorials
Practical data skills you can apply immediately: that's what you'll learn in these free micro-courses. They're the…kaggle.com](https://www.kaggle.com/learn/intro-to-sql "kaggle.com/learn/intro-to-sql")
Week 21–22: Machine Learning Basics
Business not just want to gain insights from existing data but also want to forecast the unknown. Machine learning comes into play here and Kaggle’s platform with it’s micro courses are the best place to get started.
[Learn Intro to Machine Learning Tutorials
Practical data skills you can apply immediately: that's what you'll learn in these free micro-courses. They're the…kaggle.com](https://www.kaggle.com/learn/intro-to-machine-learning "kaggle.com/learn/intro-to-machine-learning")
All of this would make you familiar with all the skills required to start a career in data. But all of this by itself is not enough, you need to practice build projects and network. Happy new year!
A blog on projects dropping soon. Stay tuned!