Data Analyst Roadmap

Excel

Excel can only handle datasets of 10M rows, but it's still what many companies use as their primary tool for analysis.

You can also learn Power BI which is derived from excel.

 

Sources of learning:

YouTube:

 

SQL

Companies store their data in Databases so learning SQL is mandatory.

The question is, which SQL should you learn, how much SQL is enough and how will you judge yourself whether you are market ready in SQL or not?

Which SQL language should you learn? If you're willing to learn Power Bi, learn Microsoft SQL Server 2019 which uses Transact SQL/T-SQL because most of the big companies which use Power BI, work on Azure Cloud, and they use all the Microsoft products end to end.

How much SQL is enough? Work in a real environment so that you can gain skills quickly. Some courses to help out include:

 

Sources of Learning:

YouTube:

 

Power BI

After completing SQL, start Power Bi, but it's not a single concept/tool, it's a mixture of skills that are Power BI itself, Data Modelling, DAX (Data Analysis Expressions) and Power BI Service and you have to be good in each of them.

 

Sources of Learning:

 

Data Modelling & DAX

Data modelling is more important because without a proper data model, your Power BI report will fall apart and you won't get the expected results because of filter traversal between tables, writing easy DAX and RLS (Raw Level Security), your performance etc. depends on it.

 

Sources of Learning: