Developed a comprehensive, 10-page interactive

Developed a comprehensive, 10-page interactive Power BI Executive Dashboard for "Altitude Outfitters" (a multi-channel, multi-currency outdoor retail company operating across 8 countries). The goal was to transform 17 raw, messy tables (~146K order lines) into an automated decision-making tool for leadership. Key Features & Technical Highlights: • Data Cleaning & ETL (Power Query): Cleaned dirty data, handled missing values, removed duplicates, and standardized multi-format dates and currencies using custom M-code. • Data Modeling: Designed a robust Star/Snowflake Schema resolving complex relationships and multi-granularity facts (daily marketing spend, weekly sessions, monthly targets, and order-level sales). • Advanced DAX: Created 50+ measures including dynamic Currency Conversion (Local to USD + Constant Currency FX Impact), Time Intelligence (YTD, YoY), Contribution Margin Waterfall, and Customer Acquisition Cost (CAC). • Deep-Dive Analytics: Built Customer Cohort Retention Heatmaps, RFM Segmentation, Pareto (80/20) Analysis, Marketing Funnel, and an Inventory Health Quadrant (Days of Cover vs. Sales Velocity). • Premium UI/UX Design: Applied a custom JSON dark theme, Field Parameters (dynamic metric switching), 'What-If' scenario sliders for target forecasting, Custom Tooltips, and a seamless Master-Detail drill-through experience using Bookmarks. (Note: Fictional dataset created for portfolio demonstration purposes).