Olist E-Commerce Business Intelligence Analysis

Designed and developed an end-to-end Business Intelligence solution using Power BI to analyze Olist's e-commerce operations. The project included data cleaning, data modeling with a Star Schema, DAX measure development, and interactive dashboard design.

The solution provides actionable insights across four business areas:

📊 Executive Dashboard

💰 Sales Analysis

📦 Product Analysis

👥 Customer Analysis

Key achievements:

Performed comprehensive data cleaning and validation (missing values, duplicates, data consistency, and referential integrity).

Built an optimized Power BI data model with fact and dimension tables.

Developed dynamic DAX measures and KPIs for business performance analysis.

Designed interactive dashboards with drill-through, bookmarks, slicers, and navigation buttons.

Delivered business insights to support data-driven decision-making.

Tools & Technologies: Power BI, Power Query, DAX, Data Modeling, Data Cleaning, Data Visualization.