Applied FP&A / Financial Controller Project
This project demonstrates data and business analysis: disciplined data modeling, structured decision support, and translating numbers into a clear narrative for stakeholders. It is built here through a Financial Controller / FP&A lens, for Meridian Time Group, a fictional multi-collection consumer goods manufacturer: ten product collections, from clean three-hand designs to a flagship complication line, sold through wholesale and boutique channels with an EMEA and LATAM focus.
The scenario runs on a purpose-built dataset (three years of sell-in, sell-out, budget, cost, and working-capital data) so every model, dashboard, and report below is built against real transactional structure rather than static screenshots.
Looking for quick, standalone report samples instead? See the Data Visualisation section on the CV.
Status
A star-schema data model (10 dimension and 9 fact tables) generated synthetically and packaged as a portable SQLite reference, with a T-SQL migration path to SQL Server for live Power Query connections.
Explore the data foundation ↗Annual budget build by collection, channel, and market: unit, price, and cost assumptions rolled up to revenue and margin.
Explore the budget model ↗Computed forecast vs. budget, driven automatically by a growth-rate engine against actuals, at full channel, collection, and country grain.
Explore the forecast model ↗Recurring sell-in and sell-out reporting pack across regions, channels, and collections.
PlannedFull-year performance narrative for leadership: budget vs. actual by market and collection.
PlannedPrice, volume, and mix variance breakdown across collections, channels, and markets.
PlannedReceivables, inventory, and payables tracking by market, plus boutique capital expenditure and payback.
PlannedStandard cost build-up (materials, labor, overhead) and inventory valuation by SKU and market.
PlannedThis page reflects where the project actually stands, not where it's headed; the roadmap above will update in place as each capability ships.