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 (2023 through H1 2026 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 Reporting & 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-out reporting across Wholesale and DTC/Boutique, region, channel, collection, and partner/store, deliberately scoped away from sell-in and margin.
Explore the sell-out reporting pack ↗Full-year performance review for leadership: FY2025 vs. FY2024 revenue, margin, and headcount efficiency, cut by market, channel, and collection.
Explore the year-end review ↗Price, 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.