Technical Skills Required to become a data analyst 😄👇

Tool 1: MS-Excel (Google sheets knowledge is a plus)

👉 Lookups (vlookup, xlookup, hlookup and its use cases)
👉 Pivot tables, Pivot charts
👉 Power Query, Power Pivot
👉 Conditional formatting
👉 Various charts and its formatting
👉 Basic VBA/Macro
👉 Major Excel functions/formulas (text, numeric, logical functions)

Tool 2: SQL (with any one RDBMS tool)

👉 Database fundamentals (primary key, foreign key, relationships, cardinality, etc.)
👉 DDL, DML statements (commonly used ones)
👉 Basic Select queries (single table queries)
👉 Joins and Unions (multiple table queries)
👉 Subqueries and CTEs
👉 Window functions (Rank, DenseRank, RowNumber, Lead, Lag)
👉 Views and Stored Procedures
👉 SQL Server/MySQL/PostGreSQL (any one RDBMS)
👉 Complete Roadmap for SQL

Tool 3: Power BI (equivalent topics in Tableau)

👉 Power Query, Power Pivot (data cleaning and modelling)
👉 Basic M-language and Intermediate DAX functions
👉 Filter and row context
👉 Measures and calculated columns
👉 Data modelling basics (with best practices)
👉 Types of charts/visuals (and its use cases)
👉 Bookmarks, Filters/Slicers (for creating buttons/page navigation)
👉 Advanced Tooltips, Drill through feature
👉 Power BI service basics (schedule refresh, license types, workspace roles, etc.)
👉 Power BI Interview Questions

Tool 4: Python (equivalent topics in R)

👉 Python basic syntax
👉 Python libraries/IDEs (Jupyter notebook)
👉 Pandas
👉 Numpy
👉 Matplotlib
👉 Scikitlearn

You may learn a combination of any 3 of these tools to secure an entry-level role and then upskill on the 4th one after getting a job.

➡ Excel + SQL + Power BI/ Tableau + Python/ R

So, in my learning series, I will focus on these tools mostly.

If we get time, I'll also try to cover other essential Topics like Statistics, Data Portfolio, etc.

Obviously everything will be free of cost.

Stay tuned for free learning

Share with credits: https://t.me/sqlspecialist

Hope it helps :)