Telling the Story

profilejugxyaev
powerpoint.pptx

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