Track · Orbital Analytics
4 weeks · 4 missions · 0 in cohort
AI Data Analyst
Ask the data anything. Ship the dashboard. Defend the number.
§01 / The brief
Why this track exists.
An analyst track for the AI era. You will work with real datasets, build the warehouse muscle that doesn't break, and use models to accelerate — not replace — your judgment.
Warehouse muscle that doesn't break, with models as a thinking partner.
§02 / Who it's for
You are…
- →Analysts levelling up
- →Founders who own their own numbers
- →Ops people drowning in spreadsheets
§03 / What you'll learn
By the end…
- ✓SQL with AI pair-thinking
- ✓Modeling with dbt
- ✓Dashboards that earn trust
- ✓Telling the story behind the number
§05 / Missions
The work, in order.
- 01SQL with AI
Set up the workspace. Pair-think your way through complex queries.
lesson - 02Modeling with dbt
Build a clean, tested warehouse layer on a real dataset.
challenge - 03Dashboard your stakeholder uses
Design the surface and the metrics behind it.
challenge - 04Story behind the number
Write a defensible analysis. Present it. Take the questions.
peer_review
§06 / Tools
Your stack.
SQLdbtMetabasePythonOpenAIDuckDB
Tools shift fast. We teach the workflow so you can swap any of these without losing a beat.
§07 / What you ship
Portfolio you can defend.
- ◆A modeled warehouse on a real dataset
- ◆A dashboard your stakeholder actually uses
- ◆A written analysis with a defensible conclusion
§08 / FAQ
Common questions.
Do I need to know SQL?+
Basic SELECT is enough — we accelerate the rest.
§09 / Related
Stack it with…
Next cohort