Introduction
This training on Dashboard Modeling for HR Professionals will address features of Microsoft Excel to turn the data in a meaningful way.
To consolidate and analysis personnel talent, you will have an overall picture of your company personnel talent and know-how to plan with your spending next year. This training focuses on HR-related Dashboard and Report usage.
We live in a world that’s drowning in data. Using this data effectively helps in gaining a competitive advantage. However, it’s no longer sufficient to use a multiple-page spreadsheet to present findings about the data.
Training Course Objectives of Dashboard Modeling for HR Professionals
- Fundamental understanding of data visualization concepts, principles and best practices, and dashboard modeling;
- Basic analytical approach to mine the people data and gain valuable insights;
- Ability to turn plain and uninspiring information into smart, effective visualizations that powerfully convey ideas;
- Hands-on experience in building interactive dashboards e.g. Head Count, Training, Performance Indicators, Individual Records, and a lot more fun; and
- Advance techniques in MS Excel to automate certain tasks, ultimately, saving loads of time. (allowing to go home early)
- Import and model data in Excel
- Create interactive control for a dynamic Dashboard
Dashboard Modeling for HR Professionals Training Course Outlines
Day 1
Introduce Excel Dashboard and Report
- What are Dashboards and Reports?
- Dashboard Design Principles at a Glance
- Tabular Report Techniques
- Table Design Best Practices
- Enhance Report with Custom Number and Conditional Formatting
- Use Symbols to enhance the report
- Build a dashboard with the Camera tool
- Introduce Sparkline
- Customize Sparkline
Day 2
The chart on the Dashboard
- Chart for Trending Techniques
- Top and Bottom Ranking and Emphasizing
- Relationship and Frequency Tracking Histograms
- Variance or Performance Chart
- Bullet Graphs
- Dynamic Labels and Text Formulas
Day 3
Data Model for Dashboard
- Build Data Model
- Data Model Best Practices
- Internal Data Model Overview
- Integrate External Data
- Power Query Overview
Day 4
PivotTable Driven and PowerView Dashboards
- PivotTable Driven Dashboards
- PowerView Dashboard
- Animate Data on Map
Day 5
Interactive Controls
- Introduce Form Controls
- Check Boxes for Toggling chart series on/off
- Option Buttons for showing views on the chart
- Buttons
- List Boxes for controlling multiple charts
- Combo Box for Changing chart data
Credits: 5 credit per day
Course Mode: full-time
Provider: Blackbird Training Centre
