Supermarket Sales Dashboard

Tools Used in Project

Excel

Power Bi

Ask

What are the Total Sales, Total Cost of Goods Sold, and Total Quantity in the supermarket?

What is the Total Sales by gender in the supermarket?

How many orders have been placed in the supermarket?

What is the Total Sales by city and gender in the supermarket?

What is the Total Sales by each branch in the supermarket?

What is the Total Sales by customer type and gender in the supermarket?

What is the Total Sales by each product line in the supermarket?

What is the Total Sales by each payment method in the supermarket?

Steps in this project

Get Data From Excel File

Transform data

Create Measures Table

Built Interactive Dashboard

Insert Shapes

Add title and logo

Create Cards