How to start the journey of becoming a Data Analyst?
I will explain you Week by Week, how you should study analytics and become a successful Data Analyst.
To start your journey of becoming a Data Analyst. First, you need to understand the meaning of Data Analytics and what a data analyst does. Then start relating with your skillset, do you fit in the kind of job skillset that is required.
For example, if you are creative but you don’t have analytical mindset, then you won’t be successful in this field. With analytical mindset, I mean that you are good with numbers, data and other related things.
Once you have figured out that you can become a Data Analyst, then start studying the most important languages and tools for doing various data analysts tasks.
The most important tasks done by a Data Analysts are:
- Data Gathering
- Data Cleaning
- Data Modelling
- Data Interpretation
- Data Presentation
Some of the most used tools by a Data Analysts to complete these tasks are:
- Microsoft Excel
- Google Sheets
- SQL
- Microsoft Power BI | Tableau
- Python
Tried & Tested Roadmap to become a Data Analyst:
Week1: Understanding the basics of Data, Analytics and computer concepts.
Week2: Basics of Excel
Week3: Advanced Excel
Week4: Getting started with Power Pivot
Week5: Advanced Power Pivot
Week6: Capstone Projects using Excel & Power Pivot
Week7: Getting started with SQL queries
Week8: Intermediate queries of SQL
Week9: Advanced SQL
Week10: Capstone Project using SQL
Week11: Getting started with Power BI
Week12: Working on DAX language in Power BI
Week13: Capstone Project on Power BI
Week14: Capstone Project using Power BI & SQL
Week15: Getting started with Python
Week16: Learn in-depth Python (Important libraries)
Week17: Side-by-side study Mathematics subjects such as Probability, Statistics, Linear Alegbra
Week18: Capstone Project on Python Coding (Mathematical models)
Week19: Watch more videos and understand the industry practical problems
Week20: Practice
Once you’re done with these skills, then you can study Cloud Computing, API concepts, Machine Learning as well.
If you get stuck anywhere, you can connect with me. I have my own channel analyticalguy (YouTube) where I explain all these concepts for beginners as well as intermediate users.