Projects and case studies
These case studies describe the problem, data, approach, tools, and solution, along with verified outcomes or the limits of each analysis and what I learned.
Anonymized professional work
Current work building and maintaining a Power BI model and dashboard for project-costing, margin, and operational KPI reporting. Includes data preparation and dynamic row-level security; internal data and model details are not disclosed.
Simulated-data portfolio project
A Python analysis comparing two checkout-flow groups in simulated Australian e-commerce session data. The reported results describe only this sample and do not represent a real retailer or business impact.
Synthetic-data portfolio project
A Python notebook applying recency, frequency, and monetary scoring to synthetic Australian retail transactions. Its segment labels describe this sample only and are not measured retention outcomes.
Synthetic-data portfolio project
A Power BI report built with synthetic, AI-assisted retail data, showing sales and profit by suburb and customer tier alongside month and year comparisons. All displayed values are illustrative sample outputs, not real business results.
Synthetic-data SQL exercise
SQL aggregations compare synthetic rows across channels, product categories, stores, and customer tiers. The source data has inconsistent order-line identifiers, customers, and dates, so order-level metrics and business conclusions are not reliable.