Business Analytics for Data Analysts

Why Technical Skills Alone Are Not Enough

A data analyst who can write perfect SQL but cannot explain what the numbers mean for a business decision is a data technician, not a business analyst. The analysts who get promoted, earn more, and gain stakeholder trust are the ones who add a thinking layer on top of the technical layer — who frame the right question before writing a single query.

The MECE Framework — Structure Any Analysis

MECE (Mutually Exclusive, Collectively Exhaustive) is a structuring discipline that prevents two common analysis errors: double-counting and missing cases.

Metric Trees — Map What Drives Your KPIs

A metric tree decomposes a top-level KPI into its mathematical drivers. When the KPI moves, you drill the tree to find exactly which sub-metric is responsible.

Root Cause Analysis — The 5 Whys in Practice

The 5 Whys works best when each answer is supported by data, not assumption. If you cannot answer a "why" with data, that is your next query to write — not a guess to fill in.

Funnel Analysis — Find Where Users Drop

A funnel tracks how users move through a sequence of steps. The goal is to identify which step loses the most users so effort can be targeted there.

-- Funnel analysis: sign-up to first purchase
SELECT
    step,
    COUNT(DISTINCT user_id)                              AS users,
    ROUND(
        COUNT(DISTINCT user_id) * 100.0 /
        FIRST_VALUE(COUNT(DISTINCT user_id)) OVER (ORDER BY step_order),
        1
    )                                                    AS pct_of_top
FROM (
    SELECT user_id, 'Step 1: Visited site'      AS step, 1 AS step_order FROM visits
    UNION ALL
    SELECT user_id, 'Step 2: Signed up'         AS step, 2 FROM signups
    UNION ALL
    SELECT user_id, 'Step 3: Completed profile' AS step, 3 FROM profile_completions
    UNION ALL
    SELECT user_id, 'Step 4: Added to cart'     AS step, 4 FROM cart_additions
    UNION ALL
    SELECT user_id, 'Step 5: Purchased'         AS step, 5 FROM purchases
) funnel
GROUP BY step, step_order
ORDER BY step_order;

Once you have the funnel table, the largest drop-off step is where to focus. Then segment that step: which device, traffic source, or user group has the worst conversion at that step?

Cohort Analysis — Understand Retention Over Time

A cohort groups users by the period they first performed an action (signed up, made a first purchase) and tracks what percentage return in subsequent periods.

-- Monthly cohort retention
WITH cohorts AS (
    SELECT
        user_id,
        DATE_TRUNC('month', first_order_date) AS cohort_month
    FROM (
        SELECT user_id, MIN(order_date) AS first_order_date
        FROM orders GROUP BY user_id
    ) first_orders
),
activity AS (
    SELECT
        c.user_id,
        c.cohort_month,
        DATE_TRUNC('month', o.order_date)     AS activity_month,
        DATEDIFF('month', c.cohort_month,
                 DATE_TRUNC('month', o.order_date)) AS month_number
    FROM cohorts c
    JOIN orders o ON c.user_id = o.user_id
)
SELECT
    cohort_month,
    month_number,
    COUNT(DISTINCT user_id)                                        AS retained_users,
    ROUND(
        COUNT(DISTINCT user_id) * 100.0 /
        FIRST_VALUE(COUNT(DISTINCT user_id))
            OVER (PARTITION BY cohort_month ORDER BY month_number),
        1
    )                                                              AS retention_pct
FROM activity
GROUP BY cohort_month, month_number
ORDER BY cohort_month, month_number;

Communicating Findings — The SCR Framework

SCR (Situation → Complication → Resolution) is the most effective structure for presenting analytical findings to business stakeholders.

Frequently Asked Questions

Learn Business Analytics at Evika Academy — Noida Sector 51

Our data analytics programme covers MECE, metric trees, funnel and cohort analysis, and stakeholder communication — the business thinking skills that separate senior analysts from junior ones.