E-Commerce Retail Sales Performance Analytics

SQL Server | Excel | Power Pivot | Performance Analysis

Project Overview

This project analysis focuses on E-commerce retail sales performance, profitability, customers,and products using SQL Server connected with Microsoft Excel.

SQL Server was used to prepare and structure the analytical data before connecting the final dataset with Excel and Power Pivot.

The analysis shows ($733,216) in revenue across (1,525) product and (693) customers creates (1,687) orders with (535) AVO, by around (7) quantity per order

For full discription include (Executive Summary - Business Problem - Skills And Methodology - Results - Strategic Recommendations - Next Steps)

Please check my Readme Page GitHub

SQL Server • Excel • Power Query • DAX • Data Modeling • Power Pivot • Pivot Table

Interactive Excel Dashboard

Open Excel Workbook ↗

Project Screenshots

Explore the dashboard pages, data modeling, DAX measures and SQL views. Select any image to open the original screenshot in a new tab.

Sample Home Page Navigation
01 — Sample Home Page Navigation
Sales Page
02 — Sales Page
Product Page
03 — Product Page
Customer Page
04 — Customer Page
Profit Page
05 — Profit Page
Data Modeling Relationships
06 — Data Modeling Relationships
Calendar Table Created
07 — Calendar Table Created
DAX for KPI Performance
08 — DAX for KPI Performance
Product View Table
09 — Product View Table
Sales View Table
10 — Sales View Table
Customer View Table
11 — Customer View Table

Project Walkthrough

A short video explaining the business problem, data preparation, sales analysis and dashboard results will be added here.

▶

Project Walkthrough — Coming Soon

Video walkthrough will be available here in a future update.

← Back to Portfolio