Eeshani Oct 25, 2015 No Comments
What is Data Visualization?
It is the presentation of the data in pictorial form. Data when presented in form of graphs rather than tables helps us to get the insights quickly. Patterns, trends and correlations which might go undetected in tables can be easily recognized through the data visualization tools.
The most commonly used Data Visualization tools are:
• MS-Excel (one of the oldest tool)
Data Visualization Using Dashboards
A dashboard is a visual interface that provides at-a-glance views into key insights of a business process. A dashboard has three key attributes.
1. Displays data graphically in form of charts and helps focus attention on key trends and comparisons.
2. Displays only data that is relevant to the goal of the dashboard
3. Relieves the user from having to perform their own analysis by having predefined conclusions relevant to the goal of dashboard
Steps of Creating a Dashboard
1. Understand the data and variables involved
2. Ask the user about the business goals and analysis parameters
3. Create a mock layout to get a high-level sense of what data the dashboard will require
4. Define the dimensions and filters
MS-Excel Tools Used for Creating Dashboard
A good working knowledge of the tools and functions mentioned below can help one create appealing dashboards.
• Sparklines – click below
• Pivot Tables – click below
• Charts – click below
• Data Validation – click below
• Lookup Functions – click below
To view more videos on Data Visualization, MS-Excel, Analytics topics, subscribe to IvyProSchool – YouTube Channel
To know how Ivy can help you to start your career in Data Visualization and Analytics, visit Ivy’s Analytics Home Page