SQL Project

Overview

A SQL-based data analytics project that focuses on exploring and analyzing ERP and CRM datasets. It includes multiple SQL scripts for database exploration, data segmentation, time-based trends, and performance analysis. The project highlights how SQL alone can be used for data-driven insights and reporting.

Key Features

• SQL-Only Implementation:
• All analyses are performed using pure SQL, without any external tools or programming languages.
• Data Exploration:
• Scripts for understanding database structure, relationships, and key dimensions.
• Analytical Queries:
• Includes ranking, segmentation, cumulative, and performance analysis.
• Time-Based Analysis:
• Tracks trends and changes across different time periods.
• Analytics & Insights:
• Analyzes sales trends, customer segments, and product performance using SQL queries.
• Modular Design:
• Each SQL script focuses on a specific analytical task for better clarity and reusability.
• Report Generation:
• Creates customer and product reports to uncover business insights.

Project Visuals