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.

What each kind of request changes
RequestChangesWho does it
Sales by product this monthOnly the viewAnyone
Sales excluding one regionOnly the viewAnyone
Count unpaid orders as salesThe definitionThe metric's owner
Why did customers leave?Needs other dataSomeone 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.

Requests to sort
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.