📊 Data Analytics Mastery Course

Master techniques for collecting, analyzing, and interpreting data to drive informed business decisions and strategic insights.

📚 Total Modules

20

🎯 Skill Levels

All Levels

🌎 Coverage

USA & Canada

⏱️ Total Duration

~20 Hours

⚙️ Module 10: Operational Analytics & Performance

This module covers essential data analytics concepts and practical applications.

Intermediate Level
⏱️ 45-60 minutes

📚 Topics Covered

  • ✓ Supply Chain & Inventory Analytics
  • ✓ Production & Manufacturing Metrics
  • ✓ Quality Control & Defect Analysis
  • ✓ Workforce Productivity Analytics
  • ✓ Process Optimization & Bottleneck Detection
  • ✓ Resource Utilization & Capacity Planning
  • ✓ Operational Efficiency Ratios
  • ✓ Real-Time Operations Monitoring

🔑 Key Concepts

  • • Measuring and improving operational efficiency
  • • Optimizing inventory and supply chain performance
  • • Identifying and eliminating bottlenecks
  • • Using data to increase productivity
  • • Real-time monitoring for operational excellence

10.1 Supply Chain & Inventory Analytics

Effective inventory management balances customer service with working capital efficiency.

Key Inventory Metrics:

Metric Formula What It Tells You Target
Inventory Turnover COGS / Avg Inventory How fast inventory sells 6-12x/year
Days Sales of Inventory 365 / Turnover Days to sell inventory 30-60 days
Stockout Rate Stockouts / Total Orders Customer service level <2%
Carrying Cost Storage + Insurance + Obsolescence Cost to hold inventory 20-30% of value
Fill Rate Orders Filled / Total Orders Order fulfillment success >95%

Simulation: Inventory Analytics Dashboard

┌─────────────────────────────────────────────┐
│ Inventory Performance - March 2025 │
├─────────────────────────────────────────────┤
│ │
│ INVENTORY HEALTH: │
│ Current Inventory Value: $1,245,000 │
│ Avg Inventory (Q1): $1,180,000 │
│ COGS (Q1): $3,540,000 │
│ │
│ Turnover Ratio: 3.0x (Target: 4-6x) 🟡 │
│ Days Inventory: 122 days (Target: 60) 🔴 │
│ Fill Rate: 96.8% (Target: >95%) 🟢 │
│ Stockout Rate: 1.2% (Target: <2%) 🟢 │
│ │
│ TOP SLOW-MOVING ITEMS: │
│ SKU-4521 180 days $45,000 ⚠️ Review │
│ SKU-7823 165 days $32,000 ⚠️ Discount │
│ SKU-2109 145 days $28,000 ⚠️ Clearance │
│ │
│ ACTIONS RECOMMENDED: │
│ • Reduce slow-moving inventory by 40% │
│ • Increase turnover target to 4.5x │
│ • Free up $105K in working capital │
│ │
│ [Details] [Set Alerts] [Export] │
└─────────────────────────────────────────────┘
Retail Example (USA):
A Denver sporting goods retailer analyzed inventory by season. Discovered winter gear sitting for 240+ days post-season. Implemented end-of-season clearance strategy (40% off after 60 days). Result: Inventory turnover increased from 3.2x to 5.8x, freed $340K cash, reduced storage costs by $65K/year.

10.2 Production & Manufacturing Metrics

Manufacturing analytics optimize production efficiency and throughput.

Critical Manufacturing KPIs:

  • Overall Equipment Effectiveness (OEE) = Availability × Performance × Quality
    World-class target: 85% or higher
  • Cycle Time = Time to complete one unit/batch
    Lower is better, measure by product line
  • Throughput = Units produced per time period
    Maximize without sacrificing quality
  • Capacity Utilization = Actual Output / Maximum Capacity × 100%
    Target: 80-90% (allows flexibility)
  • First Pass Yield = Good Units / Total Units (first run, no rework)
    Target: >95% for most manufacturing

OEE Calculation Example:

Manufacturing Shift Data:
Planned Production Time: 480 minutes (8-hour shift)
Downtime (breakdowns, changeovers): 45 minutes
Ideal Cycle Time: 2 minutes per unit
Actual Units Produced: 200 units
Defective Units: 8 units

OEE Components:

1. Availability = (Planned Time - Downtime) / Planned Time
= (480 - 45) / 480 = 435 / 480 = 90.6%

2. Performance = (Ideal Cycle Time × Units) / Operating Time
= (2 × 200) / 435 = 400 / 435 = 92.0%

3. Quality = Good Units / Total Units
= (200 - 8) / 200 = 192 / 200 = 96.0%

OEE = 90.6% × 92.0% × 96.0% = 80.0%
Status: Good, but below world-class (85%)

Simulation: Production Monitoring Dashboard

┌─────────────────────────────────────────────┐
│ Real-Time Production Monitor │
│ Line 3 - Widget Assembly | Shift: Day 1 │
├─────────────────────────────────────────────┤
│ │
│ Current Status: 🟢 RUNNING │
│ Target: 240 units | Actual: 187 (77%) │
│ Time Remaining: 127 minutes │
│ │
│ OEE SCORECARD: │
│ Availability: 88.2% 🟡 (Target: 90%) │
│ Performance: 91.5% 🟢 (Target: 90%) │
│ Quality: 97.3% 🟢 (Target: 95%) │
│ ──────────────────────────────── │
│ Overall OEE: 78.8% 🔴 (Target: 85%) │
│ │
│ DOWNTIME TODAY: │
│ Machine Setup: 18 min │
│ Unplanned Stop: 22 min ⚠️ │
│ Material Wait: 15 min ⚠️ │
│ │
│ ALERTS: │
│ • Investigate unplanned stoppage (11:42am) │
│ • Material delivery delayed - Line 3 │
│ │
│ [Alert Team] [View Trends] [Shift Report] │
└─────────────────────────────────────────────┘

10.3 Quality Control & Defect Analysis

Quality metrics prevent defects from reaching customers and identify improvement opportunities.

Quality Metrics:

Metric Calculation Target
Defect Rate Defects / Total Units × 100% <1-2%
First Pass Yield Good Units (no rework) / Total >95%
Customer Returns Returns / Units Sold × 100% <2%
Scrap Rate Scrapped Units / Total × 100% <3%
Cost of Quality Prevention + Appraisal + Failure Costs <10% of sales

Pareto Analysis for Defects:

80/20 Rule Applied to Quality:
Identify the vital few defects causing most problems.

Example - March 2025 Defect Data:
Total Defects: 450

Defect Type Analysis:
1. Misalignment: 180 (40%) ← Focus here
2. Scratches: 135 (30%) ← Focus here
3. Wrong color: 68 (15%)
4. Missing parts: 45 (10%)
5. Other: 22 (5%)

Insight: Top 2 defects = 70% of all defects
Action: Fix misalignment and scratch issues → eliminate 315 defects (70% reduction)
Manufacturing Example (Canada):
An Ontario electronics manufacturer used Pareto analysis on defects. Discovered 65% of defects came from one supplier's components. Worked with supplier on quality improvement (Six Sigma process). Result: Defect rate dropped from 4.2% to 0.8%, saving $280K annually in rework and warranty costs.

10.4 Workforce Productivity Analytics

Measure and optimize employee performance and efficiency.

Workforce Productivity Metrics:

  • Revenue per Employee = Total Revenue / Number of Employees
    Benchmark: $100K-$200K per employee (varies by industry)
  • Labor Productivity = Units Produced / Labor Hours
    Track trends over time, set improvement targets
  • Labor Cost Percentage = Labor Costs / Revenue × 100%
    Service: 30-40% | Manufacturing: 15-25% | Tech: 20-30%
  • Utilization Rate = Billable Hours / Total Hours × 100%
    Consulting/Professional Services target: 75-85%
  • Overtime Percentage = Overtime Hours / Total Hours × 100%
    High overtime (>10%) may signal staffing issues

Productivity Analysis Example:

Customer Service Team Performance:

Team Size: 25 agents
Total Calls Handled: 15,000 (March)
Total Hours Worked: 4,000 hours
Average Handle Time: 12 minutes
First Call Resolution: 78%

Productivity Metrics:
Calls per Agent per Day: 15,000 / 25 / 22 days = 27.3 calls
Calls per Hour: 15,000 / 4,000 = 3.75 calls/hour

Benchmark Comparison:
Industry Standard: 5-6 calls/hour for similar complexity
Gap: Team is 25-37% below benchmark

Root Cause Analysis:
• Average handle time 12 min vs industry 8-10 min
• First call resolution 78% vs target 85%
• Inefficient CRM system (agents report delays)

Action Plan:
1. Additional training on common issues
2. Upgrade CRM system (faster lookups)
3. Create knowledge base for quick reference
Expected improvement: 4.8 calls/hour (+28%)

10.5 Process Optimization & Bottleneck Detection

Identify and eliminate constraints that limit overall throughput.

Theory of Constraints (TOC):

  1. Identify the Constraint - Find the bottleneck limiting output
  2. Exploit the Constraint - Get maximum output from bottleneck
  3. Subordinate Everything - Align other processes to bottleneck
  4. Elevate the Constraint - Add capacity if needed
  5. Repeat - Find next constraint, continuous improvement

Bottleneck Detection Example:

Manufacturing Process Flow:

Step 1: Cutting - Capacity: 500 units/day
Step 2: Assembly - Capacity: 350 units/day ⚠️ BOTTLENECK
Step 3: Testing - Capacity: 450 units/day
Step 4: Packaging - Capacity: 600 units/day

Analysis:
• Assembly limits entire line to 350 units/day
• Cutting, Testing, Packaging have excess capacity
• System utilization capped at 70% (350/500)

Solutions Evaluated:
Option A: Add second assembly station - Cost: $150K, Output: +300 units/day
Option B: Automate assembly - Cost: $400K, Output: +250 units/day
Option C: Outsource overflow - Cost: $8/unit, Output: unlimited

Decision: Option A - Best ROI, payback in 8 months

Simulation: Process Flow Analyzer

┌─────────────────────────────────────────────┐
│ Process Flow Analysis │
├─────────────────────────────────────────────┤
│ │
│ Order Fulfillment Process: │
│ │
│ ┌────────────┐ Avg: 15 min │
│ │ Order │ Capacity: 32/hr │
│ │ Entry │ Utilization: 68% │
│ └─────┬──────┘ │
│ ↓ │
│ ┌────────────┐ Avg: 45 min ⚠️ │
│ │ Pick & │ Capacity: 10/hr │
│ │ Pack │ Utilization: 95% 🔴 │
│ └─────┬──────┘ ← BOTTLENECK │
│ ↓ │
│ ┌────────────┐ Avg: 8 min │
│ │ Quality │ Capacity: 45/hr │
│ │ Check │ Utilization: 22% │
│ └─────┬──────┘ │
│ ↓ │
│ ┌────────────┐ Avg: 5 min │
│ │ Shipping │ Capacity: 60/hr │
│ │ Label │ Utilization: 17% │
│ └────────────┘ │
│ │
│ System Throughput: 10 orders/hour │
│ Limited by: Pick & Pack │
│ │
│ RECOMMENDATION: Add 2nd picker/packer │
│ Expected Improvement: 10 → 16 orders/hr │
│ │
│ [Simulate Change] [Export] [Set Alert] │
└─────────────────────────────────────────────┘

10.6 Resource Utilization & Capacity Planning

Optimize asset utilization while maintaining flexibility for demand fluctuations.

Capacity Planning Metrics:

Metric Formula Optimal Range
Capacity Utilization Actual Output / Max Output × 100% 80-90%
Asset Turnover Revenue / Total Assets Industry dependent
Machine Uptime Operating Time / Available Time >90%
Demand Forecast Accuracy 1 - (|Forecast - Actual| / Actual) >85%
Capacity Utilization Sweet Spot:

Too Low (<70%): Wasting resources, high fixed cost per unit
Optimal (80-90%): Efficient with buffer for demand spikes
Too High (>95%): No flexibility, quality suffers, stressed workforce

10.7 Operational Dashboards for Real-Time Monitoring

Real-time operational dashboards enable immediate action on issues.

Dashboard Design for Operations:

  • Real-Time Updates - Auto-refresh every 30-60 seconds
  • Exception Highlighting - Red/yellow alerts for issues
  • Trend Indicators - Show direction (↑↓) and rate of change
  • Drill-Down Capability - Click for detailed root cause
  • Mobile Accessible - Managers can monitor remotely

Simulation: Operations Control Center

┌─────────────────────────────────────────────┐
│ Operations Command Center │
│ Last Updated: 14:23:15 (Auto-refresh: 60s) │
├─────────────────────────────────────────────┤
│ │
│ PRODUCTION STATUS: │
│ Line 1: 🟢 Running 92% capacity │
│ Line 2: 🟢 Running 88% capacity │
│ Line 3: 🔴 Stopped Maintenance (45 min) │
│ Line 4: 🟡 Reduced Material shortage │
│ │
│ TODAY'S PERFORMANCE: │
│ Target: 2,400 units │
│ Actual: 1,847 units (77%) │
│ On Track: 🟡 Behind by 23% │
│ │
│ QUALITY: │
│ Defect Rate: 1.2% 🟢 (Target: <2%) │
│ First Pass: 96.8% 🟢 (Target: >95%) │
│ │
│ ALERTS (3): │
│ 🔴 Line 3 unplanned downtime │
│ 🟡 Material ETA delayed 30 minutes │
│ 🟡 Overtime projected for Shift 2 │
│ │
│ [Acknowledge] [Escalate] [Shift Report] │
└─────────────────────────────────────────────┘

✓ Module 10 Complete

You've learned:

  • Inventory analytics and optimization (turnover, stockout, fill rate)
  • Manufacturing metrics (OEE, cycle time, throughput, capacity utilization)
  • Quality control metrics and Pareto analysis for defects
  • Workforce productivity measurement and improvement
  • Process optimization and bottleneck detection using Theory of Constraints
  • Resource utilization and capacity planning strategies
  • Real-time operational monitoring dashboards
  • Operational efficiency ratios and benchmarks
  • Real-world examples from retail, manufacturing, and service industries

Next: Module 11 covers HR analytics and workforce optimization.

← Back to All Modules Next Module →