A deliberate path from analytical fundamentals to production-capable professional work.
Today's Analytics Mission
A focused 2-hour sequence designed around your current learning edge.
Mission plan
FOUNDATION
Block
Outcome
Time
1. Learn Analytics lifecycle
Explain how raw data becomes a decision
25 min
2. Practice Question framing
Turn a symptom into a measurable question
20 min
3. Case Retail conversion drop
Write an investigation brief
35 min
4. Check Quick assessment
Test key concepts
10 min
Spaced review
Your memory queue uses short checks before skills fade.
↻
Observation vs. insight
Day 3 review · 3 prompts
↻
Types of analytics
Day 7 business scenario
Learning Library
Explain → demonstrate → try → evaluate. No passive learning.
Level 0 · Orientation
✓ What is Business Analytics?
02 The analytics lifecycle
03 Framing a business question
04 Analyst roles and value
Level 1 · Spreadsheets
Spreadsheet fundamentals
Formulas that answer questions
Level 2 · Statistics
Statistics from intuition
LEVEL 0 · 12 MINUTES
The analytics lifecycle
Analytics is the disciplined process of turning a business decision into a question, then turning evidence into an action. A dashboard alone is not analytics; it becomes valuable when it changes what someone does next.
Simple analogy: Think of an analyst as a doctor. A business symptom—such as falling sales—is not the diagnosis. You ask questions, gather evidence, identify the cause, and recommend a treatment.
Six steps that make analysis useful
1. Frame the decision. 2. Collect relevant data. 3. Clean it so it can be trusted. 4. Analyze patterns and causes. 5. Communicate a clear recommendation. 6. Measure whether the action worked.
Business symptom: “Orders fell last month.”
Question: “Which customer segment and acquisition channel explain the decline?”
Decision: “Where should the marketing team change next month’s spend?”
Success measure: “Restore conversion rate to 3.2% without raising CAC.”
Try it yourself — 5 minutes
A food-delivery app says, “Customers are leaving.” Write one measurable question, name two data sources, and state the decision your analysis should enable.
SQL Practice Lab
Write queries against realistic business data. Solutions unlock after your attempt.
E-commerce database EASY
01 · Orders by customer
Use SELECT, JOIN, and COUNT
02 · Revenue by category
Aggregation · GROUP BY
03 · Returning customers
CTE · Business definition
04 · Monthly retention
Window functions
Find each customer and the number of orders they have placed.
Tables: customers(customer_id, name, segment) and orders(order_id, customer_id, order_date, amount). Include customers with no orders.
query.sql · PostgreSQL
✓ Query executed successfully
name
order_count
Priya Shah
4
Arjun Mehta
2
Maya Iyer
0
Business interpretation: Maya has not converted after signup. This is a lead for retention or onboarding investigation.
Knowledge check
Answer first. Feedback explains the analyst mindset—not only the answer.
Question 1 of 5 · Foundation
A retailer reports a 15% drop in online revenue. What is the strongest first analytical question?
Production Project Lab
Every project produces a business narrative, proof of skill, and portfolio-ready artifact.
Case Interview Lab
Ambiguous business problems. Your thinking comes before any solution.
CONSULTING · INTERMEDIATE
Retail conversion drop
Northstar Retail’s online revenue fell 15% in May. The CMO wants a recommendation before next week’s campaign planning meeting. You have traffic, orders, marketing-channel, product, and web-event data.
Your first response
What would you clarify before you analyze? Structure the problem and state your initial hypotheses.
Case method
1
Clarify decision & scope
Who needs to decide what, and by when?
2
Build a metric tree
Revenue = traffic × conversion × AOV
3
Prioritize hypotheses
Start with likely, high-impact explanations.
4
Recommend an action
State expected impact and how to measure it.
Elite Analytics Interview Center
Practice the technical, business, and communication signals hiring teams look for.
TECHNICAL
SQL Interview Simulator
Five escalating questions in 30 minutes. Get feedback on correctness, readability, and business interpretation.
0/45 challenges
BUSINESS
Case Interview Simulator
Frame ambiguous problems, make assumptions, analyse drivers, and communicate a decision.
1 active case
BEHAVIORAL
Story Builder
Turn genuine project experiences into structured, evidence-led interview stories. Never invent outcomes.
0 stories drafted
Portfolio Builder
Your proof of work, translated into recruiter-ready narratives.
Portfolio readiness
0%
▣
No published project proof yet
Complete a project to generate its GitHub README outline, resume bullets, LinkedIn description, and interview explanation.
Business Metrics Dictionary
Know the definition, formula, decision context, and common mistake behind every key metric.
Customer Acquisition Cost
CAC = acquisition spend ÷ new customers
Why it matters: Shows what the company spends to win each new customer. Pair it with LTV, not in isolation.
Marketing · SaaS
Retention rate
(end customers − new) ÷ start customers
Why it matters: Reveals whether customers keep receiving value. Define the period and active-customer rule first.
Product · SaaS
Conversion rate
conversions ÷ eligible visitors
Why it matters: Identifies how efficiently a funnel turns opportunity into value. Never mix unmatched denominators.
E-commerce · Product
Average Order Value
revenue ÷ number of orders
Why it matters: Separates basket-size changes from traffic or conversion movements.
Retail · E-commerce
Monthly Recurring Revenue
sum of monthly subscriptions
Why it matters: A predictable revenue baseline for subscription businesses. Track expansion and churn separately.
SaaS
Gross margin
(revenue − COGS) ÷ revenue
Why it matters: Measures value left after direct costs, before operating expenses.
Finance
Build your personal roadmap
We’ll set your starting point and make a free-first plan towards employability.