Telling the Story
Benchmarks And Interactive Dashboards
INTRODUCTION
Interactive dashboards have become quite popular for making presentations.
They increase the visualization of a presentation.
Data is well represented using interactive dashboards by using the most crucial information in the excel workbook.
The goal is to create graphs, and charts without including excessivce data.
DATA INDENTIFICATION
The first step when creating an interactive dashboard is to identify the most important data in a workbook.
In case there are several worksheets, the most crucial data in each worksheet needs to be identified.
Important data is recognized using the major objectives that were followed when creating a workbook file.
Product/Subcategory Sales
Sales by Product Category
Product/Region Sales
Profit Map
Profit Chart
Phones have the highest profit in the Central region
Bookcases have the highest profit in the Northern region
Bookcases have the highest profit in the Southern region
STORY TELLING
Tables provide the highest negative profit in the Central region
Furnishings provide the highest negative profit in the Northern region
Tables provide the highest negative profit in the Southern region
THANK YOU