SQL Data Analytics Project

This repository contains an end-to-end data analytics project built using SQL Server and Power BI.

The project focuses on exploring sales, customer, and product data to uncover business insights through SQL analysis and interactive data visualization.

Project Overview

The project uses a structured sales dataset to perform exploratory and advanced analytical analysis.

SQL is used to investigate the data, calculate key business metrics, identify trends, analyze customer and product performance, and answer real-world business questions.

The resulting insights are then presented through interactive Power BI dashboards.

Tools & Technologies

• SQL Server
• T-SQL
• Power BI
• DAX
• Git & GitHub
• SQL Server Management Studio (SSMS)

Repository Structure

SQL-Data-Analytics-Project/
│
├── datasets/
│   ├── dim_customers.csv
│   ├── dim_products.csv
│   └── fact_sales.csv
│
├── scripts/
│   ├── 00_init_database.sql
│   ├── 01_database_exploration.sql
│   ├── 02_dimensions_exploration.sql
│   ├── 03_date_range_analysis.sql
│   ├── 04_measures_exploration.sql
│   ├── 05_magnitude_analysis.sql
│   ├── 06_ranking_analysis.sql
│   ├── 07_change_over_time_analysis.sql
│   ├── 08_cumulative_analysis.sql
│   ├── 09_performance_analysis.sql
│   ├── 10_data_segmentation.sql
│   ├── 11_part_to_whole_analysis.sql
│   ├── 12_report_customers.sql
│   └── 13_report_products.sql
│
├── powerbi/
│   └── sales_analysis.pbix
│
├── screenshot/
│   └── Queries Result & Dashboard screenshots
│
├── LICENSE
└── README.md

SQL Analysis

The SQL analysis covers several analytical techniques, including:

• Database and dimension exploration
• Date and time analysis
• Key business measures
• Magnitude analysis
• Ranking analysis
• Change-over-time analysis
• Cumulative analysis
• Performance analysis
• Customer segmentation
• Part-to-whole analysis
• Customer analysis
• Product analysis
• Sales analysis

These analyses are designed to answer practical business questions and identify meaningful patterns in the data.

Power BI Dashboard

The Power BI section transforms the analytical results into interactive dashboards that provide a visual overview of business performance.

The dashboard focuses on areas such as:

• Sales performance
• Sales trends
• Customer performance
• Product performance
• Product categories
• Key business KPIs
• Customer purchasing behavior

Dashboard screenshots are available in the screenshot folder.

Project Objectives

The main objectives of this project are to:

• Practice real-world SQL data analysis
• Explore and understand business datasets
• Analyze customer, product, and sales performance
• Identify trends and patterns over time
• Develop meaningful business metrics
• Transform SQL analysis into interactive visualizations
• Build a practical Data Analyst portfolio project

Key Skills Demonstrated

This project demonstrates practical experience with:

• SQL data exploration
• Data aggregation
• Filtering and grouping
• Joins
• Window functions
• Common Table Expressions (CTEs)
• Date and time analysis
• Customer and product analysis
• Business KPI development
• Data segmentation
• Ranking and performance analysis
• DAX
• Power BI dashboard development
• Data storytelling

Project Workflow

Dataset
   ↓
SQL Server
   ↓
Data Exploration
   ↓
SQL Analysis
   ↓
Business Insights
   ↓
Power BI
   ↓
Interactive Dashboard