09 · Data, analytics & automation
KPI dashboards and Power BI built, then taught
We reconcile one dataset into a useful KPI view with agreed definitions and refresh logic, and teach your team to maintain it.
Tell us what you need- Led by
- Michael Gagakuma
- Delivery
- Remote, and on site from Accra
- Fees
- Fixed fee, quoted to your scope
- Free tool
- KPI dictionary & dashboard planner
- Contracting
- GKM Legacy Holdings, Maryland
Led byMichael Gagakuma
- Contracting
- GKM Legacy Holdings, Maryland
- Consultation
- from USD 90
What you receive.
Documents you can use, each with its method and sources attached.
04in the pack
See a demonstration of the output: Specimen · KPI dashboards & Power BI build-and-teach
KPI dictionary
Each measure defined, with its owner and formula.
Dashboard
Built on reconciled data, with refresh logic.
Validation record
Reconciliation checks and exceptions.
Training
Your team maintains and extends it.
Scope and fees.
Fees are agreed in writing before work begins. Estimates are shown as estimates.
Fees
Fixed fee, quoted to your scope
Send a brief or book a short call. We reply with a written scope, dates and a fixed fee before any work begins.
What we need from you
- Access to the source data
- The decisions the dashboard supports
- A data owner
Not included unless agreed
- Licences
- Data-warehouse builds unless scoped
- Ongoing report production unless agreed
Who commissions this, and when.
Buyers and moments where this work pays for itself, and where it does not.
Who it is for
- Management teams
- Finance and operations units
- NGOs and programme managers
When to call us
- Every meeting starts with arguments about the numbers
- Reports are rebuilt by hand each month
- You have Power BI licences but no useful dashboards
When it is not the answer
A dashboard cannot fix unreliable data. Validation comes first, and exceptions are shown, not hidden.
How the work runs.
Each stage ends in something you review before the next begins.
Stage 1 of 5
Inputs
List the data sources and access.
Review pointInputs listed, with owners and access confirmed.
Stage 2 of 5
Validation
Validate and reconcile the data.
Review pointData validated, with exceptions logged.
Stage 3 of 5
Analysis/build
Build the model and the dashboard.
Review pointAnalysis or build checked against the agreed definitions.
Stage 4 of 5
Acceptance
Accept with the people who will use it.
Review pointAcceptance tested by the people who will use it.
Stage 5 of 5
Operation
Teach, hand over and set the refresh.
Review pointOperation handed over with a runbook and a refresh plan.
Questions buyers ask.
Anything else: ask in a brief.
Must we use Power BI?
No. We use Power BI, spreadsheets or other tools your team can maintain.
Will our staff be able to update it?
Yes. That is what the teaching is for.
Is there a free tool?
Yes: the KPI dictionary and dashboard planner.
Related work
What needs to move forward?
Tell us the decision, the challenge or the opportunity. We reply with a scoped approach, a named principal and a fee before any work begins.
No charge to submit an enquiry.