Hello!
📊 What better way to consolidate what you’ve learned than through a real project?
As part of my transition into the data analytics world, I developed a complete dashboard using Olist's dataset – a Brazilian e-commerce platform. The goal: apply my skills in SQL, Power BI, and storytelling in a project as realistic as possible.
🛠️ I loaded the data into a MySQL database on AWS using Python, and handled most of the transformations in SQL, leveraging its efficiency to keep Power Query as lightweight as possible.
I designed a star schema model with three fact tables (orders, order_items, payments) and supporting dimension tables, including two calculated ones for Brazilian states and product categories. All DAX measures are centralized in a dedicated table for easier maintenance.
💡 Key highlights:
🔹 DAX Measures: From basics like Total Revenue and Profits to advanced ones like YTD, PYTD, MoM, and others used in custom visuals.
🔹 Parameters: Two core parameters allow users to control how many categories are displayed per page in a custom chart.
🔹 Bookmarks: Enable switching between views (time-based and interchangeable visuals) without duplicating report pages.
🔹 BINs: Used to group customer age ranges and number of credit card installments for more segmented analysis.
🔹 External Tools: Leveraged Bravo to simplify and optimize the data model.
📄 The dashboard contains 6 main pages:
🔸 Summary: Business overview, revenue and profit trends, and top categories and regions by profitability.
🔸 Products: In-depth analysis of product performance, pricing, purchase frequency, and profitability by subcategory.
🔸 Logistics: Assessment of delivery performance and delays, segmented by state and category.
🔸 Customers: Customer profile by age and buying behavior, including preferred payment methods.
🔸 Sellers: Performance comparison between vendors and their historical evolution.
🔸 Reviews: Analysis of customer satisfaction, trends over time, and how delivery delays impact ratings.
📌 Assumptions:
✔ Olist earns 30% of the product price.
✔ The customer pays for both the product and shipping.
✔ Olist handles the logistics.
✔ Target: ≤ 5% of late deliveries.
✔ Ratings ≥ 4 are considered positive.
eyJrIjoiNTU4Nzg3NDUtMTg0Ni00ZjU0LTg4NTAtMmQ4ZGUxZWNjMDRmIiwidCI6ImQ5ZDE4ZGQzLWQwMTItNGFjNS04NWViLTM2Yzc5MzZkOWRlMCJ9
