Welcome to my Olist E-Commerce Sales Analysis Dashboard Project! 🚀 This project dives deep into real-world e-commerce data from the Olist platform (Brazil), transforming thousands of transactions into interactive Power BI insights that visualize sales, orders, customers, delivery times, and product performance across Brazil. 🇧🇷 The goal was to create a comprehensive, business-ready Power BI Dashboard that helps companies understand customer behavior, profit trends, and regional performance, ultimately empowering data-driven decision-making. 💼📈
E-commerce businesses generate massive data daily — from customer orders to shipping and payment details. Through this project, I aimed to uncover key patterns and insights from Olist’s multi-dimensional dataset, focusing on:
- ✨ Understanding sales & profit across different product categories, payment types, and customer states.
- ✨ Analyzing delivery performance and identifying delays or regional bottlenecks.
- ✨ Tracking order status distribution, payment trends, and average freight costs.
- ✨ Discovering which regions and product types drive the most revenue and growth.
- ✨ Building an interactive Power BI dashboard using advanced DAX calculations and data modeling. By connecting insights to business goals, this dashboard delivers strategic clarity for e-commerce success. 💡📊
- 🔹 Perform data cleaning, transformation, and integration from multiple CSV files.
- 🔹 Conduct exploratory data analysis (EDA) to understand sales, geography, and customer segments.
- 🔹 Create a data model with relationships across orders, items, products, payments, and customers.
- 🔹 Design interactive visuals and KPIs for executive-level reporting.
- 🔹 Develop DAX measures for profit, sales trends, delivery performance, and payment behavior.
- 🔹 Build a modern Power BI dashboard with slicers, filters, and custom charts.
- 🔹 Extract meaningful business insights to guide strategic e-commerce decisions.
- KPI Cards 📈
- Donut & Bar Charts 📊
- Line & Area Charts 📉
- Map Visuals 🗺️
- Tree Maps 🌳
- Tables & Filters 🎛️
The Olist dataset consists of multiple CSV files containing detailed transaction-level data, including:
- 📦 Orders Data – Order IDs, purchase dates, delivery times.
- 👤 Customer Data – Location, customer IDs, and state.
- 💰 Payment Data – Payment types, installments, and total values.
- 🛒 Order Items – Product categories, prices, and freight charges.
- 🏷️ Products Data – Category details and dimensions.
- 🕒 Review Data – Customer satisfaction and feedback scores.
- Imported all CSV files into Power BI.
- Handled missing values and duplicate records.
- Merged multiple tables using Power Query Editor.
- Standardized column names and data types for accuracy.
- Built relationships between orders, customers, items, and payments tables.
- Created calculated columns (e.g., Delivery Days, Profit Margin, Total Price).
- Used DAX measures to compute KPIs like Total Sales, Average Delivery Time, and Revenue by Region.
- Explored regional sales patterns across Brazilian states.
- Analyzed top-selling categories and most profitable segments.
- Investigated customer payment behaviors and installment trends.
- Visualized delivery time performance to identify delays.
- Compared sales trends over time to spot growth seasons.
Designed a multi-page Power BI dashboard featuring:
- ✅ KPI Summary Cards (Total Sales, Orders, Customers, Profit)
- ✅ State-wise Map Visualization for regional sales 🗺️
- ✅ Category & Product Performance Charts 📊
- ✅ Payment Type Distribution Donut Chart 💳
- ✅ Delivery Time Analysis Line Chart 📈
- ✅ Interactive Filters for Month, Category, and State 🎛️
Key discoveries from this dashboard include:
- 🔝 Top-performing categories: Electronics & Construction materials.
- 📈 Most active customers: Concentrated in São Paulo & Rio de Janeiro.
- 💳 Payment insights: 77% of payments occur on weekdays.
- 📆 Time-based trend: Sales peak between March–May 2018.
- 🚚 Delivery insights: Average delivery time of 12–15 days across states.
- 💰 Profit distribution: Majority from high-value urban regions.
- 📌 Power BI Dashboard → Olist_Ecommerce_Analysis.pbix
- 📌 Cleaned & Transformed Dataset → Olist_Cleaned_Data.xlsx
- 📌 Insight Report (PDF/Docx) → Olist_Ecommerce_Report.pdf
This project demonstrates the power of Power BI and data analytics in transforming complex e-commerce datasets into clear, actionable business insights. By leveraging data modeling, DAX, and dynamic visualizations, I was able to build an interactive analytical tool that helps businesses:
- ✅ Identify profitable regions & products
- ✅ Understand customer payment behavior
- ✅ Improve delivery efficiency
- ✅ Enhance marketing & operational decisions This journey strengthened my data storytelling and Power BI development skills — proving that with the right tools, data truly speaks for business success! 💬📈
🚀 Portfolio: https://my-dashboard-canvas.lovable.app/
🌐 Kaggle: https://www.kaggle.com/abdullahumar321
👔 Medium: https://medium.com/@umerabdullah048
📧 Email: umerabdullah048@gmail.com
