A

ACA Academy

Quantive Global

Career guides/How to become a data analyst
Career guide

How to become a data analyst

Most guides on this question describe the job and wish you luck. This one tells you which door the evidence says is open, which one it says is shut, and what we could not verify either way.

10 min read·Last reviewed 2026-07-30
Our position

The hardest part of becoming a data analyst is not learning SQL. It is that the title you are aiming at is often the wrong target, the job boards systematically overstate how many entry-level roles exist, and almost nobody selling you a course will say either of those things out loud.

Where this applies

Everything we can source here is specific to British Columbia, and much of it to the southwest of that province. If you are reading this from outside Canada, the skills and the proof-of-work argument travel, but the labour-market evidence, the occupation codes and the wage data do not — and we are not going to imply a Canadian job market you are not in.

"Data analyst" is not one job

The first thing that goes wrong is the search term. People decide to "become a data analyst", type that into a job board, and then try to reverse-engineer a curriculum from whatever comes back. What comes back is a blend of several different jobs that happen to share a keyword, with wildly different entry conditions.

We group the roles we actually teach toward into five families. Each one carries a mandatory counter-case, because a family presented without its caveat is a sales pitch. Here is the one closest to what most people mean by the term:

Role family — Core analytics

Turning questions into queries, models and a defensible recommendation. The centre of gravity for the Modern Data Analytics track.

The counter-case: There is no clean "Data Analyst" occupation code in Canada, so published demand and wage data for this family is fragmented across at least three unit groups and none of it maps cleanly onto the job titles employers actually post. Treat every published figure for this family as approximate.

Source: Roles & market data

That fragmentation is not a technicality. It is the reason the published demand and wage data you find will not agree with the job titles you actually see posted, and the reason a course that promises you "the data analyst career path" is flattening something that is not flat. You can see all five families, the roles inside them, and which week of our syllabus backs each taught skill on the roles and market data page.

The title most people aim at is the wrong one

When someone tries to put a number on "data analyst" demand in Canada, they usually reach for one occupation code. Here is what that code actually says about its own entry conditions:

What the occupation code says — NOC 21223

Database analysts and data administrators. TEER 1 — a bachelor's degree or college diploma is normally required, AND Statistics Canada lists prior programming experience as a normal entry condition. This is the code most often used as a "data analyst" proxy, and on the evidence it is the WRONG target for a 10–12 week graduate without a technical degree.

Source: Roles & market data

We publish that on our own market page, and we are repeating it here rather than quietly leaving it out, because it is the single most important thing a career-changer should know before choosing a target. A short program does not turn into a bachelor's degree, and no amount of enthusiasm changes what an employer has written in a job requisition.

So what is reachable?

The adjacent families. Reporting and operations analysis, business and business-systems analysis, BI development, and automation work all sit closer to where a career-changer with real artifacts can credibly enter. They are also less likely to be gated behind a computing degree. That is a different plan from the one most people arrive with, and it is a better one.

The honest version of "how to become a data analyst" is therefore: aim at the work, not the word. Get good at the thing every one of those families actually does — turn an ambiguous question into a query, a model, and a recommendation someone can act on — and stay flexible about which title finally lets you in.

The job boards are overstating the market

Before you calibrate your plan against a job-board result count, you should know how those counts are built. We checked, wrote down what we saw, and dated it:

What we saw when we checked · 2026-07-19

A job board advertised 200 entry-level analyst jobs in Vancouver. Page one had none.

We opened the "entry level data analyst, Vancouver BC" results and read the first page of listings. The titles were Senior Analyst Actuarial, Senior Business Analyst, Corporate Financial Analyst, Merchandising Services Analyst and Business Development Bid Analyst — several explicitly senior, and not one an entry-level data analyst role. The headline count is a loose keyword match against the whole posting body, not a count of jobs with that title.

Source: the page we checked
What we saw when we checked · 2026-07-19

The same pattern held for "junior Python developer" — 75 advertised, zero on the page.

Of the fifteen listings visible, none carried a junior Python title, and at least three were affirmatively senior — a Senior Python Engineer, a Staff C Programmer and an associate-level role in an unrelated discipline. We are telling you this because it is the number you would otherwise find yourself, and it is not real.

Source: the page we checked

We are not telling you this to be discouraging. We are telling you because the inflated number is the one you will find on your own, and calibrating your expectations against it is how people end up concluding they are uniquely unemployable when the real problem is that the denominator was fiction.

Run the audit yourself, once a month
  • Search the title you are targeting, in your city, filtered to the last week.
  • Read the first page of actual titles, not the result count.
  • Count how many are genuinely open to someone with no prior title in the field.
  • Write the number down with the date. Watch how it moves over a quarter.

What is actually load-bearing

Strip away the tool lists and the same small set of capabilities does the work across all five families: getting data out of a relational database, reshaping it in code, versioning what you build, putting it in front of a non-technical reader, and being able to say what you are unsure about.

What we actually teach toward this
  • 12 weeks of structured work
  • 9 weeks with an in-browser lab

Tools: 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+ · pandas · Jupyter Notebook · Python Sandbox (tools.quantiveglobal.com/python) · NumPy · SQLAlchemy · SQLite (sqlite3 / read_sql) · Snowflake · BigQuery · Dimensional Modeling (star/snowflake) · Power BI Desktop · DAX · Power Query · Snowflake / BigQuery (DirectQuery or Import) · Data Visualization Principles (data-ink ratio) · Color-contrast & colorblind-safe palettes · Data Storytelling (BLUF) · Python / pandas · SQL · Git & GitHub · sandboxes/mda-week8-mock-project/ · Git · GitHub · GitHub Copilot · dbt (concept) · Git Sandbox (tools.quantiveglobal.com/git) · VS Code · SQL (masking / generalization / strftime) · k-anonymity · PIPEDA / FIPPA / PHIPA (frameworks) · SQL (star schema) · Statistics Canada open data · Power BI (extract target) · sandboxes/mda-capstone-regional-analytics/ · Presentation (slides) · Power BI (dashboard demo) · GitHub (portfolio README) · PRESENTATION_RUBRIC.md

Source: Programs

Grade your own skills honestly

The useful mental model is to sort every skill on a target job posting into four buckets, and to be strict about the top one:

  • Verified — you have server-checked, reproducible evidence you can do it. Not "I did a tutorial". Something a stranger could run.
  • In track — it is genuinely adjacent to something you have built, and you could get there quickly.
  • Declared — you have said you can do it. That is all that means.
  • Gap — you cannot do it yet, and pretending otherwise fails at the technical screen.
This is a coverage read, not a prediction

Sorting your skills this way tells you how well you cover what a posting asks for. It does not tell you whether you will get an interview or an offer, and anyone who converts a skills match into a probability of getting hired is selling you something. We hold no outcome data and will not imply that we do.

Proof versus paper

Here is our thesis, stated as a thesis: we believe a small number of real, defensible, independently checkable projects does more for a career-changer than another certificate, because a certificate proves attendance and an artifact proves capability.

We built a company around that belief. And we are not going to tell you it is an established fact, because when we went looking for evidence, this is what we found:

We looked, and could not verify this

Whether employers accept a portfolio of shipped projects in place of a degree. We found no evidence in either direction. This is the claim our own programs rest on, and we are not going to assert it without support.

Source: Roles & market data
What we will not do

We will not show you a wall of employer logos implying our learners were hired there. We will not publish a placement percentage we have not audited. We will not describe a certificate as the product. Those tactics work, which is exactly why regulators have gone after schools that used them — and why we would rather show you the gap in our own evidence than paper over it.

We looked, and could not verify this

Which tools Metro Vancouver employers actually ask for in entry-level postings, and at what frequency. Answering this needs a coded sample of posting bodies, which occupational statistics cannot substitute for. We have not done that study, so we publish no tooling-frequency figures.

Source: Roles & market data

A plan you can actually run

The failure mode for self-teaching is breadth: a long trail of half-finished tutorials, none of which you can defend under questioning. The alternative is fewer, deeper artifacts built on real data with real mess in it.

Build three things you can defend line by line
  • Pick real open data, not a cleaned teaching dataset — public statistics agencies, municipal open-data portals and housing surveys all publish messy, genuine files.
  • Take each one end to end: get it in, clean it, model it, and produce something a non-technical reader can act on.
  • Version all of it in public, so the commit history shows how you actually worked.
  • Write down, for each project, five things you could defend if someone pushed back on them.
  • Then stop building and go practise saying them out loud.

That last step is the one people skip, and it is the one that decides interviews. We wrote a separate guide on how data-analyst interviews have changed, including the rubric we grade against.

Where this advice stops

We would rather name the edges of what we know than let you assume we know more than we do. Two more things we looked for and could not establish:

We looked, and could not verify this

Which named Metro Vancouver employers hire at entry level, and in what volume. Every employer-level claim we tested failed verification — live job boards churn too fast to cite responsibly.

Source: Roles & market data
We looked, and could not verify this

Applicant-per-posting ratios and 2025–26 B.C. technology-sector layoff data specific to junior roles. Nothing survived verification.

Source: Roles & market data

The full list of what we checked, what we found, and what we failed to verify is published on the roles and market data page — including the wage bands, with the caveats their publishers attach to them.

Where this advice stops

We publish no pay figures in these guides. The sourced wage bands, with their caveats, live on the roles and market data page.

We have never placed a graduate, so nothing here is an outcome claim. We publish no placement data and will not until we have some worth auditing.

Our evidence is British Columbia. We did not verify hiring conditions in Toronto, Calgary, or outside Canada.

Common questions

Do I need a degree to become a data analyst?
It depends entirely on which role you mean. The occupation code most often used as a "data analyst" proxy is TEER 1, where a bachelor's degree or college diploma is normally required and prior programming experience is listed as a normal entry condition — on that evidence it is the wrong target for someone finishing a short program without a technical degree. Adjacent roles in reporting, business analysis and BI development are more reachable. Whether employers accept a portfolio in place of a degree is something we went looking for and could not verify in either direction, so we do not assert it.
How long does it realistically take?
Long enough to build things you can defend, which is a different measure from course length. Our own programs run ten and twelve weeks of structured work, but the honest answer is that the timeline is set by how quickly you can produce a small number of genuinely defensible artifacts and learn to talk about them under pressure. Anyone quoting you a guaranteed timeline to employment is quoting you something they cannot know.
Is a certificate enough to get hired?
We do not think so, and we deliberately do not sell the certificate as the product. A certificate records that you attended something. An artifact someone can open, run and interrogate records that you can do the work. We would rather you finish with the second one.
Do you publish placement rates?
No. We have not placed anyone yet, so any number we published would be invented, and the recent history of this industry includes regulators taking action against schools over exactly that kind of unaudited outcome claim. When we do publish outcomes, we will publish the counting method first, in public, before the number.
Should I learn AI tools instead of fundamentals?
That framing is the trap. The tools are genuinely useful and we teach them, but their output has to be checked by someone who understands what it produced — and that checking ability is the fundamentals. We wrote a whole guide on why that is, including the part of the argument that cuts against us.

Try the free course — no card, no cohort

AI at Work is our free short course on directing, prompting and verifying AI on real business tasks. It is the discipline this guide argues for, and you can start it right now.

Start AI at Work — free Or see the programs
How to Become a Data Analyst in Canada — An Honest Guide — ACA Academy