Assume, you have the sales data for last 5 years, and it has 5000 stores across the world. For example, you may be developing a dashboard to understand the sales of a Super Market. When we deal with large amount of data (time series/ historical) or data with more number of categories, Fields/Columns/Variable or Records, we need to provide interactivity to understand the data in-depth. Dashboards helps to quickly understand the key metrics and delivered as simulation tool for quick data analysis.
Dashboards are visually displayed with combination of Tables, Charts and Pivot tables and Insights for Analyzing the Data. What is a Dashboard? And what are the Interactive Dashboards?ĭashboard is a kind of report or a simulation tool to displaying important data or information at a single place to get the quick understanding of the data. Tools for building Rich Interactive Visualized Dashboards:.Practical Learning – Creating Dashboards using Excel VBA:.Concepts we should understand to develop Interactive Dashboard:.What is a Dashboard? And what are the Interactive Dashboards?.We will develop a simple interactive dashboard, I will take the last updated simple sample dashboard and enhanced it by using VBA.
We will see the basic things that we need to understand to create dashboards and then we will learn how to create stunning and rich visualized dashboards.
This tutorial explains creating interactive dashboards using Excel VBA with example file which you can download.