Supermarket Sales Dashboard - A power BI Project
Power BI Desktop
Supermarket Sales Dashboard
Target
Sales overview
Sales
Customer
behavior
₦ 323K
Performance
Product
All
City
All
Month
All
Clear all slicers
by Olaseni Oyefejo
₦ 315K
Sales and Target by Month
Sum of Sales
Insights
Sum of Target
21.1% 🟢
4.8% 🔴
6.5% 🔴
₦ 100K
% Difference
2.5% 🟢
Months target reached
1
January accounted for 36.01% of Sum of Total.
Sum of Total and Sum of Target diverged the most when the
Month was January, when Sum of Total were 20,291.87 higher
than Sum of Target.
January had the highest Target_status at 1, followed by
February and March, which tied for second at -1.
₦ 50K
Difference
₦ 7,967
At 116,291.87, January had the highest Sum of Total and was
19.62% higher than February, which had the lowest Sum of
Total at 97,219.37.
January had 1 Target_status, February had -1, and March had
-1.
₦ 0K
January
February
Product
Food and beverages
Sports and Travel
Electronic accessories
Fashion accessories
Home and lifestyle
Health and beauty
March
Sales
₦ 56,144.84
₦ 55,122.83
₦ 54,337.53
₦ 54,305.90
₦ 53,861.91
₦ 49,193.74
Target
₦ 55,000.00
₦ 55,000.00
₦ 55,000.00
₦ 50,000.00
₦ 50,000.00
₦ 50,000.00
% Difference
0.02
0.00
-
-0.02
Sales by month
Power BI Desktop
Total customers
Member
Product
All
Month
All
12:00 PM
Yangon, Myanmar
Mandalay, Myanmar
Naypyitaw, Myanmar
113
83
2:00 PM
4:00 PM
74
6:00 PM
75
8:00 PM
How customers paid
34.50%
34.40%
Ewallet
Cash
Product
Food and beverages
Fashion accessories
Health and beauty
Electronic accessories
Clear all slicers
Sports and travel
Home and lifestyle
by Olaseni Oyefejo
102
Time
31.10%
50.1%
Distribution of customers by city
City
10:00 AM
Male
50.1%
89
Day
49.9%
49.9%
103
101
Distribution of customers by gender
Female
Normal
City
Frequency of visits
6.97 👍
Distribution of customers by type
Performance
All
Average rate
1000
Sales overview
Customer
behavior
Supermarket Sales Dashboard
©
©- NavInfo,
NavInfo, ©
©- GrabTaxi,
GrabTaxi, ©
©- TomTom,
TomTom, ©
©- Microsoft
Microsoft Corporation,
Corporation, ©
© OpenStreetMap
OpenStreetMap
Average Rate
-
Credit card
Average Rate by Month
Power BI Desktop
Supermarket Sales Dashboard
Sales overview
Total sales
Total target
Total quantity sold
₦ 323K
₦ 315K
5510
Sales by gender
Customer
behavior
Female
Sales by product line
Male
Food and beverages
Sports and travel
Performance
48.0%
Product
Month
All
Electronic accessories
₦ 54K
Fashion accessories
₦ 54K
₦ 54K
Health and beauty
₦ 55K
Home and lifestyle
City
All
52.0%
All
₦ 56K
₦ 49K
Sales by City
City
Naypyitaw, …
Yangon, My…
Average sales
Day
Mandalay, …
₦ 371
₦ 351
₦ 338
₦ 330
₦ 311
Clear all slicers
Time
₦ 306
₦ 306
₦ 293
₦ 280
by Olaseni Oyefejo
©
©- Microsoft
Microsoft Corporation
Corporation
10:00 AM
12:00 PM
2:00 PM
4:00 PM
6:00 PM
8:00 PM