Business analysis, documented from question to decision.
Each case makes the business question, my contribution, KPI logic, validation evidence and interpretation limits visible for review.
Selected case studies
Analysis you can inspect, not just read about.
Two end-to-end cases show how I frame a business question, govern the measures, test the result and communicate a responsible recommendation.
Define a defensible comparison
EU Digital Procurement Competition Monitor
Independent end-to-end case study · Public data · Documented stakeholder scenarios
Executive dashboardVerified repository output
The business question
How can public-procurement teams screen digital procurement results for competition patterns while retaining a traceable, reproducible evidence trail?
My contribution
I documented requirements, defined the evidence cohort and KPI rules, and connected the analysis to data checks, UAT and reporting outputs.
Keep the denominator visible
The single-bid rate uses the 27,100 notices with competition evidence, not all 38,971 notices. Keeping that boundary visible prevents missing evidence from being treated as a competitive outcome. The result is a screening signal for further investigation, not a finding of misconduct.
Review the KPI definition, evidence cohort and validation checks.
Dataset scale: 38,971 EU-27 digital result notices analysed
E-Commerce Sales, Cancellations & Customer Value Decision System
Independent end-to-end case study · Public data · Documented stakeholder scenarios
Executive dashboardVerified repository output
The business question
Where should an e-commerce leadership team focus first to protect sales value, reduce cancellation exposure and retain valuable customers?
My contribution
I documented business requirements and KPI rules, built the SQL model and dashboard, and linked requirements to UAT checks and output evidence.
Keep sales separate from profit
The source contains transactions but no cost or cancellation-reason fields. I report sales and cancellations separately without presenting net sales as profit. Assessing profitability or explaining why orders were cancelled would require additional data.
Follow a requirement through the KPI definition, SQL output and UAT check.
