PM Mapped
Home / Module 5 / The PM Analytics Stack
21
MODULE 5 · ANALYTICS IN PRACTICE · TOOL 21

The PM Analytics Stack

The set of tool categories every PM interacts with, each answering a different kind of product question. Mapping them prevents the common mistake of using the wrong tool for the question.

▸ Try the interactive tool
SolvesA pretty dashboard built on broken data you can’t trust.
Category · Analytics in Practice Complexity · Beginner–Mid Time to apply · Reference Pairs with · SQL Fundamentals
A WHAT IT IS

The framework

The PM analytics stack is the set of tool categories every PM interacts with, each answering a different kind of product question. The point of mapping them is practical: understanding which tool answers which question prevents the common mistake of reaching for the wrong tool — trying to answer a 'why' question with a dashboard, or a 'what happened' question with session replay.

The categories span the journey from raw data to decision: product analytics (events, funnels, retention — the 'what'), session replay / qualitative (watching real usage — the 'why'), BI / dashboards (monitoring known metrics), data warehouse + SQL (ad-hoc deep questions), experimentation platforms (causal tests), customer feedback / VoC (sentiment), and CRM / revenue tools. The skill isn't mastering all of them — it's knowing the type of question each answers, so you go to the right place rather than forcing one tool to do another's job.

THE TOOL CATEGORIES (each answers a different question)

Product analytics — what happened (events, funnels) · Session replay / qual — why · BI / dashboards — monitor known metrics · Warehouse + SQL — ad-hoc deep questions · Experimentation — causal · VoC / feedback — sentiment.

TRY IT

Try it yourself

B WHY IT MATTERS

What it prevents

PMs routinely use the wrong category for the question — hunting for 'why' in a dashboard, or 'what happened' in a survey — and get frustrated that the tool can't answer what it was never meant to.

The shortcutWhat it costsWhat it gives you instead
Wrong tool for the questionAsking a dashboard 'why' or analytics for sentiment.Mapping tools to question types sends you to the right one.
Forcing one tool everywhereTrying to do everything in one category badly.Each category answers its own kind of question well.
Missing the right capabilityNot knowing a category exists for your question.The map reveals which tool can actually answer it.
Confusing what and whyTreating analytics' 'what' as if it explained 'why'.Separating product analytics from qualitative tools clarifies it.
C HOW TO RUN IT

Step by step

1

Know the categories and what each answers

Learn the seven-or-so categories and the question-type each addresses — 'what happened' (product analytics), 'why' (session replay, qual), 'how's the known metric' (dashboards), and so on.

2

Start from your question, then pick the tool

Frame the question first, then choose the category that answers that type of question. Going tool-first leads to forcing the wrong instrument onto the job.

3

Don't ask one tool another's question

Resist hunting for 'why' in a dashboard or 'what happened' in a survey. When you hit a tool's limit, switch categories rather than forcing it.

4

Combine categories for full answers

Real questions often need several: analytics finds the 'what' (a drop-off), session replay reveals the 'why', an experiment validates the fix. The stack works together.

5

Match your depth to your needs

You don't need mastery of all categories — just enough fluency to know which answers which question, and enough depth in the ones you use most (often SQL, Tool 22).

D IN PRACTICE

A short illustration

IN PRACTICEthe wrong tool

A PM, puzzled by a sudden metric change, spent hours in the BI dashboard slicing the number every way — trying to find why it had moved. The dashboard could show that it moved and break it down, but it fundamentally couldn't answer 'why'; that wasn't the category's job.

Mapping the stack made the path obvious: the dashboard answers 'how's the known metric doing,' product analytics answers 'what happened in the funnel,' but 'why did users behave differently' needed session replay and qualitative research. Switching to the right category answered in minutes what hours in the wrong tool couldn't — because the question and the tool finally matched.

The lesson: most analytics frustration comes from asking a tool a question it was never built to answer. The stack's value is knowing which category answers which type of question — so you reach for 'why' tools for why, and 'what' tools for what.
E THE ARTIFACT

The question→tool map

The deliverable is a working map of which tool category answers which type of question — so you start from the question and pick correctly.

QuestionTool category
What happened? (funnels, retention)Product analytics
Why did users do that?Session replay, qualitative
How's our known metric?BI / dashboards
An ad-hoc deep data questionWarehouse + SQL
Did the change cause it?Experimentation platform
How do users feel?VoC / feedback
F THE SO-WHAT

Why it matters

THE KEY INSIGHT

The analytics stack is less about tools than about questions. Each category answers a distinct type of question, and the recurring PM mistake is forcing one to answer another's — most often hunting for 'why' in tools that only show 'what'.

The what-versus-why distinction is the most consequential one to internalise, because it recurs everywhere in this module. Product analytics, dashboards, and warehouses all answer variations of 'what happened' and 'how much' — they're powerful and they're silent on causation and motivation. 'Why' lives in a different category entirely: session replay, qualitative research, customer feedback. A PM who confuses the two burns hours trying to extract 'why' from a dashboard that structurally cannot provide it. The mature use of the stack is to start from the question, route it to the category built to answer that type, and combine categories for complete answers — analytics to find the drop, qualitative to explain it, experimentation to validate the fix. Fluency in the map matters more than mastery of every tool.

G MISTAKES & LIMITS

Common mistakes

Asking a tool the wrong question type

Dashboards don't answer 'why.' Match the question type to the category.

Going tool-first

Forcing your favourite tool onto every question. Start from the question.

Confusing what with why

Analytics shows what happened, not why. Use qualitative tools for why.

Trying to master everything

You need fluency in the map, depth only in the tools you use most.

When not to use it

H CONNECTS TO

Where this sits in the toolkit

Deepened by → SQL Fundamentals

The warehouse+SQL category gets its own treatment (Tool 22) — the most empowering for PMs.

Feeds → Building Dashboards

The BI/dashboard category is detailed in Tool 23.

Embodies → the what/why distinction

The map operationalises 'analytics shows what, not why' (Tool 12, Module 3 Tool 09).

Supports → the whole module

Every metric and method in Module 5 lives in one of these categories.

I WORKING WITH AI

How AI changes this in practice

AI is now woven through the analytics stack itself — most tools have AI features — and it changes how a PM works across them.

  • Query in natural language: many analytics and BI tools now let you ask questions in plain English instead of building queries by hand.
  • Bridge the categories: AI can help you move from a 'what happened' finding to hypotheses about 'why', though the why still needs qualitative work.
  • Summarise across tools: ask it to synthesise findings you've pulled from different parts of the stack.

The judgment that stays yours: AI makes every layer faster to query but doesn't change the core skill: knowing which tool answers which question. It also can't supply causation or motivation — a confident AI summary of 'what happened' is still silent on 'why'.

Go deeper → full AI guide with examples & a copy-paste template
TRY IT YOURSELF

Route three questions

Take three questions: 'how many users completed onboarding last week?', 'why are users abandoning at step 3?', 'did our new flow cause the change?' Assign each to the right tool category.

Notice that they need three different categories — and what goes wrong if you ask the 'why' one in a dashboard.

If the 'why' question needs session replay or qualitative tools rather than the dashboard, you've internalised the map's core lesson: match the question type to the tool built for it.