Brazilian E-Commerce

An interactive dashboard developed as part of my data analytics portfolio to explore sales performance across the Brazilian E-Commerce Public Dataset. About 100k orders placed between Sep 2016 and Aug 2018.

The data was modeled in a SQL Server data warehouse and exposed to Power BI as a star schema with 4 fact tables and 6 dimensions. Every visual has a dynamic subtitle that states its takeaway for the selected filters.

Key findings: net revenue reached R$ 13.49M from 98,199 orders, with 65.4% coming from the Southeast and 80% from only 18% of sellers. Orders delivered late score 2.3 stars on average, against 4.3 when on time, and 171 top sellers ship late more often than the 9.3% average, putting 24.7% of revenue at risk.

The report has three pages:

• Sales Overview
• Sellers & Logistics
• Delivery & Reviews

You can navigate using the icons on the left panel.

Skills: Data modeling, DAX, KPI development, interactive visualization.

Feedback on the design, analysis and storytelling is welcome!