A finance manager at a building-supplies firm in the Midlands runs the same monthly P&L pack on the last Friday of every month. Eleven spreadsheets, three pivot tables, an hour of copy-paste, and a SharePoint upload she does not get to skip. By the time the directors open the pack on Monday, the patterns inside the numbers are already five weeks old.
This is the version of management reporting that a lot of growing UK firms are running, and it is the one that Power BI training tends to dismantle first. The interesting thing in the past two years has been who is doing the training. Not the data team, because the firms in question do not have one. The training lands with whoever is closest to the numbers in practice: the finance manager, the operations lead, the commercial director’s PA. People who already know where the data lives, where it disagrees with itself, and what the directors are actually trying to decide with it.
The reporting bottleneck most growing firms recognise
The monthly pack is a useful shorthand for a wider problem. Numbers get pulled together by hand, get stale on their way to the people who need them, and answer last month’s questions rather than this week’s. Anyone who has worked in an SME finance function in the past decade has built one of these packs, kept it running, and watched it slowly become the thing nobody is allowed to touch.
The time cost is the obvious part. The decision cost is bigger. When a sales director wants to know how a new pricing tier is performing, and the answer involves a three-day round trip through the finance team’s spreadsheets, the decision tends to get made on instinct. That is not a criticism of the team. It is what happens when reporting infrastructure cannot keep up with the pace the business is being run at.
Power BI is interesting in this context because it is already in most of these businesses. If the firm has Microsoft 365, the licensing is largely sorted. The data connectors for Excel, SharePoint, Dynamics, SQL Server, Xero, Sage and most of the other tools an SME runs on are already there. The platform itself has led Gartner’s Magic Quadrant for analytics and business intelligence for eighteen consecutive years, and around thirty million people use it monthly. None of that makes the skill easy to pick up cold, but it does mean the investment in learning lands on a tool that is not about to be replaced.
What “learning Power BI” actually involves
When a business owner hears that someone on the team wants to learn Power BI, the picture is often vague. In practice the skill breaks down into five things, and a good course covers all of them in sequence.
Connecting to data sources, which is largely about pointing Power BI at the files, databases and cloud systems the business already runs on. Power Query, which is the cleaning and reshaping layer that handles the messy formats that real-world data always arrives in. Data modelling, which is the part that decides how the different tables relate to each other and how the numbers will roll up. DAX, the formula language that drives the actual calculations and time-based comparisons. And report design, which is the bit the directors see, where dashboards and visuals get arranged in a way someone can actually read in twenty seconds.
People often pick up the first and the last on their own. The middle three are where self-teaching tends to stall. They are also the parts that decide whether a dashboard answers the question or just looks like it does. This is the case for a structured course rather than a YouTube playlist, and it is the reason a two-day hands-on Power BI masterclass tends to deliver more shipped dashboards than three months of evening study. The format is a public session with a small group, or a private delivery for a team at the company’s own offices, with real datasets and the kind of scenarios that come up in a UK SME finance or operations function.
Where the skill pays off in the business
The first thing that changes after one or two people on the team have the skill is that the monthly pack stops being monthly. It becomes a live dashboard that the directors can open whenever they want, with the current week’s numbers in it. The finance manager who used to spend a day a month assembling it gets the day back. The directors get answers when they are still useful.
The second thing that changes is the question. Once the basic numbers are visible all the time, people stop asking “what did we sell last month” and start asking “why is the margin on this product category drifting downwards” or “what is the actual lead time on these three suppliers”. Those are harder questions, but they are the ones that move the business forwards. There is a practical guide to turning the data a business already has into a source of growth that walks through the stages most SMEs pass through as their reporting matures, from making the numbers visible at all, through understanding the patterns inside them, through forecasting, and out into the operational systems themselves.
The third thing that changes is the speed of decision-making across the rest of the leadership team. A pricing change that used to need a three-day analysis cycle takes an afternoon. A staffing decision that needed last quarter’s data takes a few minutes against the current week’s. None of this is dramatic. It is the kind of compounding advantage that does not show up in any single decision and is obvious in the year-end numbers.
Training someone on the team versus hiring a data analyst
The argument for hiring an analyst is straightforward. The argument against is that recruitment in this part of the market is slow, the salaries are not small, and the new hire spends their first six months learning the business before they can build anything useful. The team member who already knows the business, by contrast, is learning the tool. The tool is more learnable than the business is.
For a lot of growing firms, the right shape of the investment is one or two people on the existing team going through structured training together, building the first set of dashboards under guidance, and then keeping the skill in the business as it grows. The cost of a two-day course for two people sits well inside what a single month of an analyst’s salary would be, and the dashboards they build belong to the firm rather than living in a contractor’s account.
The team member who knows where the data lives is usually the one who should be reading it. Power BI is the route from one to the other, and the training side of that is the part most growing businesses underrate.