Tooling Quality Engineer Dashboard

Overview

In this project, I developed a comprehensive set of 9 Power BI dashboards designed specifically for Tooling Quality Engineers to monitor, analyze, and improve tooling-related processes across manufacturing facilities. The dashboards integrate data from Dataverse and Smartsheets, ensuring seamless access to structured and semi-structured data while enabling real-time reporting and data-driven decision-making.

The solution provides an end-to-end view of tooling activities, from mold builds to inspections and nonconformity tracking. Each dashboard is tailored to meet the needs of quality teams, managers, and operational experts, offering interactive visualizations, drill-down capabilities, and insightful metrics.

Data Sources:

• Dataverse: Used for structured data like mold build times, inspections, and related processes, providing a secure and scalable data storage solution.
• Smartsheets: Integrated for tracking operational counts, inspections, and nonconformity reports, offering flexibility and ease of collaboration.

Dashboard Details:

1. Mold Build Time (Dataverse):

Tracks the time spent on mold builds, helping identify bottlenecks and inefficiencies in the tooling process.

2. Mold Build Count (Smartsheet):

Provides counts of mold builds over time, enabling teams to monitor workload, capacity planning, and production trends.

3. Mold Build (Dataverse + Smartsheet):

Combines data from both systems to give a unified view of mold builds, integrating time tracking with operational counts.

4. Mold Build Inspection (Dataverse):

Monitors inspections related to mold builds, ensuring that quality checks are performed consistently and identifying areas requiring attention.

5. Mold Transfer Inspection (2 Smartsheets):

Consolidates inspection data from multiple sources to provide insights into mold transfers, ensuring traceability and process compliance.

6. Nonconformity Counts (Smartsheet):

Tracks the total nonconformities identified in tooling processes, supporting root cause analysis and corrective actions.

7. Nonconformity Counts by Facility (Smartsheet):

Breaks down nonconformity issues by facility, helping quality teams focus efforts where issues are more prevalent.

8. App Reported Nonconformities (Smartsheet):

Displays nonconformities reported via applications, allowing real-time tracking and faster response times.

9. Nonconformity Report (Smartsheet)

Offers a detailed report of tooling nonconformities, providing insights for audits, continuous improvement, and compliance reporting.

Key Features:

• Interactive Visualizations: Users can explore data through charts, tables, and graphs, making it easier to interpret and act upon insights.
• Real-Time Updates: Automated data refreshes from Dataverse and Smartsheets ensure reports are always current and accurate.
• Cross-Platform Data Integration: By combining structured and collaborative data sources, the solution offers a holistic view of tooling operations.
• User-Friendly Design: Dashboards are designed with intuitive layouts, filters, and drill-through capabilities, ensuring that both technical and non-technical users can navigate and analyze data effectively.

Business Impact:

The Tooling Quality Engineer Dashboard suite has significantly improved the way quality teams monitor tooling processes. Key benefits include:

• Enhanced visibility into mold build performance and inspection compliance.
• Faster identification and resolution of nonconformity issues.
• Better planning and resource allocation through accurate tracking of builds and transfers.
• Streamlined reporting and audit readiness with detailed, real-time dashboards.
• Improved collaboration between teams using Dataverse and Smartsheets as trusted data sources.

This project showcases my ability to design robust, user-focused Power BI solutions that bring together data from multiple platforms, deliver actionable insights, and support quality improvement initiatives in manufacturing environments.

---