HR Predictive Dashboard Final Assignment$$Instructions

You will use the skills that you have learned in Business Statistics $($BUS$315)$ 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;

$$ descriptive 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 $$ DaysLateLast$30$

$$ 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?$$Also$,$ include discuss your thoughts on the exploratory process in general.$$ How long did you spend exploring your data?

$$ What did you learn about the process?

$$ How many visualizations did you end up having to create before honing in on the best one to represent your project goal?

$$ What surprised you and what did you find difficult?