SQL for Reporting & BI

What you’ll learn

Here you will learn the SQL patterns behind production dashboards: working with dates, window functions, and queries designed to plug into tools like Power BI, Tableau, or custom R scripts.

• Work with calendar tables and date-based metrics.
• Use window functions for running totals, rankings, and period-on-period change.
• Design “semantic” queries that BI tools can build on safely.
• Think about performance, refresh schedules, and handover to other teams.

---

Who this is for

Best for analysts who already write joins and aggregates and now want to support robust reporting workflows.

---

Enrolment & access

During the early access phase, courses will open gradually while the cloud RStudio environment is finalised. You’ll be able to sign up, log in, and launch your workspace directly from this page.