Hospital BI
Hospital BI: what it is, what it is for and how to choose
Business intelligence applied to hospitals: turning information-system data into reliable KPIs that are the same for everyone and ready for decisions.
Hospital BI (hospital business intelligence) is the set of data, rules and dashboards that turns what is recorded in a hospital's information system into information for decisions: how much the hospital billed, where it lost revenue, which payer is profitable, which department is over budget, how volume evolved. Good hospital BI delivers the same number to everyone, with a clear source, at the moment the decision has to be made.
In short
- Hospital BI reads data from the hospital information system (in Brazil, often Tasy or MV), applies management rules and shows KPIs in dashboards.
- It does not replace the information system: it adds an analysis layer.
- The value lies in the rules: revenue, denials, cost and margin must be calculated the same way on every dashboard.
- When choosing, assess the data source, how often it refreshes, security (Brazil's LGPD) and who ensures the numbers match the accounting records.
What BI is for in a hospital
The hospital information system records operations: admissions, accounts, prescriptions, purchases, accounting entries. It is built to operate, not to analyze. When the board wants to know why margin fell in the quarter, the answer requires crossing billing, costs, payers and volume over different periods. Without BI, that cross-analysis becomes a spreadsheet, built by hand and done differently every month.
Hospital BI solves three problems:
- Time: KPIs are ready and up to date, without waiting for a manual close.
- Consistency: the same calculation rule applies to every area. Revenue on the billing dashboard is the same as in the income statement.
- Depth: from the hospital total down to the patient account in a few clicks, to find the cause of a variance.
Which decisions it supports
- Revenue: which payers, specialties and procedures sustain the result, and where revenue fell.
- Billing: how many accounts are open, for how long, how much was denied and how much was written off.
- Costs and margin: cost by department and cost center, contribution margin by payer and procedure.
- Budget: actual against budget, by income statement line and cost center, and the full-year projection.
- Operations: occupancy rate, average length of stay, volume of surgeries, consultations and tests.
- Cash: average collection and payment periods, receivables by due date.
The most common indicators are in the hospital KPIs guide, and the formulas are in the glossary.
Where the data comes from
Hospital BI is only as good as the data it reads. In most Brazilian hospitals the main source is the hospital information system (the ERP), which concentrates patient care, billing, supplies, finance and accounting. There are three common ways to bring that data into BI:
- Manual exports (Excel reports): easy to start, but they depend on someone and do not scale.
- Direct connection to the ERP database: automatic, but care is needed so it does not burden the system and so the data stays protected.
- A read agent with a preparation layer: reads only what it needs, brings only what changed and applies the rules before displaying.
Clic Health takes the third approach with Tasy, as explained in how it works. For hospitals running Tasy, see BI for Tasy.
BI, dashboard and report: what is the difference
A report answers a fixed question ("October billing by payer"). A dashboard brings together several KPIs on a topic on one screen, with filters. BI is the whole: prepared data, calculation rules, dashboards and the way to navigate between them. A good hospital dashboard depends on well-built BI behind it.
What to assess when choosing hospital BI
| Criterion | What to ask |
|---|---|
| Data source | Does it read my information system directly? Does it need spreadsheets in between? |
| Calculation rules | Who defines the rules for revenue, denials, cost and margin? Do they match the accounting records? |
| Refresh | How often does data arrive? Can I see the time of the last update? |
| Security and LGPD | What leaves the hospital? Is the patient identified? Who accesses what? Is access logged? |
| Impact on the system | Does reading burden the ERP database? Does it write anything? |
| Depth | Can I drill from the total to the patient account? Export the data? |
| Who maintains it | Who updates the dashboards when the hospital changes its chart of accounts or a process? |
| Artificial intelligence | Does the AI show where the number came from? Does data go to an external service? |
The same criteria help decide between building BI in-house and buying a ready-made solution. The article Spreadsheets or BI discusses when each path makes sense.
Topics in this guide
- Hospital financial BI: revenue, margin, cash and result.
- Hospital dashboard: how to build screens the board actually uses.
- Hospital KPIs: the ones that matter and how to read each.
- BI with artificial intelligence: what AI does well and where it needs limits.
- Hospital controllership: budget, cost centers and the income statement.