Portfolio

Featured Projects

Each project follows the same arc: a real business problem, a disciplined analysis approach, and a dashboard or report built for decision-makers. Detailed case studies are being documented and published progressively.

Healthcare · Operations

Healthcare Operations & Revenue Analysis

Business problem

Leadership lacked a consolidated view of how patient admissions, medical conditions, medication use, and insurance billing interact — making it hard to explain why revenue moved and where claim denials were eroding margin.

A six-year Power BI analysis of patient demographics, admissions, medical conditions, medications, lab results, and insurance billing — built to answer ten stakeholder questions about care delivery and revenue performance.

SQLPower BIPower QueryDAXData Modeling

View Project

Abstract retail sales analytics visual with donut, line, and bar chart motifs in teal and blue

Retail · Sales & Profitability

BrightMart Sales Analytics

Business problem

BrightMart, a retailer operating across Atlantic Canada, needed to know how it could improve profitability — which regions, categories, salespeople, channels, and months actually drive performance, and where cost is quietly eating margin.

A retail sales analysis combining T-SQL aggregation in Microsoft Fabric with a Python/Jupyter exploratory notebook — covering revenue, cost, profit, margin, discounting, returns, and channel and segment behaviour.

SQLPythonJupyterpandasMatplotlibMicrosoft Fabric

View Project

Sales analytics visualization with a heat map of Illinois, bar charts, and a donut chart

Consumer · Sales

Illinois Lottery Sales & Consumer Analytics

Business problem

Statewide lottery sales data is fragmented across products, regions, and retail channels, obscuring the consumer patterns that drive revenue.

Exploratory analysis and segmentation of sales by product, geography, and ticket type to reveal demand patterns, seasonal trends, and underperforming segments.

PythonSQLPower BIExcel

View Project

Logistics analytics visualization with a route network map and cost comparison charts

Transportation · Operations

Transportation Route Cost Analysis

Business problem

Route-level transportation costs vary widely, and without a consistent cost model it is difficult to see which routes erode margin.

A route cost model comparing cost per mile, per stop, and per route over time — isolating the operational factors behind cost variance.

SQLPower QueryPower BIExcel

View Project

Financial analytics visualization with trend lines comparing fuel price indices and surcharges

Finance · Pricing

Fuel Surcharge Analysis

Business problem

Fuel surcharges must track volatile fuel price indices — misalignment quietly impacts margin and billing accuracy.

Trend and variance analysis of surcharge schedules against fuel price indices, with dashboards that highlight gaps and forecast exposure.

ExcelPythonDAXPower BI

View Project

Marketing analytics visualization with a conversion funnel and campaign performance bar charts

Marketing · Performance

Marketing / Event Performance Analytics

Business problem

Marketing and event spend is often reported in silos, making ROI comparisons across campaigns and channels unreliable.

A performance scorecard framework that standardizes acquisition, engagement, and ROI metrics across campaigns and events for apples-to-apples comparison.

Power BISQLExcel

View Project