Introduction to Dashboards and Data Analysis
Introduction to Dashboards, Data Analysis and Reports with Excel;
Using Pivot Tables to summarize and aggregate data;
Creating Interactive reports with Slicers;
Using Key Metrics and Key Performance Indicators;
Creating an Interactive Sales Dashboard.
Creating time dimensions;
Creating trend reports;
Creating trend graphs and trend lines;
Interactive trend dashboard.
Column and Bar Charts;
Types of Column and Bar Graphs (Clustered, Stacked Column, 100% Column).
Filtering Data and Asking Questions of your Data;
Top 10 / Bottom 10 Analysis.
Calculating Percentages in reports;
Creating Pie Graphs and Displaying percentage contributions.
Grouping and Buckets;
Histogram and Charts.
Create an Interactive Human Resource Dashboard
Review the Case Study;
Create a mock-up of a Human Resource Dashboard;
Create and present the Human Resource Dashboard.
Variance Analysis and Year to Date Calculations
Difference from Calculations and Percentages;
Calculating the Difference from the Previous Month;
Calculating the Percentage of – Benchmark Calculations;
Calculating Year to Date.
Conditional Formatting and Visual Analysis
Sparklines and Trends;
Highlighting data according to rules;
Top 10 / Bottom 10 Highlighting of data;
Data Bars and Color Scales Visualisations;
Visualisation of Icons;
Creating a Financial Dashboard.