Power BI for funeral homes: case volume, preneed, and the whole picture
How funeral homes use Power BI to bring case, preneed, and financial data into one governed view, so case volume, preneed pipeline, and the balance of at-need and preneed business are visible together.
Key takeaways
- A funeral home runs on case volume, average case value, and preneed, and the data sits in case management, preneed, and financial systems.
- A governed model joins them so volume, case value, and the preneed pipeline can be read together, not in separate reports.
- Preneed is future business funded now, so seeing the preneed pipeline is seeing the business's future, not just its present.
- Average case value alongside volume shows how the business is really performing, not just how busy it is.
- The goal is a firm managed on one clear picture of its present and future business, not numbers read from separate systems.
A funeral home runs two businesses at once: the at-need business of serving families now, and the preneed business of arrangements made and funded in advance that will convert to service later. Its health depends on current case volume and value and on the preneed pipeline that represents its future, and seeing all of that clearly is hard, because case, preneed, and financial data live in separate systems. Power BI's role is to join those systems into one governed view, so case volume, preneed pipeline, and the balance between present and future business are visible together. This is how funeral homes use it.
Present and future, in separate systems
Ask a funeral home how it is really doing, and answering it means pulling together case management, holding the at-need cases, preneed and trust systems, holding the advance arrangements, and finance, holding the money. The firm sees its current cases in one place and its preneed in another, and the whole picture, how the present at-need business and the future preneed business combine, how the firm is really performing and where it is heading, is reconstructed by hand.
The first and most valuable thing Power BI does is build a governed model that joins these systems, so case volume, average case value, preneed, and financials can be read together over time. Power BI reads from the case, preneed, and financial systems, and the model relates them into one coherent picture. Once that model exists, the firm can see its present and future business together rather than in separate systems. That join is the foundation, because a funeral home's health spans its at-need present and its preneed future, and no single system shows both.
Preneed: the firm's future, funded now
Preneed is future business funded now, which makes the preneed pipeline a view of the firm's future, not just a record of present activity. When families arrange and fund services in advance, that preneed converts to at-need business later, so the volume of preneed being written is a leading indicator of future case volume and revenue. A firm building a strong preneed pipeline is securing its future; a firm whose preneed is thin may be busy now but is not building what comes next.
A governed model that shows the preneed pipeline lets a firm see how much future business it is building, which is as important to its long-term health as current case volume. The firm can see preneed trends, how much is being written, how the pipeline is growing, and understand its future the way it understands its present. This matters because a funeral home's results years from now depend heavily on the preneed it writes today, and that future is invisible if preneed sits in its own system, unconnected to the firm's overall picture. Seeing preneed clearly is how a firm manages its future deliberately rather than only reacting to the cases that come through its doors today, which is a meaningful shift for a business where so much of tomorrow is being arranged now.
Case value alongside volume
On the present side, average case value alongside volume is what shows how the business is really performing, not just how busy it is. Case volume alone tells the firm how many families it is serving, but volume can rise while value falls, or hold steady while value shifts, so looking at volume by itself can mislead about the firm's financial health. A busy period at lower case values and a quieter period at higher ones can look very different on volume and tell a very different story on performance.
A governed model that shows average case value alongside volume lets a firm see not just how many cases it is serving but what they are worth, and how that is trending. With both visible, the firm understands its performance, not just its activity, seeing whether its results are driven by volume, by value, or by both, and where the trends are heading. This turns a vague busy-or-slow impression into a clear understanding of how the business is actually doing, which is what a firm needs to manage it well. For a business where the number of cases is only part of the story and the value of each matters just as much, seeing volume and value together is what reveals the real performance behind the activity.
It fits firms of any size
A single funeral home benefits as clearly as a group, because even one firm runs case, preneed, and financial data across separate systems reconciled by hand, usually by people also serving families. Bringing it into one governed view gives a single firm a clear picture of its present and future business without a data team, through a partner who builds it and a managed arrangement that keeps it running. Groups gain the ability to compare locations, but the core value, seeing case volume, case value, and the preneed pipeline together, applies to a single firm too, because the nature of the business is the same at any size.
What funeral homes end up with
A funeral home running on Power BI ends up with:
- Case, preneed, and financial data joined so present and future business can be read together.
- The preneed pipeline visible, so the firm sees and manages its future, not just its present.
- Average case value alongside volume, so performance is understood, not just activity.
- A clear picture of present and future business instead of numbers read from separate systems.
The throughline is that a funeral home stops seeing its present at-need business and its future preneed business in separate systems and starts managing the whole on one governed view, where case volume, case value, and the preneed pipeline are clear together. The preneed pipeline, the firm's future funded now, becomes visible and manageable, present performance is understood through value as well as volume, and the firm is run on a clear picture of both where it is and where it is heading. For a business that serves families now while arranging much of tomorrow in advance, seeing present and future together is what turns the scattered case and preneed data into the decisions that manage both the firm's current performance and its long-term future.
Frequently asked questions
Can Power BI connect our case management and preneed systems?
Yes. A funeral home runs case management systems, preneed and trust systems, and financial systems, often with spreadsheets filling gaps. Power BI reads from these and a governed model joins them so case volume, average case value, preneed, and financials can be read together over time. That join is the valuable part, because a funeral home's picture spans its present at-need business and its future preneed business, which live in different systems, and seeing them together is what shows how the firm is really doing. Joining them into one governed view gives a clear picture of present and future business rather than case and preneed numbers read separately.
Why does the preneed pipeline matter so much?
Because preneed is future business funded now, so the preneed pipeline is a view of the firm's future, not just its present activity. When families arrange and fund services in advance, that preneed converts to at-need business later, so the volume of preneed being written is a leading indicator of future case volume and revenue. A governed model that shows the preneed pipeline lets a firm see how much future business it is building, which is as important to its long-term health as current case volume. Seeing preneed clearly is how a funeral home understands and manages its future, rather than only reacting to the cases that come through today.
Why look at average case value, not just volume?
Because volume tells you how busy the firm is, but average case value tells you how the business is actually performing, and the two together give the real picture. Case volume alone can rise while value falls, or hold while value shifts, so looking at volume by itself can mislead about the firm's financial health. A governed model that shows average case value alongside volume lets a firm see not just how many cases it is serving but what they are worth, and how that is trending, so it understands its performance rather than just its activity. Seeing both together is what turns a busy-or-slow impression into a clear understanding of how the business is really doing.
Does a single funeral home benefit, or just groups?
A single funeral home benefits clearly, because even one firm runs case, preneed, and financial data across separate systems reconciled by hand, usually by people also serving families. Bringing it into one governed view gives a single firm a clear picture of its present and future business without a data team, through a partner who builds it and a managed arrangement that keeps it running. Groups gain the ability to compare locations, but the core value, seeing case volume, case value, and the preneed pipeline together, applies to a single firm too. The underlying nature of the business, present at-need work plus future preneed, is the same at any size.