03
Projects
Amazon Global Sales Analysis
Built a structured star schema (Fact + Dimension tables) from a single flat file, then developed an interactive 2-page Power BI report analyzing Amazon's global sales across 2010–2017.
$143M total sales · Cosmetics #1 category · Offline leads at $85M
Power BIDAXPower QueryData ModelingExcel
HR Analytics Dashboard
Transformed a flat HR dataset into a clean star schema (Fact + Dimension tables), wrote DAX measures, and built an interactive Power BI dashboard to answer: "What are the key drivers of employee attrition, and which employee segments are at highest risk of leaving?"
16.1% attrition rate · Overtime staff 3x more likely to leave · Entry-level at 26.3% risk · Sales dept highest attrition (20.6%)
Power BIDAXPower QueryData ModelingExcel
Adidas Sales Analytics Dashboard
Used SQL to clean and prepare the raw sales data, then built a 2-page interactive Power BI report analyzing Adidas's global sales performance across 2020–2021, with drill-through from top-level KPIs into detailed breakdowns by product, region, retailer, and sales channel.
$899.9M total sales · 294% YoY sales growth (2020 → 2021) · Men's Street Footwear top product (23.2%)
SQLPower BIDAXPower QueryData ModelingDrill-through
