Work
Projects and case studies
Financial planning, financial analysis, governance and advisory work. Each case study covers the problem, the data, the approach, the insights and the tools.
- Revenue forecastIllustration
Actual and forecast (index)
ActualForecast with rangeScenarios
Downside92Base100Upside109Price effect vs volume effect
Employer data, method only2023Financial planning, Financial analysis
Revenue Analysis and Forecast for an Industrial Gases Business
Three years of revenue transactions analyzed by category and product, linked to exchange rate movements, compared with forecast and extended into a next-year forecast with scenarios.
- Excel
- Power Pivot
- Forecast sheets
- Scenario Manager
- Delegation of authorityIllustrationDecision≤ 50k≤ 250k≤ 1m> 1mPurchase ordersDept. headFinanceGMBoardSales discountsDept. headDept. headFinanceGMPayment releaseFinanceFinanceGMGMNew hiresDept. headGMGMBoardCapital expenditureFinanceGMBoardBoardPrepare and approveReview before approvalEscalate
Illustrative exampleGovernance
Delegation of Authority and Approval Matrix
How I structure a delegation of authority: decisions grouped by process, value limits, and a clear line of who prepares, reviews and approves. Includes an interactive approval path explorer.
- DOA
- Approval matrix
- Policies & SOPs
- KPIs
- Policies and SOPsIllustration
Document hierarchy
PolicyProcedure (SOP)Work instructionForm and recordRACI
UserDept.FinanceGMRequestRAIReviewCRAApproveICRADocument register
CodeDocumentVer.StatusPOL-FIN-01Procurement policy2.0ApprovedSOP-FIN-04Vendor payment1.3ApprovedSOP-HR-02Hiring request0.9In reviewFRM-PUR-07Purchase request1.1ApprovedSOP-SAL-03Credit approval0.4DraftIllustrative exampleGovernance
Policy and SOP Framework
A document system for a growing company: a clear hierarchy from policy to form, version control for every document, and a RACI that says who does what in each procedure.
- Policies & SOPs
- RACI
- Document control
- Excel
- Income Statement Analysis from Raw Data (FY16 to FY18)Real dataLive dashboard
Jul 2026Financial analysis
Income Statement Analysis from Raw Data (FY16 to FY18)
Three years of raw P&L account balances turned into a multi-year income statement, variance and common-size analysis, and an interactive dashboard.
- Excel
- Formulas
- VBA
- Dashboards
- Balanced scorecardIllustration
Financial
EBITDA margin92%Cash conversion74%Customer
On-time delivery96%Repeat orders81%Internal processes
Approval cycle time63%Closing on day 588%People and growth
Training hours70%Key roles covered90%On targetWatchOff track, action loggedIllustrative exampleGovernance
KPI Framework and Balanced Scorecard
A company scorecard that links strategy to a short list of KPIs across four perspectives, each with an owner, a target, a traffic-light status and a review rhythm.
- KPIs
- Balanced scorecard
- Excel
- Power BI
- Sales dashboardIllustrationSales4.8MProfit1.6MUnits132kAllQ1Q2Q3
Sales by month
By channel
Client engagementDec 2024Advisory, Financial analysis
Management Dashboard in Power BI
Client: Healthcare services
An executive dashboard requested by management: the headline numbers, monthly trends, sales split and a regional view on one Power BI page, with slicers for period and region.
- Power BI
- Data modeling
- DAX measures
- Revenue and Cost Performance AnalysisReal dataLive dashboard
Oct 2023Financial analysis
Revenue and Cost Performance Analysis
Two years of sales invoices from the public Adidas sales sample data set, modeled in Excel and Power BI to answer management questions on revenue, cost and profit.
- Power BI
- Excel
- Power Query
- Power Pivot
- Profitability Analysis by Segment and CategoryReal dataLive dashboard
Sep 2023Financial analysis
Profitability Analysis by Segment and Category
Close to 10,000 retail order lines turned into a decision-ready profitability report with a Power Pivot data model, KPI tracking and interactive dashboards.
- Excel
- Power Query
- Power Pivot
- DAX measures
No projects in this category yet.
Need something similar?
Tell me about your case and I will suggest a scope.
