Course
Designing Powerful HR Dashboards
Learn how to create powerful dashboards using Power Pivot and Power Query in less time

India Pricing:
₹32,390

Learning Mode:

E-learning

Would you like to create HR or Rewards dashboards that tell a powerful story, are interactive and can be easily updated? Have you spent hours manually calculating medians or percentiles for each employee category? If so, this course is for you, we’ll tackle that and more.

Join International Excel Guru, Dianne Auld, Master Reward Specialist, for this 3-hour Excel course for advanced users to learn how to create powerful dashboards using Power Pivot and Power Query in less time. Attendees will have access to a comprehensive learning video for 120 days post-course including detailed instructions on replicating all the functions demonstrated during the session, so you don’t miss a beat.

During This Course, You Will: 

  • Learn important dashboard design principles.
  • Receive a brief introduction to Power Query, Power Pivot and Macros.
  • See how to create an interactive analysis dashboard using Power Query, Power Pivot, icons, text boxes, elegant, uncluttered color-coded charts, customized slicers to drill down by level, department or location, Power Pivot median measures and three simple macro buttons that allow alternate pay base views of the data.
  • Obtain a starting template, instructions for replication of everything demonstrated, and the completed dashboard.

Who Will Benefit from This Course? 

This course is ideal for HR professionals, compensation specialists or anyone seeking to create a dashboard to help tell a story regarding HR-related metrics.

Become a Member

Members gain exclusive access to research, publications, networking opportunities and more!

Course Requirements

The course requires an advanced knowledge of Excel. Participants should have access to a computer with Excel 2013 or newer. Power Pivot and Power Query are standard from Excel 2016 onward, and they can be added into Excel 2013. The dashboard design principles taught can be used with any version of Excel and can be used with standard employee data and pivot tables. Power Query and Power Pivot are super-efficient tools for transforming data and merging different tables for use in analysis. You should already work with HR, Reward or payroll data in Excel regularly, and be experienced with writing Excel formulas and creating charts.


Related Courses

This learning experience is part of WorldatWork’s suite of Excel mastery courses, which include:



Recertification Credits 

By successfully completing this course you will earn 2 WorldatWork recertification credits.


Policies

View our Return/Cancellation policies and more here.

Get Started With This Course

Contact today to register for this course and take your career to new heights with the latest and expert educational resources.