I built this e-commerce analytics case to demonstrate how data can move beyond dashboard reporting into business diagnosis and executive decision support.
The workflow covers the full analytical process:
• data acquisition and preparation
• data modeling and KPI design
• exploratory analysis
• mobile vs desktop conversion diagnosis
• cross-device recovery analysis
• revenue leakage estimation
• Tableau visualization
• executive PowerPoint storytelling
The goal was to show how analytics can identify friction, quantify business impact, and translate findings into clear recommendations.
Tools used: Python, SQL, Tableau, and PowerPoint.
Turning data into insight, and insight into business action.
0
5
A modern Income Statement dashboard built to transform traditional financial reporting into an interactive decision-making tool.
The dashboard combines KPI cards, trend analysis, net income bridge visualization, product line performance, operating expense breakdown, and financial health indicators in one clean executive view. The goal was to make the P&L easier to read, easier to discuss, and much more useful than static spreadsheets or exported statements.
This project reflects my approach to BI: combining financial logic, clear storytelling, and professional dashboard design.
This project shows how Excel, SSRS, and interactive dashboards can work together in one connected financial reporting solution. Excel supports modeling and planning, SSRS delivers structured and printable financial reports, and dashboards provide fast, visual performance analysis. Together, they create a stronger finance environment built on one trusted data source.