Dashboard / Overview

Good morning, Analyst

Build proof, not just knowledge. Your next milestone is one focused session away.

Career readiness
18%
+3% this week
Learning streak
3 days
Best: 3 days
Focused hours
4.5
of 8 hr weekly goal
Portfolio proof
0/40
projects completed

Your journey to Analytics Professional

View roadmap →
Orientation
Foundation
Spreadsheet
SQL
Statistics
Python
BI
Business
Product
Advanced
Production
Foundation — 20% complete4 of 20 lessons

Skill signals

Skill matrix →
Business thinking28%
Excel12%
SQL0%
Statistics0%

Study activity

This week
Today’s analytics mission · 50 min

Frame a business problem like an analyst

Move beyond observations. Turn a retail symptom into a measurable question and a decision.

01
Understand: The analytics lifecycle

Lesson · 12 min · Foundation

READY
02
Practice: Ask a measurable question

Exercise · 15 min · Business thinking

03
Build: Retail problem brief

Mini project · 30 min · Portfolio proof

Recent activity

All activity
Completed: What is Business Analytics?

Today · +25 XP

!
Revision due: Observation vs insight

Due today · 5 min

Set your goal: Business Analyst

Yesterday · Roadmap updated

Employability roadmap

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
BlockOutcomeTime
1. Learn
Analytics lifecycle
Explain how raw data becomes a decision25 min
2. Practice
Question framing
Turn a symptom into a measurable question20 min
3. Case
Retail conversion drop
Write an investigation brief35 min
4. Check
Quick assessment
Test key concepts10 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

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