Systems | Development | Analytics | API | Testing

2/5 My tidiest marketing table was the output of 28 functions

Part 1 ended with a question for anyone running an internal app: which sources does its most important output depend on? I thought I knew the answer for our marketing dashboard. On 9 August 2026 I found out I did not. Two months later, all 14 of our marketing sources land in one place, and the numbers we act on have changed. The full before-and-after list is in the second tab of the data map further down.

Data Fragmentation: Definition, Causes and Fixes

Data fragmentation is what happens when the same business facts live in more than one system, in more than one shape, with no agreed way to reconcile the copies. The same customer exists under three identifiers; the same revenue figure changes depending on which team you ask. That is not the same as running many tools. An organization can operate a dozen systems and still be coherent — if every tool’s data lands in one place, under shared identifiers, with terms defined once.

What Private Equity Firms Need from a Portfolio Reporting Tool

Most portfolio reporting tools assume the data underneath them is already clean and comparable across every portfolio company. It rarely is. A fund with twenty portfolio companies usually has twenty different ERPs, twenty different charts of accounts, and a reporting team that spends the week before every LP update reconciling numbers by hand.

How to Build Consolidated Multi-Entity Reporting in Power BI

Most groups start consolidating in Power BI the same way. Someone connects each subsidiary's ERP, appends the trial balances and writes a few DAX measures to net off the obvious intercompany lines. It works for two entities. By the fifth, the group P&L no longer ties to the ledgers, and month-end turns into a hunt for the difference. This guide is for the group controller or finance lead who owns that report.

How to Consolidate Reporting Across Multiple ERPs Without Migrating Any of Them

Most multi-entity businesses do not choose their accounting systems. They inherit them. A new acquisition brings Xero. The legacy entity has been on Dynamics for eight years. The Czech subsidiary runs on ABRA Flexi and nobody is going near it. Your US portco uses QuickBooks, your UK one uses Sage Intacct, and the newest deal came with a NetSuite instance that the previous owner had half-implemented. You are not looking at a technology problem. You are looking at the reality of how groups grow.

Kai Has a Different Personality in Czech vs English

Anthropic recently published research showing that Claude behaves differently depending on the language you use. Not just translating differently. Actually expressing different values. In Arabic, Claude is warmer and more deferential. In English, it's more rigorous and cautious. In Russian, it challenges your assumptions more. When we read that, we had one question: does Kai do this too? So Jordan, our AI lead, analysed around 3,000 internal Kai sessions. The answer: yes.

The 2026 Finance Stack: Which Layer Are You Actually Missing?

Most comparison guides in this space organise tools by feature count or analyst quadrant position. Neither is especially useful if you are a CFO trying to solve a specific problem under time pressure. The more useful diagnostic is category. Finance intelligence tools in 2026 fall into three distinct layers, and buying the wrong layer is the most expensive mistake you can make. Consolidation and close platforms are built to produce auditable, multi-entity financial statements.

Why Your Best Finance Analysts Are Leaving

It is Monday morning. Your strongest FP&A analyst opens their laptop and starts pulling the SAP export. They clean it in Excel, cross-reference it against last month's version, and flag the columns that have shifted format again. Tuesday they pull the Dynamics export from the German entity and begin reconciling the two. Wednesday the Polish subsidiary data has not arrived. They chase the local accountant, wait, chase again.

The Frozen Excel Preference

There is a pattern showing up in finance teams that almost nobody is writing about, because it runs counter to the narrative. Finance leaders at organisations with messy, ungoverned data have made a deliberate choice: they prefer working with a frozen Excel snapshot over connecting AI to their live financial data. Not because they are afraid of technology. Not because they distrust AI as a concept.

What Happens When the CEO Can Always Get the Answer

The goal is not complicated to describe. The CEO opens a dashboard, asks a question about regional margin for Q2, drills through to the underlying journal entries, and gets the answer in seconds, without asking anyone. No email to the controller. No waiting until Thursday. No 'let me come back to you on that.' Every CFO who has sat through a pitch for a data platform has been shown this vision. Most of them believe it is achievable. A meaningful number have actually achieved it.