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)
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.)
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 (or) Tableau
âž¡ Excel + SQL + Python (or) R
Websites that provide hands-on practice for hashtagSQL queries, which can be helpful for data analyst interviews:
1. SQLZoo (https://sqlzoo.net/)
2. HackerRank (https://lnkd.in/gnFS4frz)
3. LeetCode (https://lnkd.in/gkCpv7NA)
4. Mode Analytics (https://lnkd.in/gRPrQrf5)
5. SQL Bolt (https://sqlbolt.com/)
6. W3Schools (https://lnkd.in/gpeym7n7)
7. Codecademy (https://lnkd.in/gNhsJepU)
8. Kaggle (https://lnkd.in/gpmy7ReZ)
9. Hackerearth (https://lnkd.in/gmD7jGZU)
10. Strata Scratch (https://lnkd.in/gYtZQY53)
11. DataLemur (https://datalemur.com/)
