AmitGole31/Sales-Performance-Analysis-SQL-PowerBI

A complete Sales Analysis Dashboard using SQL for data processing and PowerBI for inrteractive visualization.INcludes insights across multiple countries(India,USA ,UK,China,Nigeria,Canada). # 🧠 Sales Analytics Project (SQL + Power BI) | 2025 Portfolio This is a complete data analytics portfolio project focused on *cleaning, analyzing, and visualizing global sales data* using *PostgreSQL* and *Power BI*. It simulates a real-world scenario where a data analyst is expected to merge multiple regional datasets, clean the data, generate insights, and present findings through an interactive dashboard. --- ## 📁 Project Overview In this project, we: ✅ Merged 6 different regional sales datasets ✅ Performed extensive data cleaning in PostgreSQL ✅ Created new KPIs like Total Amount and Profit ✅ Answered key business questions using SQL ✅ Designed an interactive Power BI dashboard for executives --- ## 🧮 Tools Used - *SQL (PostgreSQL)* – For data cleaning and analysis - *Power BI* – For data visualization and dashboard building --- ## 🧹 Data Cleaning Steps in SQL - Merged datasets from Canada, China, India, Nigeria, UK, and US - Handled missing values (Price, Quantity, Country, etc.) - Updated incorrect values using conditional logic - Removed duplicates based on Transaction ID - Created new calculated columns: - Total Amount = (Price Per Unit × Quantity) − Discount - Profit = Total Amount − (Cost Price + Quantity) ## 📊 Key Business Questions Answered - What are the *total sales and profit by country*? - Who are the *top 5 best-selling products*? - Which *sales representatives performed best*? - Which *store locations generated the highest sales*? - What are the *key metrics (min, max, avg)* for sales and profit? --- ## 📈 Power BI Dashboard An interactive Power BI dashboard was built with visuals including: - Country-wise sales & profit - Top performing products and locations - Sales rep performance - Filters for time period, gender, region, etc. ## 💼 Skills Demonstrated - SQL Joins, Aggregations, Window Functions - Data Cleaning using SQL - KPI Calculations and Custom Metrics - Dashboard Design in Power BI - Business Communication through Data …