From Data to Decisions
Business intelligence starts with a decision, not a dashboard. Turn a decision into a question and a clear measure.
What you will learn
By the end of this lesson, you can turn a real decision into a clear question and define a measure so everyone counts it the same way.
What business intelligence is
Business intelligence (BI) is turning an organization's records into answers people can act on. Records might be sign-ups, attendance, sales, or service requests. BI tools collect that data, clean it, and show it in reports and dashboards.
Many organizations have plenty of data and still guess. Their numbers live in different places, and different people count them different ways. BI fixes that by agreeing on what to count and putting it in one place.
Start with the decision
The most common BI mistake is building a dashboard first and asking what it is for later. Start from a decision someone has to make.
| Decision | Question | Measure |
|---|---|---|
| Should we add a second tutoring night? | Is the current night full? | Average attendance compared with seats |
| Which outreach should we keep? | How do families hear about us? | Share of new sign-ups by source |
| Do we need more volunteers in spring? | Does demand change by season? | Sign-ups per month |
If nobody will make a different choice based on the number, you may not need the number.
Define every measure
A measure (or metric) is a number you track. Write down exactly how it is counted. Otherwise two people will report two different numbers for the same thing.
Example definition:
Active student: a student who attended at least one session in the last 30 days. Counted every Monday. Source: attendance sheet.
Questions to settle in every definition:
- What counts, and what does not?
- What time period?
- Where does the data come from?
- Who is responsible for it?
Where the data lives
Organizations often keep data in a CRM (customer or constituent relationship management system, a tool for tracking people and contacts) and in spreadsheets, forms, and finance tools. BI connects these so a question can be answered in one place.
Prompt Lab
Turn a decision into a question and a written measure definition. Then check it with the person who owns the data.
Your prompt
Act as a data analyst who helps nonprofits make decisions. Format: Decision; one clear question; one measure with a written definition (what counts, time period, source, owner)
Reflection
Go deeper: Business Intelligence for Real Operators: Turning CRM & ERP Data into Decisions
Discussion
Ask. Answer. Build together.
Loading…