課程資料
報名日期
全年招生
課程級別
學習模式
修業期
0 小時 55 分鐘
教學語言
英語
授課導師
Gloria Tibakunirwa
評分
課程簡介
Using raw HR data, learn how to create HR statistics from your employee list and display on a dynamic dashboard
This course is a step by step process of developing a dynamic, interactive HR Dashboard. The uniqueness of this course is that the dashboard you will learn to build is not static BUT dynamic and interactive and on that one dashboard, you can slice and dice your data further to reveal more insights into your raw data. Students will learn how to use inbuilt excel analytical tools like pivot tables, pivot charts and slicers.
課程章節
- 6 個章節
- 15 堂課
- 第 1 章 Introduction
- 第 2 章 Dashboard Fundamentals and Employee list - Dummy data
- 第 3 章 Excel Pivot Tables
- 第 4 章 Excel Pivot charts
- 第 5 章 Creating The Dashboard
- 第 6 章 Course Wrap up
課程內容
- Analyse raw data using pivot tables, pivot charts and slicers to support decision making
- Build interactive dashboards that are not static
- Prepare reports that inform decision making and impact the bottom line
此課程所涵蓋的技能
評價
-
CCandi k
This was good. Except my excel is version 2019 and for some reason, I could not get the grouping to work as shown in your video. Can you provide guidance there? I think the formula and error in the age and years of service column may have caused it? There are lot's of #value prompt so my plan is to delete all of the #value field rows and update the dataset connections. It appeared to be due to a formula error. Can you share an updated dataset? Other than that, the pace and breakdown was great. Thanks!
-
SSyed Raza
it was good but had to make the dashboard myself as in the download materials it was not present, its always good to give a complete set and then later the person who is learning will make new from the source
-
DDennis Navarro
Very nice quick overview of how to implement Dashboards into your reports. Gave me some nice ideas to help my management understand my reports using visual representations of our data. I would recommend for those who have not used dashboards in their reporting.
-
TT. Maccarthy Kpaan
This is very awesome. Exactly what i was looking for concerning HR Dashboarding. Completely simple and easy to understand! This is one of the very best courses I've ever wished for. I enjoyed the simplicity. I am looking forward to more knowledge in creating recruitment dashboard, Learning and Development Dashboard, Peformance Managment and many others. You are a great teacher! Next time, please ensure that the course is clear with out learning having to inform you, please.
