The Data Analyst trek
SQL, Excel, Python, Tableau, Power BI, statistics, and the storytelling skills that turn raw data into decisions. The complete path from beginner to senior analyst.
Analyst mindset & Excel foundations
How analysts think, the question-first approach, and Excel — still the most widely used analytics tool in the world.
SQL fundamentals
The most valuable skill for a data analyst. Write queries that answer business questions directly from a database.
Advanced SQL for analytics
Window functions, CTEs, and the SQL patterns that let you answer complex analytical questions without writing Python.
Python for data analysis
Pandas, NumPy, and the Python data manipulation skills that make you faster than SQL for complex transformations.
Statistics for analysts
The statistics you need to avoid making wrong conclusions: distributions, confidence intervals, hypothesis testing, and correlation vs causation.
Data visualization principles
Choosing the right chart, designing for clarity, and Matplotlib/seaborn for programmatic charts.
Tableau
Tableau Desktop from basics to published dashboards. The most in-demand BI visualization tool.
Power BI & DAX
Power BI for Microsoft-stack organizations. Data modeling, DAX measures, and building dashboards executives actually use.
Data storytelling & presentation
The skill that separates good analysts from great ones: translating data into narratives that change decisions.
Business intelligence & data modeling
Data warehouses, star schemas, dimensional modeling, and how BI tools connect to them for fast, reliable analytics.
Analytics engineering & dbt
dbt is how modern data teams transform data. Build reliable, tested, documented data pipelines as code.
Capstone — analyst portfolio project
A complete analysis from raw data to stakeholder recommendation. The artifact that gets you hired.
Trek complete. What's next?
You've walked the full roadmap. Now ship the capstone, write about it, and share the path with the next engineer who needs it.