Blog
Practical perspectives on data governance, Microsoft Fabric, Power BI and analytics strategy for UK organisations.
From Raw Operational Data to Boardroom Number: The Stepwise Journey Every Metric Takes
A concrete look at the stepwise transformations that turn a row in an operational system into a trusted number in a board report, and why skipping a step is where trust actually breaks down.
Consolidating multiple Business Central companies in one model
Running more than one Business Central company is common in group structures, but consolidating reporting across them is where the pain starts. Mismatched CoA's, manual intercompany txs, and no single view of group performance. Solving this is a data architecture decision, not a reporting one.
Choosing the Right Data Architecture: A Practical Guide to 5 Modern Patterns
A practical breakdown of five modern data architecture patterns, and how to choose the right one for your organization's scale and governance needs.
When Microsoft Fabric is the wrong answer
Fabric is a strong platform. That does not make it the right one for every business. Here are the situations where buying it is a mistake, from people who sell the work.
Off-the-shelf AI features versus building your own
Building your own AI model sounds like the serious option, but for most mid-market businesses it is the slow, expensive and unnecessary one. The question worth asking is not whether you could build it. It is whether the off-the-shelf alternative is close enough to already be winning.
Business Central to Microsoft Fabric: when it is worth it
Moving your Business Central data into Microsoft Fabric is not an upgrade, it is a shift in what becomes possible. When your operational ERP data sits inside Fabric alongside everything else, the questions you can ask and the speed at which you can answer them change considerably.
Power BI or Business Central’s built-in reporting?
Business Central's built-in reports are fine for what they were designed to do, but they were designed for transaction confirmation, not analysis. Power BI does not replace Business Central's reporting: it takes over where BC's reporting sensibly stops.
The Business Central reports a finance team needs
Finance teams using Business Central often end up exporting data into Excel because the reports they actually need - aged debt, cashflow position, budget vs actuals by department - either do not exist in BC or cannot be trusted without manual adjustment. There is a better way to build them once.
Bronze, Silver, Gold: What Each Layer of a Medallion Architecture Is Actually For
A practical breakdown of what Bronze, Silver and Gold are each responsible for in a medallion architecture, and why blurring those boundaries is what actually breaks data platforms.
Power BI and Fabric licensing explained: Pro, PPU, and Fabric capacity costs compared
Pro, PPU, or Fabric capacity: what each licence actually gives you, why the April 2025 price rise changed the maths, and where most organisations overspend.
Basket Analysis On Data You Already Have
The products your customers buy together are already telling you something useful. Most businesses just never ask the question. Basket analysis does not require a data scientist or a specialist tool; it needs the transaction data you almost certainly already have.
Pyramid, Power BI or Fabric: Which One, and When
There is no best analytics platform, only the right tool for the job. Here is what Power BI, Fabric and Pyramid are each best at, and how to tell which you need.
Stay informed
Get new insights in your inbox
We publish practical articles on analytics strategy, Power BI, and Microsoft Fabric. No spam - just useful content when we publish it.
Get started
Ready to put this into practice?
Reading about better analytics is a start. Working with us is how it happens.
Book a free audit