Santino Adduca | Data Analyst

Explore more projects: Data Porfolio

📌 Project Overview

This end-to-end Business Intelligence project is based on the public Brazilian e-commerce dataset provided by Olist, a marketplace that connects small and medium-sized sellers to major marketplaces in Brazil.

The project simulates a real corporate BI environment, covering the full analytical workflow:

• Data ingestion and modeling in SQL Server
• Analytical dataset construction
• Executive dashboard development in Power BI
• Business-oriented insight generation aligned with a marketplace revenue model

The focus is not only on visualization, but on translating data into strategic interpretation within the context of a multi-seller platform.

🎯 Objective

To simulate a corporate Business Intelligence environment using Olist’s public Brazilian e-commerce dataset.

The goal was to transform raw data into actionable insights to:

• Monitor commercial performance
• Analyze sales and logistics contribution
• Evaluate temporal growth dynamics
• Detect regional and category-level patterns
• Interpret pricing behavior within a marketplace structure