Data Analytics Resource Hub

A hand-curated reference directory of the absolute best free learning resources, interactive sites, and documentation.

4-6 Months
Beginner Friendly
15-20 Hours

Data Analytics Roadmap – Curriculum Map

Interactive topic cluster map • Explore structured phases, topics, and subtopics below

PHASE 012 Weeks

Excel Fundamentals

Interactive curriculum map • Explore topics & subtopics below

📊 1–2. Excel Basics & Formatting⭐⭐⭐⭐⭐
Open Overview →
🧮 3. Basic Formulas⭐⭐⭐⭐⭐
SUMAVERAGEMINMAXCOUNT & COUNTAROUND, ROUNDUP & ROUNDDOWNSUBTOTALAGGREGATE
🔀 4. Logical Functions⭐⭐⭐⭐⭐
IFANDORIFERROR
🔍 5. Lookup Functions⭐⭐⭐⭐⭐
VLOOKUPXLOOKUPINDEX MATCH
🔤 6. Text Functions⭐⭐⭐⭐
LEFTRIGHTMIDLENTRIMCONCATTEXTJOIN
📅 7. Date Functions⭐⭐⭐⭐
TODAYNOWYEARMONTHDAYDATEDIF
PHASE 023 Weeks

SQL

Database BasicsSELECTWHEREGROUP BYORDER BYJOINSSubqueriesCTEs
PHASE 033 Weeks

Power BI

Power QueryDAXRelationshipsDashboardsKPIsChartsPublishing Reports
PHASE 044 Weeks

Python

Python BasicsVariablesLoopsFunctionsListsDictionaryNumPyPandas