Data Analysis for Cooling holes:
SQL Database

In part 2, I am accomplishing the same report content with much more additional insight. By building a Database with the same machine, inspection and performance data as before, reporting capabilities grew significantly.

Database Building in SQL

The second part of this project aimed to make the report content more accessible for everyone on the team.

Process Machines

Machine Data

Part Cycle Times

Azure or Power BI

Cooling Holes

Database

Inspection Files

Part Dimensional Data

Part Performance Data

Performance Database

Output To

Report Page

Note: For NDA purposes, all of the data and databases shown in this report and on this page were generated independently. They do not represent any real production data.

This Page is under construction

Sample Dashboard

SQL Samples and data pipelining

Below are some of the query scripts that populates the database . Please note: In accordance with a signed NDA all script samples were created independently for the purposes of this project overview. None of the scripts apply to any existing manufacturing process or data formats.

Table Building and Filling

Primary and Foreign Key Links

Placeholder