Deloitte Virtual Experience – Analytics
Factory downtime analysis and equality assessment using Tableau and Excel

This project was completed as part of the Deloitte Data Analytics Virtual Experience (Forage).
The objective was to analyse operational and workforce data to identify key business issues and present insights in a clear, data-driven manner using Tableau and Excel.

• Identifying factories and machines contributing most to downtime
• Assessing equality and discrimination risks across job roles using structured analysis

• Identify factories with the highest machine downtime
• Determine which machine types contribute most to downtime
• Analyse workforce equality scores and categorise discrimination levels
• Present insights clearly for business and leadership decision-making

• Factory machine downtime data
• Workforce equality score data across job roles and locations

• Factory
• Device Type / Machine Type
• Downtime / Unhealthy status
• Job Role
• Equality Score

1. Data Analysis & Visualisation (Tableau)

• Built bar chart visualisations to analyse downtime per factory
• Analysed downtime by device type to identify high-impact machines
• Combined insights into a single dashboard for clear comparison

2. Equality Analysis (Excel)

• Created a structured table to evaluate equality scores by job role and factory
• Categorised roles into:
  • Fair
  • Unfair
  • Highly Discriminative
• Used rule-based classification to highlight high-risk areas

Downtime Analysis:

• Daikibo Factory Seiko experienced the highest overall downtime
• Laser Welding and Laser Cutting machines contributed the most to downtime
• Downtime is concentrated in specific factories rather than evenly distributed

Dashboard Preview

Equality Analysis:

• Senior and leadership roles showed higher discrimination risk in some factories
• Engineering roles generally fell into Fair categories
• Certain factories require targeted intervention to improve equality outcomes

Dashboard Preview

Equality Analysis Preview

• Enables leadership to prioritise maintenance and operational improvements
• Highlights high-risk factories and machines for downtime reduction
• Supports data-driven diversity and equality initiatives
• Demonstrates how analytics can guide operational and HR decision-making

• Tableau (Dashboard & Visual Analytics)
• Microsoft Excel (Data classification & analysis)

• Tableau Dashboard (.twbx)
• Equality analysis Excel file
• Visual screenshots summarising key findings

This project was completed as part of a virtual experience program for learning and demonstration purposes.
The focus is on analytical thinking, insight generation, and clear communication rather than production deployment.