Toys across US cities - An interactive Excel Dashboard
This dashboard is a complex formula filled dashboard that displays annual and monthly revenue in comparison to previous month and year.
ABOUT
The Dataset consists of information about 34 different toy products sold across cities like Los Angeles, Chicago, and New York. To study its business performance in given regions, an intuitive dashboard has been created that filters based on the regions
Graphical Representation
01
Below are the different graphs that were used to portray statistics necessary to understand revenue in two years.
02
03
Time Series Chart
This chart shows the revenue on a monthly basis between 2020 and 2021.
Bar Plot
Based on Revenue, each store is ranked in descending order to represent best operating business
Tables
The below shows which product drove growth in revenue and which caused losses
04
Cards
This chart shows the revenue on a monthly basis between 2020 and 2021.
Advance Functions Used
-
SUMIFS()
-
MATCH()
-
IF STATEMENTS
-
INDEX()
-
VLOOKUP()
​
​