SQL for Analysts
From your first SELECT to window functions you can defend in an interview. Eight weeks of writing real queries against messy production data with no prior coding assumed.
- Length
- 8 weeks
- Sessions
- 16 live
- Evening
- 19:00 Qatar time
- Level
- 0 → Inter.
Week by week
Reading a database
Get oriented and pull your first rows.
- SELECT · WHERE
- ORDER BY · LIMIT
- Reading a schema
- Data types
By FridayYou can answer a "how many / which ones" question from a table you've never seen.
Grouping and counting
Turn rows into summaries a manager would ask for.
- GROUP BY
- COUNT · SUM · AVG
- HAVING
- DISTINCT
By FridayYou can produce sales-by-region, orders-per-customer, and spot the outliers.
Joining tables
Stop working with one table at a time.
- INNER JOIN
- LEFT / RIGHT JOIN
- Multi-table joins
- Fan-out traps
By FridayYou can stitch orders, customers and products into one result and know when a join is lying to you.
Subqueries and CTEs
Write queries a colleague can actually read.
- Subqueries
- WITH … AS (CTEs)
- Chaining steps
- Refactoring
By FridayYou can break a scary one-liner into clear, named steps.
Window functions
The skill that separates analysts from beginners.
- ROW_NUMBER · RANK
- Running totals
- PARTITION BY
- LAG / LEAD
By FridayYou can calculate month-on-month change and rank-within-group without exporting to Excel.
Dates, text and mess
Handle the data the way it actually arrives.
- Date maths
- String functions
- NULL handling
- CASE logic
By FridayYou can clean an inconsistent export inside the query, not before it.
Why your query is slow
Make it fast enough to run in front of people.
- Indexes
- Reading EXPLAIN
- Sargable filters
- Common anti-patterns
By FridayYou can look at a slow query and form a real hypothesis about why.
Modelling for BI
Shape data so Power BI thanks you later.
- Star schema
- Fact vs dimension
- Building a view
- Handover to BI
CapstoneYou model and query a full mini-warehouse, the exact dataset Power BI week 1 picks up.
Power BI for Analysts
Get past drag-and-drop charts. Build a model, write DAX that behaves, and ship a report executives actually open. Eight weeks, ending in a portfolio dashboard that's yours.
- Length
- 8 weeks
- Sessions
- 16 live
- Evening
- 19:00 Qatar time
- Level
- 0 → Inter.
Week by week
Get and transform
Clean the export nobody wants to touch.
- Power Query
- Applied steps
- Unpivot
- Merge / append
By FridayYou can turn a broken spreadsheet into a tidy table that refreshes on its own.
Modelling relationships
Build the foundation everything else stands on.
- Star schema
- Relationships
- Cardinality
- Filter direction
By FridayYou can wire fact and dimension tables so filters flow the right way.
DAX foundations
Understand the one distinction beginners miss.
- Measures vs columns
- SUM · AVERAGE
- CALCULATE
- Variables
By FridayYou know when to write a measure and when a column, and why it matters.
Filter context
The heart of DAX, where most people get stuck.
- Row vs filter context
- CALCULATE deep-dive
- FILTER
- ALL / REMOVEFILTERS
By FridayYou can explain why a measure returns the "wrong" number and fix it deliberately.
Time intelligence
Answer every "versus last year" question.
- Date tables
- YTD · MTD
- YoY · MoM
- Rolling averages
By FridayYou can build the growth and comparison measures every dashboard needs.
Designing the report
One screen, one decision.
- Choosing visuals
- Layout & hierarchy
- Colour & labels
- Accessibility
By FridayYou can design a page an executive reads in ten seconds without asking a question.
Interactivity
Let people explore without breaking anything.
- Slicers
- Drillthrough
- Bookmarks
- Tooltips
By FridayYou can build a report that answers the follow-up question before it's asked.
Publish and govern
Ship it, and keep it running.
- Power BI Service
- Scheduled refresh
- Row-level security
- Workspaces
CapstoneYou publish a live dashboard with scheduled refresh and RLS, the portfolio piece you leave with.