HR Predictive Dashboard Final Assignment
Instructions
You will use the skills th
HR Predictive Dashboard Final Assignment
Instructions
You will use the skills that you have learned in Business Statistics (BUS315) to perform analysis of your data. You will identify key metrics in the data and create KPIs to track those metrics. We will use those KPIs to create dashboards that allow for comparative and other visualizations of the data. This will allow the business unit to perform analysis to predict future outcomes, allowing you to gain valuable insights and make more informed business decisions.
Remember that at this point, your design decisions should be made to facilitate using the data to make decisions regarding hiring, compensation, training, job design, and
other talent management practices. Thus, ensure your KPIs measure data points suitable for predicting churn or employee severance from the organization
Submission criteria
You will create a worksheet in your Excel workbook with visuals based on the requirements above. You will submit the entire workbook file with the dashboard as the first worksheet.
Excel Predictive Dashboard
Your worksheets or dashboard must make strategic use of the following elements:
• At least two pivot tables;
• slicers and/or timelines;
• graphs and charts;
• descriiptive statistics such as (but mot limited to) percentiles, measures of
centrality, and measures of dispersion;
• and at least 2 inferential statistics methodologies learned in this course.
The dashboard should be visually cohesive (common style theme). Please ensure the KPI’s and other data enable prediction of employee turnover or ‘churn’.
Potential key performance indicators for the HR Dataset (see Codebook):
• Termd
• PositionID • DOB
HR Predictive Dashboard Final Assignment
• DateofHire
• DateofTermination
• ManagerID
• EngagementSurvey
• EmpSatisfaction
• SpecialProjectsCount
• LastPerformanceReviewDate • DaysLateLast30
• Absences
Answer These Questions
Submit your answers to the following questions:
• Why are these KPIs key to understanding from where, when, and why employees leave the firm? What specific insight did these KPIs or worksheets provide you?
• How does your dashboard or worksheet(s) exemplify use of at least one predictor variable?