I need a polished Power BI dashboard that turns raw data from our e-commerce platform into clear, actionable retail insights. The data connection will come exclusively from that platform’s export (API or CSV), so the first step is shaping and modelling those tables inside Power BI for reliable refresh. Once the model is in place, I want visual stories that highlight two core metrics—Total Sales and Profit Margins—across product categories, time periods and any other meaningful slice you recommend. Drill-throughs that let management move from a high-level view down to individual order or SKU detail will be essential. Although the brief centres on sales and margin, feel free to surface related indicators such as product demand shifts or regional patterns if the data supports them; the goal is to help us spot what is working and where improvement is needed. Deliverables • Clean, well-structured .pbix file with automated connection to the e-commerce data • Interactive pages showcasing Total Sales and Profit Margins with intuitive filters (date, category, promotion, etc.) • At least one deep-dive page that lets users track profitability drivers at SKU level • Documentation (brief PDF or in-report notes) explaining refresh steps and any custom DAX I’ll consider the job complete when the dashboard refreshes without errors on new data, all visuals render within a few seconds, and the narrative around sales and margin feels obvious even to non-analysts. If you’ve built retail or e-commerce dashboards before, please mention examples so I can gauge fit.