Designing Powerful HR Dashboards - India

India Pricing:

₹32,390

Learning Mode:

Virtual

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.

What You Will Learn:

• Master 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.
  

Additional Information

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. 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.