Common problems, and what fixing them looks like.
The problems that come up most, and what I'd do about each. The charts use made-up numbers.
- The month-end package takes days to put together.
- Sales and finance bring different numbers to the same meeting.
- You pay for Power BI and everyone still lives in Excel.
- You find out a location is slipping after the quarter ends.
- Budget vs. actual arrives too late to act on.
- Cash is tied up in inventory and unpaid invoices.
- Leadership wants to try Copilot on the company's data.
- Your reporting runs on aging tools only one person understands.
Closing the month and building the board package takes too long.
Accounting closes the books, then someone spends two or three more days exporting from the ERP and fixing a workbook full of formulas. The weekly sales report gets built the same way, every Monday.
I automate the pulls from your accounting system, even one running on a server in your office, and move the math into one shared model. The package and the Monday report both become reports that fill in on their own. If a pull fails, someone gets an alert.
If the package took three days a month, that's more than seven weeks of someone's year back.
How it's built in Fabric
Data Factory pipelines, the on-premises data gateway, a lakehouse, a semantic model, paginated reports, and scheduled subscriptions.
Sales and finance show up to the same meeting with different revenue numbers.
Sales counts revenue when the deal is signed. Finance waits for the invoice and backs out credits, and operations keeps its own count off shipments. The meeting loses twenty minutes to it.
Building the model is the easy part. Getting sales and finance to agree on the official number takes a couple of conversations. Then I build that definition once, give the others honest names like bookings, and every report reads from it.
How it's built in Fabric
A shared semantic model with documented measures, endorsed as certified so other reports reuse it.
You're paying for Power BI, and everyone still lives in Excel.
A few dashboards went up fast, didn't match finance, and people went back to Excel. Now there's a monthly Microsoft bill nobody is sure about, and a payroll export sitting where half the company can open it.
I right-size the licensing first, then fix what's underneath: a test area, access that matches people's jobs, and labels on confidential data. And I connect Excel to the official numbers instead of fighting it.
How it's built in Fabric
Capacity sizing and the Capacity Metrics app, workspace roles, deployment pipelines, sensitivity labels, certified semantic models, and Analyze in Excel.
You find out a location is slipping after the quarter is over.
The quarterly review shows one branch's margin has been sliding for ten weeks. By then the quarter's gone.
I build a weekly view of every location against its targets, and each regional manager sees only their own. When a location stays under target two weeks running, its manager gets an email or a Teams message.
How it's built in Fabric
Power BI on a semantic model, row-level security by region, and Activator alerts to email and Teams.
By the time you see budget vs. actual, it's too late to do anything about it.
Budget vs. actual arrives three weeks after month-end, and the explanations trickle in by email over the following week.
Department heads get a page that updates daily. Next to any big variance there's a box to explain it, and the note is saved with the numbers and who wrote it. A few people may need an extra Microsoft license for this; I'll price that first.
How it's built in Fabric
Power Apps or translytical task flows writing to a SQL database in Fabric, read by the same semantic model as the reports.
Too much cash is sitting in inventory and unpaid invoices.
The aging report and the stock list live in different systems, and nobody looks at them together. Purchasing reorders off last week's export.
I pull receivables, inventory, and open orders into one view that's current every morning. Collections gets a list of who's late. Purchasing sees what isn't selling before reordering, and gets an alert when stock runs low.
How it's built in Fabric
Mirroring for supported databases, a lakehouse, a semantic model, and Activator alerts on stock levels.
Leadership wants to try Copilot, and you're not sure the data is ready.
Copilot and Fabric data agents answer everyday questions about company data. On messy data they answer anyway, and one wrong margin number in front of the CFO ends the experiment.
Most of the work happens before anyone asks a question: one definition per number, readable names, and instructions on what not to answer. Then we test against questions with known answers, and again after every model change, because it's still software and it can be wrong. Copilot needs a paid Fabric capacity, and you'll know the cost up front.
Answers you can put in front of the CFO, and a test set you rerun after every change.
How it's built in Fabric
Copilot in Power BI, Fabric data agents, and the Prep data for AI settings: descriptions, synonyms, verified answers, and AI instructions.
Only Harbor, at 30.7%. Every other location was at least a point above the 32% target.
Based on Gross margin %, Finance definition. Same number as the Monthly Results report.
Your reporting runs on aging tools, and only one person knows how they work.
Years of logic live in an old SQL Server with SSIS jobs, an Access database, or a workbook full of macros. The server is near the end of support, and the one person who understands it is retiring, or already gone.
I go through it with them if I can, or work it out from the files. Then I move it to Fabric one piece at a time and run old and new side by side until every number matches or we know why it doesn't. Nothing gets switched off until it does.
Whoever takes over gets a guide and two trained people to ask.
How it's built in Fabric
SSIS packages rebuilt as Data Factory pipelines, SQL Server logic moved to a Fabric warehouse or lakehouse, SSRS reports rebuilt as paginated reports, and comparison queries between old and new.
Recognize one of these?
Tell me which one, or what's going on if it's none of them.