Analytics

Analytics is the third leg of Pillar 3 – Finance, one of the nine legs of Tripod²: variances, common size, seasonality, trends, and KPIs. It compares what Accounting records with what Planning projects – the same way Pillar 3 measures what Pillars 1 and 2 produce.

The Interpretation Layer

Financial statements and forecasts are inputs to decision-making, not decisions themselves. Analytics is the discipline that bridges the two – comparing actuals to plan, expressing results in relative terms, and surfacing the KPIs that actually drive the business.

Without this layer, organizations accumulate data they can't act on. With it, leadership has a clear, consistent picture of what's working, what isn't, and where to focus.

Variance Analysis

Variance analysis compares actual results to the budget, the prior forecast, and the prior period – identifying where performance deviated, by how much, and why. The goal is not to explain the past for its own sake, but to make future decisions more accurate.

We design the variance reporting framework appropriate for your business: by department, cost center, product line, or business unit. The right level of detail makes variances actionable. The wrong level buries them.

• Budget vs. actual – How did results compare to what was planned, and which assumptions were wrong?
• Forecast vs. actual – How much did the rolling forecast improve on the original budget over time?
• Period over period – How did this month or quarter compare to the same period last year, controlling for seasonality?
• Driver analysis – Was the variance driven by volume, price, mix, or cost? Each has different implications.

Common Size Analysis

Common size analysis expresses every line item on a financial statement as a percentage of a base – revenue for the income statement, total assets for the balance sheet. This converts absolute dollar figures into relative ones, making trends and comparisons visible that raw numbers obscure.

• Trend analysis – Track how each expense category has moved as a share of revenue over time. A growing cost of goods sold percentage tells a different story than a growing SG&A percentage.
• Cross-period comparison – Scale eliminates the distortion of revenue growth or decline when comparing periods.
• Benchmark comparison – Common size financials enable comparison to industry benchmarks and peers on an apples-to-apples basis.

Seasonality and Trends

Most businesses have a rhythm – peak seasons, slow months, quarter-end pushes, annual renewals. Unless that rhythm is measured, every swing looks like news: a strong month gets celebrated and a weak one triggers alarm, when both were simply the season.

Seasonality and trend analysis separate the recurring pattern from the real change. Together they make period comparisons honest, sharpen forecasts, and show where cash and staffing will be stretched before it happens.

• Seasonal profiles – Each month's or quarter's typical share of annual revenue, cost, and volume, built from your own history.
• Year-over-year comparison – The same period last year as the baseline, so growth is measured against the season, not against last month.
• Seasonally aware forecasts – Budgets and rolling forecasts phased by the real pattern rather than spread evenly across twelve months.
• Trend analysis – The direction underneath the seasonal swings: rolling twelve-month totals and multi-year trend lines that show whether the business is truly growing, flat, or slipping.
• Cash and capacity planning – Anticipating working-capital needs and staffing peaks before the busy season arrives.

KPI Frameworks

Key performance indicators should be specific to your business model, not a generic list borrowed from an industry template. We work with leadership to identify the metrics that are genuinely predictive of business performance – leading indicators, not just lagging ones.

A good KPI framework is concise. Ten metrics that are tracked and acted upon outperform fifty that are reported and ignored. We help businesses cut through the noise to the measures that matter.

• Financial KPIs – Gross margin by product line, revenue per employee, cash conversion cycle, days sales outstanding.
• Operational KPIs – The metrics that connect what happens on the floor or in the field to what appears on the financial statement.
• Leading indicators – Metrics that predict future financial performance before it shows up in actuals.
• Executive dashboards – Consolidating the right KPIs into a single management view, sourced directly from your systems – not assembled in a spreadsheet.