Lesson 12 of 15 · Concept
What is self-service BI, and what does it need?
Self-service BI lets people answer their own questions from shared data without waiting for an analyst. It works when they can slice freely and can't quietly redefine the measure. That takes understandable data, agreed definitions and a clear route for anything else.
| Request | Changes | Who does it |
|---|---|---|
| Sales by product this month | Only the view | Anyone |
| Sales excluding one region | Only the view | Anyone |
| Count unpaid orders as sales | The definition | The metric's owner |
| Why did customers leave? | Needs other data | Someone with a new source |
When a personal tile disagrees with the KPI
At fictional Vandelay Coffee Supply, the agreed page reads 95.7% of the €12,000 target for Q3 net value. Don Tremendous in Sales has built his own tile on the same table.
Don's filter also keeps pending invoices with no date, and his tile reads 105.4%. It looks every bit as official as the page.
INV-1016 is the invoice his filter lets in, €1,300 at list, for customer Starhopper. What does his tile add up to?
€12,648. INV-1016 adds €1,170 rather than €1,300, because Starhopper's rebate applies. Against €12,000 that's 105.4%. The arithmetic is fine, and the metric is different.
Don wasn't cheating. He had a real question, how much is in the pipeline, and the tool let him answer it under the name of a different one. The damage comes when it's read as the KPI. A useful personal calculation should get its own name until its owner adopts it.
Sort six requests by who should answer
Sort these into three groups: explore it yourself, ask the owner or this data can't say.
| Request |
|---|
| Net value by customer |
| South without Initech |
| Count pending invoices as sales |
| Move Dunder Mifflin back to South for Q3 |
| Which account manager would sell the most? |
| Why does Excalibur have no Q3 invoices? |
Compare with a model answer
Explore: the first two only change the view. Ask the owner: the next two change the definition, so Sydney Swell in Finance and Don decide. Can't say: the last two. These invoices hold no answer about a future hire, or about why a customer didn't order.
Slicing can't change what the number means, and redefining can. So give people the first freely, and route the second to whoever owns the metric, in the open.
What self-service needs before launch
- Documented measures. Say what each one counts and which records it includes.
- Named dimensions and limits. People should see what they can slice by, and what the data doesn't cover.
- A route for questions. Name who takes data faults and new requests.
- Some training. Readers should be able to tell fewer invoices from a lower average invoice before they explain a falling total.
Use it when the same small questions keep reaching an analyst. Hold off if the definitions are still in dispute, because self-service then spreads the argument to more people.
Access and shared definitions
Set access with the same care. Publish only what viewers may see. Removing a column from a chart hides it from the chart, and from nothing else.
Elsewhere, certified semantic models (Power BI) and data sources (Tableau) tell people which definitions to build on. In a spreadsheet or SQL, a single shared table or view with a named owner does the same job with less ceremony. Data governance covers how those owners are decided.
To build a shared page from one table, try Vista, Oplema's browser app for dashboards, with no account needed.