Reader small image

You're reading from  Building Interactive Dashboards in Microsoft 365 Excel

Product typeBook
Published inFeb 2024
PublisherPackt
ISBN-139781803237299
Edition1st Edition
Tools
Right arrow
Author (1)
Michael Olafusi
Michael Olafusi
author image
Michael Olafusi

Michael Olafusi is a 9x Microsoft Most Valuable Professional (MVP) and a business intelligence consultant. He is the lead consultant and founder of MHS Analytics Inc. in Canada and UrBizEdge Limited. He has been consulting for clients across North America, Europe, and Africa on data analysis, business intelligence, and financial modeling for the past 10 years. Outside of his consulting business, he is a member of Rotary and the Southern Cruisers Riding Club (SCRC) Chapter 373. He is a proud member of the Canadian Red Cross friendly calls volunteer team. He is also a faculty member at WorldQuant University, USA.
Read more about Michael Olafusi

Right arrow

Understanding the HR dashboard

The HR department is no longer what it used to be 20 years ago. Now they do more proactive planning than they used to do and are increasingly relying on analytics to ensure that their company is energized with the right people, who are treated correctly and are provided with the right resources.

The list of KPIs that will fill the HR dashboard of one company will usually be very different for another company, as the world of work has changed drastically in the last decade and companies are moving away from the traditional way of managing their staff. And with every new people management strategy comes a bucket list of KPIs to track. Luckily, there are some universally relevant KPIs.

The following is a list of these must-know KPIs by segment:

  • Headcount spread: Company executives want to know the total staff and their spread by regions, departments, and for diversity goals, by race/gender. Showing this as a column or bar chart that can be...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Building Interactive Dashboards in Microsoft 365 Excel
Published in: Feb 2024Publisher: PacktISBN-13: 9781803237299

Author (1)

author image
Michael Olafusi

Michael Olafusi is a 9x Microsoft Most Valuable Professional (MVP) and a business intelligence consultant. He is the lead consultant and founder of MHS Analytics Inc. in Canada and UrBizEdge Limited. He has been consulting for clients across North America, Europe, and Africa on data analysis, business intelligence, and financial modeling for the past 10 years. Outside of his consulting business, he is a member of Rotary and the Southern Cruisers Riding Club (SCRC) Chapter 373. He is a proud member of the Canadian Red Cross friendly calls volunteer team. He is also a faculty member at WorldQuant University, USA.
Read more about Michael Olafusi