Sales Performance Dashboard using SQL and Power BI

-- Data Preparation (SQL)

Data cleaning (NULL handling, filtering invalid transactions)

Revenue calculation using Quantity * UnitPrice

Aggregations using SUM(), COUNT(DISTINCT), GROUP BY

Customer lifecycle metrics using MIN(InvoiceDate) and MAX(InvoiceDate)

Structured dataset optimized for BI modeling

Main KPIs:

• Total Customers

• Total Orders

• Total Quantity

• Total Revenue

• MTD Revenue

-- Insights Included:

• Top 10 Countries by Revenue

• Top 10 Customers by Revenue

• Top 10 Products by Revenue

• Monthly Revenue

A second page provides detailed customer analysis including revenue, total quantity, first order date, and last order date

This project strengthened my skills in data cleaning, KPI building, and designing business-focused dashboard