Olist-Ecommerce-Sales-Analytics-Dashboard-

This project analyzes the Brazilian Olist e-commerce dataset using **Python, SQL Server, Power BI, Power Query, and DAX**.

The complete workflow was carried out in a structured sequence:

1. Raw data collection

2. Python-based data profiling

3. SQL database setup

4. Data validation and quality checks

5. Clean dimension and fact table creation

6. Date dimension creation

7. Relationship validation

8. Power BI data import and modeling

9. DAX measure creation

10. Interactive dashboard development

11. Dashboard testing and final export

12. GitHub project documentation

The final Power BI report contains four pages:

1. Executive Overview

2. Sales & Product Analysis

3. Customer & Delivery Analysis

4. Seller & Review Analysis