Brazilian E-Commerce SQL Analytics Project

This project is a complete SQL analytics solution built using the Brazilian E-Commerce Public Dataset (Olist Dataset).

It transforms raw e-commerce transactional data into meaningful business insights using SQL.

The project simulates a real-world Business Intelligence environment, focusing on:

Data preprocessing

Data validation

KPI analysis

Customer behavior analysis

Revenue analysis

Operational insights

Strategic decision-making

Technologies Used

SQL Server

T-SQL

Common Table Expressions (CTEs)

Views

Stored Procedures