A

ACA Academy

Quantive Global

Prove your skills

Guided Projects

Real, role-shaped projects on Canadian open data. Build one end to end in the sandbox, then defend it — passing work is verified proof and lands straight on your portfolio. Browsing is free; doing a project opens the gated sandbox.

Verified on completion

Regional Market Analytics

Which provinces are growing fastest, and how does that track population? — for a regional strategy lead.

SQLPython · pandasGitPower BI
tools.quantiveglobal.com/projects/mda-capstone-regional-analytics
Guided project workspaceIngest → clean → model → extract · versionedgated sandbox — sign in to build

Verified capstone projects

Each passes a nonce-guarded server grader — the green badge is earned on completion and can never be self-awarded.
Verified on completionCareer-changer

Regional Market Analytics

Which provinces are growing fastest, and how does that track population? — for a regional strategy lead.

SQLPython · pandasGitPower BI
Real open dataStatistics Canada (retail trade, population)
Verified on completionCareer-changer

Transit Service Reliability

Which stations, routes, and causes drive the most lost service minutes? — for a transit service-planning team.

SQLPython · pandasGit
Real open dataCity of Toronto Open Data — TTC subway/bus/streetcar delay data
Verified on completionCareer-changer

Rental Housing Affordability

Where is rent least affordable relative to income, and which markets are tightening fastest? — for a municipal housing-policy office.

SQLPython · pandasPower BI
Real open dataCMHC Rental Market Survey (rent, vacancy, turnover); StatCan household income (optional enrichment)
Verified on completionBeginner

Local Climate Trends

How have local temperatures and precipitation shifted over the past few decades at one weather station? — for a city sustainability team.

Pythonpandas
Real open dataEnvironment and Climate Change Canada — Historical Climate Data
Verified on completionBeginner

City Services Explorer

Which Toronto civic centre issues the most marriage licences, and how does demand swing by season? — for a service-planning clerk.

PythonSQL
Real open dataCity of Toronto Open Data — Marriage Licence Statistics
Verified on completionBeginner

Cost of Living Snapshot

How much more does a typical basket of everyday goods cost now than a decade ago? — for a household-budgeting explainer.

Pythonpandas
Real open dataStatistics Canada — Consumer Price Index, monthly, not seasonally adjusted (Table 18-10-0004-01)

Interactive labs

Hands-on, in-browser SQL / Python / Git — real code from week one, no local setup.
Interactive Python labFoundation · Wk 1

Python Fundamentals: Environment Setup & Core Language Basics

Python

Hands-on, in-browser Python — real code from week one, no local setup.

Interactive Git labFoundation · Wk 2

Version Control with Git & GitHub

Git

Hands-on, in-browser Git — real code from week one, no local setup.

Interactive SQL labFoundation · Wk 3

SQL for Decisions: From Raw Tables to Business Recommendations

SQL

Hands-on, in-browser SQL — real code from week one, no local setup.

Interactive Python labFoundation · Wk 7

Data Analysis with Python: pandas, Plots, and Business Insights

Python

Hands-on, in-browser Python — real code from week one, no local setup.

Interactive SQL labFoundation · Wk 8

Intermediate SQL: Joins, Aggregations, and Analytics Stories

SQL

Hands-on, in-browser SQL — real code from week one, no local setup.

Interactive Python labFoundation · Wk 9

Automation Workflows: Combining Python, SQL, and APIs

Python

Hands-on, in-browser Python — real code from week one, no local setup.

Interactive SQL labMDA · Wk 1

Relational Databases & SQL Basics

SQL

Hands-on, in-browser SQL — real code from week one, no local setup.

Interactive SQL labMDA · Wk 2

Advanced SQL for Enterprise Analysis

SQL

Hands-on, in-browser SQL — real code from week one, no local setup.

Interactive Python labMDA · Wk 3

Python for Data Automation (Part 1)

Python

Hands-on, in-browser Python — real code from week one, no local setup.

Interactive Python labMDA · Wk 4

Python Data Wrangling (Part 2)

Python

Hands-on, in-browser Python — real code from week one, no local setup.

Interactive SQL labMDA · Wk 5

Cloud Infrastructure & Data Modeling

SQL

Hands-on, in-browser SQL — real code from week one, no local setup.

Interactive SQL labMDA · Wk 8

Mid-Program Mock Project & Review

SQL

Hands-on, in-browser SQL — real code from week one, no local setup.

Interactive Git labMDA · Wk 9

Analytics Engineering & Modern Workflows

Git

Hands-on, in-browser Git — real code from week one, no local setup.

Interactive SQL labMDA · Wk 10

Canadian Data Privacy, Ethics & Compliance

SQL

Hands-on, in-browser SQL — real code from week one, no local setup.

Interactive Git labMDA · Wk 11

Capstone Execution — End-to-End Regional Market Analytics Pipeline

Git

Hands-on, in-browser Git — real code from week one, no local setup.

More guided projects

The library is growing — we ship each project only when it is real and graded.
Coming soon

Advanced — Predictive Analytics capstone

MLPython

Part of the Advanced specialization — announced when that track opens for enrollment.

Coming soon

Enterprise-AI — Agentic pipeline capstone

LLMAgents

Part of the Enterprise-AI specialization — announced when that track opens for enrollment.

Coming soon

More open-data briefs

SQLPython

The guided-project library keeps growing — we ship each one only when it is real and graded.

Everything marked Verified on completion is a live, graded sandbox project on real Canadian open data — the green badge is minted only after a passing server-graded run, so it can never be self-awarded. Interactive labs are real and hands-on; “coming soon” tiles are roadmap and are not enrollable yet — we label them so the library’s growth is honest.

Guided Projects — ACA Academy