Ecommerce Sales Analysis Dashboard

This Project is about Ecommerce Sales Analysis. In this project, I have used several YOY (year-on-year) KPIs. I have used slicers by year, region and segment so that we filter our data according to year, month and segment. I have used several visualization charts to make it attractive as I used Donut chart for representing Category wise Sales Share %, Stacked Column Chart for Sales and Profit Analysis, Map chart for representing sales by state.

Learnings from Project-

How to clean data in Excel.

How to create a pivot table in Excel.

How to build relationships between tables in Excel.

How to create KPIs and different visualization charts in Excel.