SQL-based business performance analysis project focused on sales, customer, and product KPIs using data analytics and business intelligence techniques.
This project analyzes business performance using SQL by focusing on three major business areas:
- Sales Performance
- Customer Behaviour
- Product Performance
The analysis was performed to identify trends, evaluate KPIs, and generate actionable business insights.
- SQL
- PostgreSQL
- Power BI
- Excel
sql/
│
├── sales_kpis.sql
├── customer_kpis.sql
└── product_kpis.sql
The sales analysis focused on evaluating revenue performance and business growth.
- Total Sales
- Sales Growth %
- Average Order Value (AOV)
- Running Total Revenue
- Monthly Sales Trends
- Revenue Contribution %
- Revenue showed steady growth over time.
- Certain periods generated significantly higher sales.
- A small number of categories contributed most revenue.
The customer analysis focused on spending behaviour and customer value.
- Total Customers
- Customer Lifespan
- Customer Recency
- Average Monthly Spend
- Purchase Frequency
- Customer Segmentation
- VIP Customers
- Regular Customers
- New Customers
- VIP customers generated the highest revenue.
- Repeat customers showed stronger purchasing behaviour.
- Customer retention improved long-term sales performance.
The product analysis evaluated product performance and category contribution.
- Product Revenue
- Total Quantity Sold
- Product Performance Ranking
- Revenue by Category
- Average Product Cost
- High-Performers
- Mid-Range
- Low-Performers
- High-performing products generated most business revenue.
- Some categories consistently outperformed others.
- Product demand varied across time periods.
The SQL analysis was visualized using dashboards and charts including:
- Revenue Trend Charts
- Customer Segment Analysis
- Product Performance Dashboards
- Category Revenue Analysis
- Running Revenue Trends
This project demonstrates how SQL can be used to analyze business performance, calculate KPIs, identify trends, and generate business insights for decision-making.