SQL Sales Analytics Dashboard

A comprehensive SQL-only analytics project demonstrating mastery of relational database querying, from basic aggregations to advanced window functions and cohort analysis on a structured sales dataset.

Translate business questions — revenue trends, customer retention, product performance, and regional breakdowns — into clean, efficient SQL queries that a stakeholder can read, audit, and extend without Python or BI tooling.

Designed a normalized relational schema for the sales domain. Used CTEs for query modularity, window functions for rankings and running totals, and conditional aggregations for pivot-style reporting. Built a suite of analytical queries covering KPIs, cohorts, and performance rankings.

A fully documented SQL analytical suite ready for integration with any BI tool (Tableau, Power BI, Metabase). Demonstrates the ability to deliver insights through pure SQL — the most universally required data skill in corporate environments.