← Back to all articles
Reporting6 min read

Replacing 40 Excel reports with one Power BI dashboard

How a single source of truth changes the way owners and managers make decisions every week.

Most companies do not have a reporting problem. They have a reconciliation problem. Forty Excel reports usually means forty slightly different versions of the truth: sales according to the sales team, sales according to finance, stock from the warehouse file, stock from the ERP. The weekly meeting turns into an argument about whose number is right, and the actual decision waits until someone has checked.

Nobody sets out to build forty reports. Each one made sense when it was created. A manager asked a question, an admin exported some data, added formulas, and the file was copied and updated every week after that. Old versions were never retired. Over time the same figure is calculated in five places with five different filters, and a capable staff member spends Monday morning copying and pasting instead of looking at what the numbers mean.

Start with an inventory, not with Power BI. List every recurring report: who makes it, who reads it, where the data comes from, how often it is updated, and which decision it supports. This list tends to shrink quickly. Several reports turn out to be the same view sliced differently, and some have no regular reader at all. What looked like forty reports is often a handful of real questions asked in different ways.

Then agree on definitions, which is the hardest part of the whole project. What counts as a closed sale: the order, the delivery, or the invoice? When is revenue recognized? Are returns deducted in the month of the sale or the month of the return? Does receivable aging count from the invoice date or the due date? Write each answer in one sentence and have finance and sales both sign off. That conversation alone usually improves the business, because it exposes disagreements that were hidden inside formulas.

Now connect the source systems. Instead of exports, one Power BI data model reads directly from the ERP or accounting database, the sales system, and whatever spreadsheet has no better home, such as the annual budget. Sales, inventory, receivable aging, and production then refresh from the same data, on the same schedule, with the same definitions. Microsoft allows up to eight scheduled refreshes a day on a Pro license, which is more than enough for most management reporting.

Design the dashboard around decisions, not around the old reports. The first page is for the owner: revenue against target, gross margin, cash expected in the next 30 days, overdue receivables, and slow-moving stock. Five or six numbers, each with a trend line. Managers get their own pages with filters for branch, product, or salesperson. If a chart would not change anyone's decision, leave it out.

Picture a distributor where the finance team spends Monday combining sales, stock, and receivable files before the weekly management meeting. After the dashboard goes live, everyone opens the same screen. The discussion moves from what the number is to what to do about it: which customers to chase this week, which products to stop reordering, which branch is behind target. The finance team gets that Monday back for actual analysis.

Budget for licenses and for data work. Power BI Desktop is a free download, but sharing reports needs a paid license. Microsoft lists Power BI Pro at 14 US dollars per user per month, billed yearly, and under Pro the people who view shared reports generally need a license too. The larger cost is usually the data itself: connecting systems, cleaning duplicate customer names, fixing product codes. That work decides whether the dashboard is trusted. Our article on Power BI license cost covers the tiers in more detail.

Roll it out carefully. Run the old reports and the dashboard side by side for one month-end close, reconcile any differences, and correct the definitions where needed. Then announce that the dashboard is the official source for management meetings. Give one person ownership of the data model and train the key users to filter and export on their own. Once that happens, the old Excel reports usually die on their own, because people stop needing them.

If your team spends days each month assembling reports that still do not match, contact Kerja Itu Mudah. Send us a list of the reports you produce and the systems the data comes from. We will tell you which ones can be merged, what definitions need agreeing first, and what a sensible first dashboard looks like. Power BI training for your team is also available, starting from IDR 500 thousand per session.

Frequently asked questions

Why replace Excel reports with a Power BI dashboard?
Replacing Excel reports with a Power BI dashboard ends arguments over which version is correct. Sales, inventory, AR aging, and production all refresh from the same source systems, on the same schedule, with the same definitions.
What is the hardest part of a Power BI project?
The hardest part of a Power BI project is agreeing on definitions: what counts as a closed sale, when revenue is recognized, and how to handle returns. The technical work is more straightforward than that conversation.
What happens to old Excel reports after Power BI goes live?
Old Excel reports usually die on their own after a Power BI dashboard goes live. People stop building those reports because they no longer need them.