Excel Olist Stores Dashboard

Olist is a Brazilian e-commerce platform that allows businesses to sell their products online.

Analyzing Olist store data can provide valuable insights into sales performance, customer behavior, product trends, and more.

This Dashboard represents various Visualizations representing analysis of various statistical data.

KPIs :

• Pie Chart: It represents Weekend/Weekday Payment Statistics
• Donut Chart: It represents an average of profit against a few products.
• Column Chart: It represents No. of orders with a review score '5' and payment type 'credit card'
• Clustered Column Chart: It represents the Average of Payment value and an average of price by city

Filters

• Day Filter: Day wise filter customizes the dashboard according to the selected day of the week
• Quarter Filter: Quarter-wise filter alters the data according to the quarter selected from Q1 to Q4.
• Year Filter: year-wise filter changes the data according to the year selected
• Month Filter: It alters the data according to the month selected.