Griffith Consulting Group

data engineering · stage 03 of 04

Data analysis, starting with your question

Analysis starts with a business question, like which channel brings customers who place orders. We answer it with your numbers and show the math, so you can check each step.

webwalk-inreferralreferralorder rate= orders ÷ leads3 orders ÷ 4 leads= 75%average order($64 + $95 + $48) ÷ 3= $69referral leads$64$95$48which channel brings orders?the math, shown
fig. 1 · four referral leads, three orders, and the math worked on the board

What you get

  • An answer to your question

    One question, one answer, in plain English.

  • The math, shown

    Each number comes with the formula behind it, like order rate = orders ÷ leads.

  • What the data can’t say

    If your data can’t answer the question, we tell you and suggest what to start tracking.

How it works

  1. Pick the question

    You bring the decision you face. We turn it into a question your data can answer.

  2. Agree on the formula

    We agree on the measure, like orders ÷ leads, before we run anything.

  3. Run the numbers

    We run the formula on the cleaned table, one channel at a time.

  4. Explain the result

    We tell you what the number means, and when the sample is too small to trust.

A worked example

Sample records from a fictional bakery, the same one that runs through the overview.

  1. Data analysis: ask a question

    Analysis starts with a business question. For the bakery: which channel brings customers who place orders, and how much do they spend?

    formula order rate = orders ÷ leads

    referral leads, after cleaning

    order rate 3 orders ÷ 4 leads = 75%

    average order ($64 + $95 + $48) ÷ 3 = $69

Questions owners ask

Have another one? Ask it on a call.

Do I need to understand statistics?

No. You need to know your business. We explain each finding in plain English.

What if my data can’t answer my question?

We tell you, and suggest what to start tracking.

What happens after analysis?

Visualization. We turn the answer into a chart you can read at a glance and share with your team.