KPI dashboards and anomaly alerts
Key numbers watched daily, with an alert when one moves outside its range.
How it works · KPI dashboards and anomaly alerts
STEP BY STEP
In
BigQuery
Google Sheets
Stripe
- 1
Measure01
Daily metrics computed
12 metrics
- 2
Compare02
Checked against normal ranges
1 outlier
- 3
Explain03
Likely drivers summarised
Refunds up
- 4
Alert04
Owner notified
Alerted
Human checkpoint
Out
- Dashboard
Slack- Weekly summary
How it works
01
The problem
Problems are found at month-end instead of the day they start.
Step by step
- 01Measure. Daily metrics computed.
- 02Compare. Checked against normal ranges.
- 03Explain. Likely drivers summarised.
- 04Alert. Owner notified.Human checkpoint
Tools and control
02
Connects
Looker Studio- BigQuery
- Slack
Built on n8n. Equivalent tools can be swapped in.
Human control
A person stays in control at the "Alert" step. Everything else runs on rules you agree, with every run logged.
More in Data and reporting
03
Data and reporting
App data to a warehouse
Clean, validated data from every app in one warehouse, updated on schedule.
See the workflowData and reporting
Market and competitor monitoring
A weekly digest of competitor and market changes from public sources.
See the workflowData and reporting
Learner progress reports
Regular progress summaries for learners, tutors, and managers.
See the workflow
Next step
What would you like to improve?
Tell us what is taking too much time, what is difficult to manage, or what you would like your systems to do differently. You do not need a technical specification to start.