Advanced SQL Data Warehouse & Business Analytics

Advanced SQL Data Warehouse & Business Analytics ●

Transformed the Central Superstore dataset into a relational star-schema model with fact and dimension tables and primary/foreign-key relationships in PostgreSQl

● Built analytical SQL queries using JOINs, subqueries, CTEs, and CASE expressions; created a view and stored procedure for KPI-oriented analysis.

● Analyzed sales, profitability, customer behavior, and trends, and added indexes to support query performance. Technologies: PostgreSQL, SQL