Data Analytics Guide

Ready to try your skills? Choose any (or all!) of the 3 scenarios to practice.

• Each scenario includes: • An overview of the scenario • A business problem statement • A small data set (embedded Excel file) • Recommended analysis • Your tasks: • Read the scenario • Analyze the data using some of the factors you have learned in these courses (Excel) • Create recommendations for next steps for this sample organisation – consider using the principles from Data Storytelling (Module 6) to document your recommendations • Go deeper: • Find a colleague in your site, region, or BU and see how they approached the problem • Compare and contrast approaches and recommendations • Draw conclusions on how to apply these learnings to your work

Scenario: Training Impact on Productivity • Your manufacturing site recently implemented a new training program aimed at improving employee productivity. You want to assess whether the training has had a measurable impact.

Scenario: Staffing

Scenario: Workforce Age and Retention • Your HR team is investigating how workforce age affects turnover and retention. This dataset includes employee age, tenure, and reasons for termination. Analyze trends across age groups

Efficiency at a Manufacturing Site • Your manufacturing

site operates across three departments — Assembly, Packaging, and Welding — with two shifts per day: Morning and Evening. Recently, you have noticed fluctuations in staffing levels that may be affecting production efficiency and employee morale. leadership wants to understand how closely actual

to identify retention challenges and recommend strategies.

• The site

staffing aligns with planned staffing and

whether certain departments or shifts consistently experience

overstaffing or understaffing.

Data File

Data File

Data File

Data File

Data File

Data File

1

Data Analytics Learning Guide