Data analytics training on your own data
Data analytics training gives your team the skill to change and check its own reports, so reports stop depending on one person. Courses in Power BI, SQL and GA4 run on your own tables and end with a task each person does alone, reviewed in writing.
One exercise from the SQL course, example
The join reported net sales of £670. The right figure is £470.
| order_ | order_ | order_ |
|---|---|---|
| 1001 | 2026-10-03 | 120.00 |
| 1002 | 2026-10-07 | 85.00 |
| 1003 | 2026-10-12 | 200.00 |
| 1004 | 2026-10-18 | 60.00 |
| 1005 | 2026-10-24 | 150.00 |
| 1006 | 2026-10-29 | 95.00 |
| refund_ | order_ | refund_ | refund_ |
|---|---|---|---|
| 5001 | 1002 | 2026-10-10 | 20.00 |
| 5002 | 1003 | 2026-10-15 | 40.00 |
| 5003 | 1003 | 2026-10-21 | 30.00 |
| 5004 | 1005 | 2026-10-28 | 150.00 |
Before
SELECT
SUM(o.order_value) AS gross_sales
,SUM(COALESCE(r.refund_amount, 0)) AS refunds
,SUM(o.order_value) - SUM(COALESCE(r.refund_amount, 0)) AS net_sales
,COUNT(*) AS row_count
FROM orders AS o
LEFT JOIN refunds AS r ON 1=1
AND r.order_id = o.order_id
WHERE 1=1
AND o.order_date >= '2026-10-01'
AND o.order_date < '2026-11-01'
| gross_ | refunds | net_ | row_ |
|---|---|---|---|
| 910.00 | 240.00 | 670.00 | 7 |
After
WITH refunds_by_order AS (
SELECT
order_id
,SUM(refund_amount) AS refund_amount
FROM refunds
GROUP BY order_id
)
SELECT
SUM(o.order_value) AS gross_sales
,SUM(COALESCE(r.refund_amount, 0)) AS refunds
,SUM(o.order_value) - SUM(COALESCE(r.refund_amount, 0)) AS net_sales
,COUNT(*) AS row_count
FROM orders AS o
LEFT JOIN refunds_by_order AS r ON 1=1
AND r.order_id = o.order_id
WHERE 1=1
AND o.order_date >= '2026-10-01'
AND o.order_date < '2026-11-01'
| gross_ | refunds | net_ | row_ |
|---|---|---|---|
| 710.00 | 240.00 | 470.00 | 6 |
What this fixes
The four courses: Power BI, SQL and GA4 training
How data analytics training runs
- 1
Scoping
Scoping settles the course, who attends and which reports they look after, and your team's backlog of unanswered questions supplies the final tasks.
- 2
Build
The exercises are written against a copy of your tables in your own environment, with personal details removed.
- 3
Sessions
Each exercise runs on a report or table people will open again the next day, with mistakes like the one in the exhibit left in for them to find.
- 4
Final task and handover
Each person does the final task alone, and the written review goes to them and to you.
Why skills from training fade
In the example, both queries return refunds of £240, so a check on refunds alone would pass, and the error is in gross sales.
Training by industry
If the GA4 gap is broken tags, fixing them is tracking work. To have the model built first and the team trained on it after, use the Power BI consultant service. For a standing analytics function once the course ends, see fractional analytics.
Questions about training
Do you run Power BI training for finance teams?
Yes. The exercises use finance's own model, or a copy of it, and the final task adds a measure finance has asked for and checks it against the ledger. The finance dashboard in the KPI library shows the kind of pack it ends up in.
Can the training use our real data?
Yes, as a copy in your own environment, with names, emails and anything else personal removed. The copy keeps the awkward parts, such as orders with two refunds, because those are what the exercises are about.
Do you run SQL training for ecommerce teams?
Yes. The SQL course runs on your orders, refunds and order lines, and the exercise above comes from it. People learn to check the row count at each join, so a refund can't double a total without someone seeing it.
Is the Google Analytics training for marketers or developers?
It's for marketers who read the reports and have to explain them. The course ends with last month's GA4 purchases reconciled to your order system, and setting up tags is work for the tracking service.
How do we know the training worked?
Each person's final task is reviewed in writing, and you get the reviews. The task comes from your team's own backlog, so you see the result in a report you already use.
Is there a report only one person can change?
On the call we look at that report and who reads it, then suggest a course and the tables its exercises would use.