Manufacturing Quality Tableau Dashboard

Manufacturing Data Visualization·2026·Synthetic-data dashboard demo·4 min read

Synthetic-data Tableau dashboard for yield trend, defect Pareto, equipment concentration, retest behavior, and corrective-action validation.

Overview

Designed a confidentiality-safe Tableau dashboard demo to show how manufacturing quality signals can be detected, reviewed, and communicated across engineering and quality teams. The project uses synthetic production-style data to simulate a yield excursion, dominant defect-code movement, equipment concentration, retest behavior, and post-corrective-action recovery.

Problem

Manufacturing quality issues are often hidden across scattered test records, equipment-level data, retest behavior, and corrective-action notes. Teams need a fast way to identify whether a yield movement is product-wide, process-specific, equipment-concentrated, or related to false-fail behavior.

Data Used

  • Synthetic daily manufacturing lot records
  • Input, pass, fail, retest, and retest-pass quantities
  • Fake product family, line, station, equipment, lot, and shift dimensions
  • Fake defect codes and defect categories
  • Synthetic abnormal-period and corrective-action markers

Review Scope

  • The project uses synthetic data for portfolio demonstration.
  • No confidential production data, company-specific process details, customer data, supplier information, or proprietary manufacturing logic is included.
  • The Tableau workbook was built manually from the generated CSV and supporting build guide.
  • No Tableau Public link is included yet.

Approach

Generated a synthetic manufacturing dataset and designed Tableau views for yield trend, defect Pareto, equipment concentration, retest behavior, and before/after corrective-action validation. The data story simulates a stable baseline, an abnormal quality period concentrated around a fake line, station, and equipment ID, elevated retest-pass behavior, corrective action, and recovery.

Investigation Focus

  • Quality Overview
  • Yield Trend
  • Defect Pareto
  • Equipment Concentration
  • Retest Behavior
  • Corrective Action Before / After

Key Investigation Choices

Use synthetic manufacturing-style data instead of real production records.

Reasoning:

A portfolio dashboard can show the quality-review workflow without exposing confidential product names, line identifiers, equipment IDs, defect codes, supplier information, or internal process details.

Alternatives considered:
  • Use anonymized real production exports
  • Use generic BI sample data unrelated to manufacturing quality
  • Create a dashboard screenshot without reproducible source data

Build the Tableau story around yield movement, concentration, retest behavior, and action validation.

Reasoning:

These views demonstrate how Tableau can support manufacturing quality review, not just chart creation. They also map directly to practical quality questions: what moved, where it concentrated, whether it may be false-fail related, and whether the action worked.

Alternatives considered:
  • Show only KPI cards
  • Show only a defect Pareto
  • Create a general operations dashboard without corrective-action follow-through

Keep the portfolio page concise and place detailed Tableau steps in a local build guide.

Reasoning:

Recruiters and hiring managers should be able to read the case study quickly, while the detailed Tableau formulas and build sequence remain available as support material.

Alternatives considered:
  • Put the full Tableau build guide on the public case-study page
  • Keep only a local guide and skip portfolio integration
  • Create a fake Tableau Public link before the dashboard is built

Methods & Tools

  • Quality Dashboard
  • Yield Trend Analysis
  • Defect Pareto
  • Equipment Pattern Review
  • Retest Behavior Analysis
  • Tableau

Result & Impact

  • 6 views
    Dashboard workflow
  • 100% synthetic
    Data boundary
  • Baseline to recovery
    Quality story

The dashboard provides a compact quality review workflow: detect abnormal movement, identify top defect contributors, locate concentration patterns, review retest behavior, and validate whether corrective action reduced defect recurrence.

Notes

  • A useful quality dashboard should help teams move from abnormal-signal detection to action validation.
  • Defect Pareto and equipment concentration views are stronger when paired with trend context.
  • Retest behavior helps separate possible false-fail contribution from repeatable product-quality risk.
  • A clear Tableau dashboard can help engineering and quality teams communicate the same manufacturing signal from different angles.

Dashboard Screenshots

Overview dashboard showing manufacturing quality KPIs, yield movement, defect Pareto, equipment concentration, retest behavior, and corrective-action validation.

Overview dashboard for manufacturing quality review, including KPI summary, yield trend, defect Pareto, equipment concentration, retest behavior, and before/after corrective-action validation.

Engineering drill-down dashboard showing filtered manufacturing quality review by equipment, station, line, defect code, review period, and lot-level records.

Engineering drill-down dashboard supporting filtered review by equipment, station, line, defect code, review period, and lot-level records.

Local Support Assets

  • Synthetic data generator: projects/manufacturing-quality-tableau-dashboard/scripts/generate_mock_data.py
  • Generated CSV: projects/manufacturing-quality-tableau-dashboard/data/manufacturing_quality_mock_data.csv
  • Tableau build guide: projects/manufacturing-quality-tableau-dashboard/tableau_build_guide.md
  • Overview dashboard screenshot: projects/manufacturing-quality-tableau-dashboard/assets/screenshots/tableau-dashboard-overview.png
  • Engineering drill-down dashboard screenshot: projects/manufacturing-quality-tableau-dashboard/assets/screenshots/tableau-dashboard-drilldown.png
All projects