Excel for Data Dashboards and Visualization
What Is a Dashboard?
Business Intelligence is a hot commodity in today’s world, and dashboards are the most frequently used method of providing that information.
Through dashboards, we compile the data, in the form of analysis and charts.
The same should fit entirely on a single computer screen so it can be monitored at a glance.
Planning
At the planning stage, one must have a look at the following:
• Why are you creating a dashboard?
• Who is the audience?
• What are the KPIs (Key Performance Indicators) that you have to demonstrate?
• What is the time period, for example, a month, quarter, ...
Get MS Excel, Second Edition, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
