Module 1: Data-driven HR

• What is data-driven HR?
• The importance of data-driven HR
• Creating intelligent HR workflow
• Distinguishing between different types of data
• Data-driven HR Tools
• Identifying analytical techniques
• Combining analytics to get best results

Module 2: Data-driven HR in action

• Data-driven recruitment
• Boosting employer branding
• Identifying the most effective recruitment channels
• Assessing the best people for your business
• Data-driven employee engagement
• Determining employee satisfaction
• Measuring employee retention
• Data-driven compensation & benefits
• Data-driven learning & development and performance management
• Identifying and closing gaps in learning
• Measuring how L&D impacts on performance
• Intelligently measuring and reviewing employee performance

Module 3: Enhance your Analytical Skills

• Data Analytics Cycle:
  • Spreadsheets tips and shortcuts
  • Structure your unstructured data.
  • What-if analysis.
  • Use advanced Excel formulas to build your database.
  • Analyzing and generating reports of extensive data using pivot tables
  • Creating an active dynamic dashboard using EXCEL.
• Excel (Power Pivot):
  • Introduction to Power Pivot and DAX
  • Create a relation between different tables using a power pivot
• Power Query & Power BI:
  • Introduction to Power Query.
  • Introduction to power-BI.
  • Get data from different data sources.
  • Clean and organize your data using Power BI.
  • Elements needed to calculate HR metrics.
  • Use DAX to measure HR metrics.
• Creating Dashboards:
  • Design operation dashboard.
  • Design recruitment dashboard.
  • Design performance management dashboard.
  • Design employee satisfaction dashboard.
  • Design L&D dashboard.
  • Link all HR functions
  • Communicating and visualizing insights from data