Dynamic Business Dashboards using Excel

1
Welcome to the course!
- A message from the instructor
  FREE PREVIEW
- Download Presentation File
- Download Workshop Files
2
Visualization best practices
- Key Attributes of a Dashboard
- Data Table Layouts
- Dashboard Design Principles
  FREE PREVIEW
- Define the Purpose of the Dashboard and Dashboard Types
- Choose Relevant KPI's
3
Excel charting principles and advice
- Choose the Right Chart
  FREE PREVIEW
- Define Layout and Prioritize
- Understanding Excel Chart Elements
- Chart Types and Best Practices
4
Charting tools and techniques
- Line chart
- Two Data Sets
- Area Chart
- Logarithmic Scale
- Column Chart Part 1
- Column Chart Part 2 - Highlight Top Column Dynamically
- Bar Chart
- Combo Chart using Secondary Axis
- Pie Chart
- Doughnut Chart
- Progress Doughnut
- In-cell Charts Sparkline
- Top and Bottom Ranking
- Grade Distribution
- Target vs Actual vs Variance Chart
- Median Chart
- Bullet Chart
- Scatter
- Bubble
- Bubble
- Waterfall Chart
- Treemap
- Sunburst
- Histogram
- Pareto
5
Create the dashboard
- Part 1 - Introduction
- Part 2 - Create Pivot Reports
- Part 3 - Continue with Pivot Reports
- Part 4 - Create Pivot Charts
- Part 5 - Create the Dashboard
- Part 6 - Add Slicers and Make it Dynamic
6
Assessment
- Final Exam
7
Congratulations....
- Course Evaluation تقييم الدورة
- Congratulations