Olist E-Commerce Performance Analysis

Tools: Power BI, SQL, Excel, Power Query, DAX

• Analyzed a Brazilian e-commerce dataset containing 9+ interconnected tables

covering orders, customers, products, sellers, payments, and reviews.

2024

• Performed data cleaning and transformation using Power Query and prepared data

for analysis.

• Built a relational data model to connect multiple business entities and support

comprehensive analysis.

• Developed interactive Power BI dashboards to analyze sales, customer behavior,

product performance, seller performance, delivery, and customer satisfaction.

• Created DAX measures and KPIs to evaluate business performance and identify

key trends and insights.

• Generated actionable business recommendations based on data-driven findings.