TechMart Sales Analysis

Project Overview

This project simulates a real-world e-commerce database for "TechMart Pakistan". The goal was to analyze sales trends, identify high-value customers, and calculate category performance using PostgreSQL.

Tools Used

• Database: PostgreSQL 16
• Interface: DBeaver
• Language: SQL (Standard)

Key Business Insights

1. Revenue Drivers: Identified "Laptops" as the highest revenue-generating category, significantly outperforming others.
2. High-Value Customers: Isolated a segment of customers spending >50,000 PKR to target for future loyalty programs.
3. Performance Benchmarks: Calculated average transaction values to filter out underperforming product categories.

Skills Demonstrated

• DDL & DML: Creating table structures and inserting transactional data.
• Complex Filtering: Using WHERE, AND, and wildcards for pattern matching.
• Advanced Aggregation: Using GROUP BY, SUM, and AVG for reporting.
• Logical Constraints: Filtering aggregated groups using HAVING.

How to Run

1. Download the TechMart_Analysis_Script.sql file.
2. Open it in DBeaver or any SQL tool.
3. Run the script to create the database and view the analysis results.