Relational Databases & SQL Basics
Lab · Answer Five Business Questions Against a Retail Schema
SQLite (sql.js)SQL (SELECT/WHERE/GROUP BY/HAVING/JOIN)SQL Sandbox (tools.quantiveglobal.com/sql)DBeaver (desktop SQL client)
Both start with a free preview · same 59 CAD / 200 CAD pricing · billing pauses on a verified hire
Modern Data Analytics · Canada · career-changer track
Become a job-ready data analyst in 12 weeks.
For Excel power-users and career-changers. Finish with a defended, end-to-end analytics pipeline on real Canadian open data — SQL and Python into a cloud warehouse and Power BI — and a portfolio you can walk an interviewer through line by line.
12 weeks~120 hours gradedExcel users & career-changersSolo 59 CAD / Mentored 200 CAD · pauses on hire
Your learning dashboardWeekly progress · verified labs · Power BI capstone
Week 4✓ Passed
Week 5✓ Passed
Week 6In progress
12 wkProgram length~120h of graded work
Verified proofLabs + defended capstone
What you'll graduate with
12 weeks, 12 real artifacts.
Every week ends in a real, versioned artifact. They stack into one defended pipeline on genuine Canadian open data — the project you put at the top of your résumé.
Answer Five Business Questions Against a Retail SchemaWeek 1
Rank Products and Track Revenue Trends with Window FunctionsWeek 2
Build a Reusable Monthly Revenue Summary with pandasWeek 3
Wrangle the Real Seeded E-commerce Data at ScaleWeek 4
Remodel the Real Retail Schema into a Star and Prove It with SQLWeek 5
Build a Modeled, DAX-Driven Sales Report in Power BIWeek 6
Build a Focused Executive Dashboard and Data Story from Real Query OutputsWeek 7
Mock Client Project: Clean, Model, Visualize, PresentWeek 8
Version a Transformation and Ship It Through a Pull RequestWeek 9
De-identify a Customer Dataset to a k-Anonymity StandardWeek 10
Capstone Build: Ingest, Clean, Model, Extract — All VersionedWeek 11
Deliver and Defend the Capstone to a Stakeholder PanelWeek 12
Your verified public portfolioProof-linked projects & case studies
Retail churn cohort analysisVerified
311 response-time pipelineVerified
Superstore sales dashboardVerified
Verified credentialModern Data Analytics — Verified Analyst
Minted only by a passing server-graded run — never self-asserted.
A credential of verified skill — not a placement claim. Add it to LinkedIn the moment it's earned.
Also prepares you to sit Microsoft PL-300 (Power BI Data Analyst) — the industry exam for the Power BI, DAX and Power Query skills this track builds. The exam is taken with Microsoft; ACA is not affiliated. A supplement to your proof-of-work, never a substitute for it.
The full syllabus
Week-by-Week Modern Data Analytics Syllabus
SQL and Python run in the browser from week one. AI drafts, you verify and own every query. Real curriculum, exactly as taught.
Inside a week · Week 1
Relational Databases & SQL Basics
Every module is built the same honest way — a guided lecture, a hands-on lab in a real in-browser sandbox, and an AI-twist that trains judgment. A server grader checks the result.
LectureGuided labAI-twist Verified proof
Lab — Answer Five Business Questions Against a Retail Schema
- Read a relational schema and explain how tables relate through primary and foreign keys
- Write SELECT queries with WHERE filtering and ORDER BY sorting that answer a specific business question
- Aggregate data with GROUP BY, COUNT, SUM, and AVG, and know why non-aggregated columns must be grouped
- Filter grouped results with HAVING and explain why WHERE cannot see an aggregate
In-browser labWrite, run & verify — no install
SELECT region, COUNT(*) AS nFROM orders GROUP BY region;
✓ Query runs✓ Output verified
description
Get the detailed week-by-week syllabus (PDF)
The full Modern Data Analytics breakdown — lecture focus, lab walkthrough, AI-workflow detail, and tools for every week — generated straight from this curriculum. Tell us where to send it.
Phase 1 · SQL for analysts
~10h
Advanced SQL for Enterprise Analysis
Lab · Rank Products and Track Revenue Trends with Window Functions
SQLite (sql.js)CTEs (WITH)Window Functions (RANK/LEAD/LAG/SUM OVER)SQL Sandbox (tools.quantiveglobal.com/sql)
Phase 2 · Python for data
Python for Data Automation (Part 1)
Lab · Build a Reusable Monthly Revenue Summary with pandas
Python 3.11+pandasJupyter NotebookPython Sandbox (tools.quantiveglobal.com/python)
Python Data Wrangling (Part 2)
Lab · Wrangle the Real Seeded E-commerce Data at Scale
Python 3.11+pandasNumPySQLAlchemy
Phase 3 · Cloud & BI
Cloud Infrastructure & Data Modeling
Lab · Remodel the Real Retail Schema into a Star and Prove It with SQL
SnowflakeBigQuerySQLite (sql.js)Dimensional Modeling (star/snowflake)
Advanced BI & Data Modeling in Power BI
Lab · Build a Modeled, DAX-Driven Sales Report in Power BI
Power BI DesktopDAXPower QuerySnowflake / BigQuery (DirectQuery or Import)
UI/UX for Dashboards & Data Storytelling
Lab · Build a Focused Executive Dashboard and Data Story from Real Query Outputs
Power BI DesktopData Visualization Principles (data-ink ratio)SQL Sandbox (tools.quantiveglobal.com/sql)Color-contrast & colorblind-safe palettes
Phase 4 · Integrate & ship
Mid-Program Mock Project & Review
Lab · Mock Client Project: Clean, Model, Visualize, Present
Python / pandasSQLPower BI DesktopSQL Sandbox (tools.quantiveglobal.com/sql)
Analytics Engineering & Modern Workflows
Lab · Version a Transformation and Ship It Through a Pull Request
GitGitHubGitHub Copilotdbt (concept)
Canadian Data Privacy, Ethics & Compliance
Lab · De-identify a Customer Dataset to a k-Anonymity Standard
SQLite (sql.js)SQL (masking / generalization / strftime)k-anonymityPIPEDA / FIPPA / PHIPA (frameworks)
Phase 5 · Capstone & defense
Capstone Execution — End-to-End Regional Market Analytics Pipeline
Lab · Capstone Build: Ingest, Clean, Model, Extract — All Versioned
Python / pandasSQL (star schema)Statistics Canada open dataGit & GitHub
Capstone Delivery — Executive Presentation
Lab · Deliver and Defend the Capstone to a Stakeholder Panel
Presentation (slides)Power BI (dashboard demo)GitHub (portfolio README)PRESENTATION_RUBRIC.md Verified proof
The tool stack
44 real tools — Canadian analyst job posts.
SQL and Python run in the browser first; warehousing and Power BI mirror what you'll use on the job.
SQLite (sql.js)SQL (SELECT/WHERE/GROUP BY/HAVING/JOIN)SQL Sandbox (tools.quantiveglobal.com/sql)DBeaver (desktop SQL client)CTEs (WITH)Window Functions (RANK/LEAD/LAG/SUM OVER)Python 3.11+pandasJupyter NotebookPython Sandbox (tools.quantiveglobal.com/python)NumPySQLAlchemySQLite (sqlite3 / read_sql)SnowflakeBigQueryDimensional Modeling (star/snowflake)Power BI DesktopDAXPower QuerySnowflake / BigQuery (DirectQuery or Import)Data Visualization Principles (data-ink ratio)Color-contrast & colorblind-safe palettesData Storytelling (BLUF)Python / pandasSQLGit & GitHubsandboxes/mda-week8-mock-project/GitGitHubGitHub Copilotdbt (concept)Git Sandbox (tools.quantiveglobal.com/git)VS CodeSQL (masking / generalization / strftime)k-anonymityPIPEDA / FIPPA / PHIPA (frameworks)SQL (star schema)Statistics Canada open dataPower BI (extract target)sandboxes/mda-capstone-regional-analytics/Presentation (slides)Power BI (dashboard demo)GitHub (portfolio README)PRESENTATION_RUBRIC.md
The capstone — real Canadian open data
One defensible pipeline on genuine public data.
A toy dataset proves nothing. Choose a real regional question, pull the actual government data with full provenance, and build the whole pipeline — then defend it to a mock stakeholder panel.
Pre-wired default
Regional Market Analytics
Which provinces are growing fastest, and how does that track population? — for a regional strategy lead.
Real datasetStatistics Canada (retail trade, population)
View dataset
View dataset
Option
Transit Service Reliability
Which stations, routes, and causes drive the most lost service minutes? — for a transit service-planning team.
Real datasetCity of Toronto Open Data — TTC subway/bus/streetcar delay data
View dataset
View dataset
Option
Rental Housing Affordability
Where is rent least affordable relative to income, and which markets are tightening fastest? — for a municipal housing-policy office.
Real datasetCMHC Rental Market Survey (rent, vacancy, turnover); StatCan household income (optional enrichment)
View dataset
View dataset
Each capstone is a live, server-graded sandbox project — the passing run is what mints your green verified badge. SampleProjects is private, so a "Source" link is expected to 404 when you are logged out.
Get hired with this program
Finishing the course is halfway. We work the rest with you.
Career OS gets you interview-ready end to end, and your verified work goes in front of employers through our recruiter portal and a Canadian hiring-partner network we're building now.
Career OS — the whole job hunt in one place
Résumé tailoring with an ATS-friendly PDF, a mock interviewer, screener practice, STAR feedback, and an application tracker.
Recruiter portal — seen by employers
Consent to share, and a recruiter sees your work ranked by verified labs, verified capstones and a skills-coverage band — never a placement rate, interview score, or salary.
Billing that pauses when you're hired
On the Mentored plan, submit proof of a job — we verify it and pause your subscription automatically. Not an ISA, not a lump sum.
Career OSRésumé tailoring · mock interview · tracker
✓ Résumé tailored to the role
✓ Cover letter drafted
✓ Mock interview practised
✓ 3 applications tracked
The employer's viewApplicants ranked by verified proof
CCandidate · consented
Verified · labsVerified · capstoneSelf-reported
Skills coverageStrong
Target first-role band · CanadaCAD $50–65k
A sanctioned, conservative entry band for a first analyst role — not a promise, and never a cherry-picked high. We'll publish real graduate outcomes only after we've earned and audited them. No placement stats or testimonials until then.
Explore free · upgrade when you're ready
Three ways in — starting free.
Preview the whole thing for free, no card. Learn at your own pace. Or go all-in on the outcome — a plan that pauses when you're hired.
Free — Explore
$0
No card. Create an account and start a real Week-1 sample in minutes.
- Week 1 of your track + one interactive lab
- Start a portfolio profile
- Community & cohort-date emails
- Upgrade anytime — keep your account
Verified proof & the full curriculum unlock on a paid plan.
Solo — Learn
49 CAD–59 CAD / month
49 CAD for Foundation, 59 CAD for Modern Data Analytics.
- Full curriculum for the track you choose
- All interactive labs
- Verified portfolio & credentials
- Learn-only · upgrade anytime
Most supportMentored — Get Hired
200 CAD / month
Everything, plus the team and the access that get you to the interview.
- Everything in Solo
- Career OS + mentorship & cohort
- Recruiter & employer access
- Billing pauses when you're hired
15-day full refund before your cohort begins.
What "pauses when you're hired" actually means
Enrol
Learn & job-hunt · 200 CAD/mo
Hire verified
Billing paused
You pay the flat 200 CAD/month while you learn and job-hunt. When you submit proof of a job and we verify it, we call Stripe and pause your subscription — automatically. Not an income-share agreement, not a lump sum. Plus a 15-day full refund if you change your mind before your cohort starts.
Objections, answered
Straight answers on proof, price & the pause-on-hire promise.
Every concern you have has been heard before. No spin — here's how proof, billing, and life after enrollment actually work.
No lock-in. You pay 200 CAD per month and can pause billing anytime by submitting verified employment proof. If you land a role before you finish the program, billing pauses immediately — you keep your content access for portfolio reference.
A job offer letter, employment contract, or LinkedIn profile update showing your new role. We verify within 24 hours and pause billing automatically. No drama, no approval queue.
Career change is the product
Ready to build the Modern Data Analytics proof package?
Enroll to start building, or grab the full week-by-week syllabus first. A real person replies in writing within one business day.
Billing pauses on hire15-day refund