SQL & Database Analysis for Olist E-Commerce

Designed and executed advanced SQL queries to analyze the Olist Brazilian E-Commerce database using PostgreSQL and pgAdmin 4.

Key Tasks & Achievements:

- Modeled database schemas and established table relationships and data constraints.

- Developed optimized SQL queries to calculate key performance indicators (KPIs), such as Average Order Value (AOV), total order volumes, and top-performing product categories.

- Applied aggregation, filtering, and table joins (GROUP BY, HAVING, JOINs) to clean data and extract actionable insights.

- Generated structured summary reports to evaluate regional sales performance and customer review distributions.

Tools & Technologies Used: PostgreSQL, pgAdmin 4, Relational Databases (RDBMS), SQL Queries.