Dynamic Dashboard Designingusing Office Applications
Duration:
8 days of Extensive Hands-on Training – 32 hours
(Fast track: 4 days)
Investment:
PCKP 3000
Objective: This Module will train participants to Create and Design Interactive Dashboards making them proficient to display information in a graphical format. This enables the management to have a quick summary of data to plot trends, quickly identify performance issues and study the root causes behind an irregularity.
Target Audience:
- This course is aimed for Participants who are already using Excel on a regular basis and have a good Knowledge of Advanced Excel Functions and Formulae’s. Basic knowledge of creating PowerPoint Presentations is also a must
- Participants should have high interest levels towards understanding data-sets and framing dashboards.
Course Outline:
Dashboard – The Design
Methods to Choose the right metrics, Answering questions of how, why and for whom,Framing the Dashboard, Designing the Structure and Flow of a Dashboard, Relationships, Grouping and Drilldowns
Presentation of Right Information
Ways to present information, organizing the Landing Page, Grids, Colors and Fonts, Methods to use the right Chart Type, Charting properties, Tips and Tricks for advanced visualizations
Presentation of Information
Ways to present information, organizing the Landing Page, Grids, Colors and Fonts, Methods to use the right Chart Type, Charting properties, Tips and Tricks for advanced visualizations
Data Massaging
Tips to manage and arrange data using Advanced Excel functionalities, Pivots, Filters, Validations, Lookups and what-if analysis
Making it User Friendly and Dynamic
Learning basics of VBA, Project Explorer Window, Variables and Data Types, Logical Operators, Loops, Functions and Procedures, Form Controls and Active-x Objects – Properties, Actions and Uses
Troubleshooting
Dealing with Errors, Syntax Errors, Macro Code Compilation, Debugging, Standard Errors, Ways to Resolve Bugs
PowerPoint Designs
Customizing the Presentation looks, Aligning Contents & Graphs on Slides, Action buttons, Auto Updating data from other sources, slide master and transition, Slide Show settings and options
Database Management Tool
Using MS Access as a database tool, Linking/Creating Tables, Creating and using different types of Queries, Forms, Macros, Joins and Unions.
Talking with Other Applications
Application Objects, Connection Objects, Creating Pivots from different Data Sources, ADO DB Connections, passing Dynamic Queries, parameters and more…