Dashboard Reporting with Excel
Training Outline: Dashboard is used as the most powerful decision making tool globally. Visualize, Track, Analyze and make the Perfect Decision for your business. The main purpose of a KPI or Business dashboard is to provide a comprehensive snapshot of performance, that enables you to visualize by a large amount of detail without using too many drilldowns. Learning Outcome / Training Outline: Understanding Dashboard Architecture Understand the Business Analytics & KPIs used Globally Learn the most powerful excel formulas / functions for dashboard reporting Learn about Excel BI Tool Use Excel BI for Shaping & Normalizing Data Source Learn Data …
Curriculum
Overview
Training Outline:
Dashboard is used as the most powerful decision making tool globally. Visualize, Track, Analyze and make the Perfect Decision for your business. The main purpose of a KPI or Business dashboard is to provide a comprehensive snapshot of performance, that enables you to visualize by a large amount of detail without using too many drilldowns.
Learning Outcome / Training Outline:
- Understanding Dashboard Architecture
- Understand the Business Analytics & KPIs used Globally
- Learn the most powerful excel formulas / functions for dashboard reporting
- Learn about Excel BI Tool
- Use Excel BI for Shaping & Normalizing Data Source
- Learn Data Viz with Pivot, Charts, Number Format & Conditional Format
- Build Animation in Slicers to Animate Dashboard
- Prepare Animated Dashboard on Real Life Case
- Bonus Tips for Dashboard
Target Audience:
- People who are working with reporting & presentations
Training Deliverables:
- Exercise Files for practice
- Full Video recording of the training
- Certificate of Participation
Pre-requisites to Participate:
- Should have intermediate knowledge about Excel.
- Use Microsoft Office 2016 or higher. Office 365 is best
Training Schedule:
Date: November 1 & 2, 2024.
Time: 7:00 PM