Monthly-Sales-Analytics-Dashboard

Objective

Analyze the superstore’s sales to find:

• Trends across sales,quantity,discounts and profits
• Top customers
• Sales analysis by category and sub-category
• MoM and YoY changes

Dataset

• Source: Sales
• File: "PowerBI_SuperstoreSales - with missing data.xlsx"

Tools Used

• Power BI
• Excel

Skills

-Data modeling, slicers, KPIs, trend analysis

-Data visualization

Github repository

Project

Key Findings

• Profit was the highest in the year 2020
• Electronic items are the most bought by customers
• Quantity of items purchased increased every year

Sample Visual