Qlik Case Studies US Synthetic cuts the scrap with QlikView business analysis

Edit This Case Study Record

	US Synthetic cuts the scrap with QlikView business analysis Qlik

US Synthetic cuts the scrap with QlikView business analysis

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Oil & Gas
Applicable Functions	Human Resources
Use Cases	Predictive Maintenance Real-Time Location System (RTLS)
Services	Data Science Services
Challenge	US Synthetic, a leading provider of polycrystalline diamond cutters (PDCs) for oil and gas exploration, faced challenges in reporting and analysis. The company's Made2Manage ERP system and internally developed custom tables contained large amounts of detailed data, but employees were not able to utilize that data in a meaningful way. Even the generic reports within Made2Manage were difficult to access, and creating ad hoc reports was even more time-consuming and inefficient. The company needed a solution that would provide real, accessible, and useful information at all levels within the organization. The company's non-linear floor made it challenging for managers to follow the product from work order to delivery. Because products may backtrack in the process flow and ultimately take a different route to completion, production managers were losing visibility of those products and their status. Read More
About Customer	US Synthetic is the leading provider of polycrystalline diamond cutters (PDCs) for oil and gas exploration. The company has spent more than a decade perfecting its products to drill faster and last longer – especially in tough conditions that test the limits of the most durable drilling equipment. The company employs over 600 people, and is located in Orem, Utah. US Synthetic is part of Dover Corporation. In 1997, US Synthetic became the industry’s leading supplier of diamond products. Over 10 years later, US Synthetic continues to actively expand this leadership position – not only by developing innovative new diamond solutions, but also by ensuring process efficiency within internal operations. Read More
Solution	US Synthetic deployed QlikView to 50 employees for operational analysis in only one week. Through QlikView, US Synthetic now analyzes yields and production, lead time, customer profitability, and safety rates. With QlikView Server and Publisher, US Synthetic easily supports analysis and visibility while handling the large data volume of millions of records. The company was able to build the first application – a production floor dashboard – in a five-day engagement with a QlikView consultant. The Yields & Production application was an important priority for US Synthetic, as it allowed the company to track and compare yields and problems across days, factories, and shifts. US Synthetic is now able to determine which factories are performing best against standard cost/yield. Product line and floor managers are able to identify trends in product quality and performance and proactively make adjustments at any factory that may be underperforming. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Oil & Gas

Applicable Functions

Human Resources

Use Cases

Predictive Maintenance

Real-Time Location System (RTLS)

Services

Data Science Services

Challenge

US Synthetic, a leading provider of polycrystalline diamond cutters (PDCs) for oil and gas exploration, faced challenges in reporting and analysis. The company's Made2Manage ERP system and internally developed custom tables contained large amounts of detailed data, but employees were not able to utilize that data in a meaningful way. Even the generic reports within Made2Manage were difficult to access, and creating ad hoc reports was even more time-consuming and inefficient. The company needed a solution that would provide real, accessible, and useful information at all levels within the organization. The company's non-linear floor made it challenging for managers to follow the product from work order to delivery. Because products may backtrack in the process flow and ultimately take a different route to completion, production managers were losing visibility of those products and their status.

About Customer

US Synthetic is the leading provider of polycrystalline diamond cutters (PDCs) for oil and gas exploration. The company has spent more than a decade perfecting its products to drill faster and last longer – especially in tough conditions that test the limits of the most durable drilling equipment. The company employs over 600 people, and is located in Orem, Utah. US Synthetic is part of Dover Corporation. In 1997, US Synthetic became the industry’s leading supplier of diamond products. Over 10 years later, US Synthetic continues to actively expand this leadership position – not only by developing innovative new diamond solutions, but also by ensuring process efficiency within internal operations.

Solution

US Synthetic deployed QlikView to 50 employees for operational analysis in only one week. Through QlikView, US Synthetic now analyzes yields and production, lead time, customer profitability, and safety rates. With QlikView Server and Publisher, US Synthetic easily supports analysis and visibility while handling the large data volume of millions of records. The company was able to build the first application – a production floor dashboard – in a five-day engagement with a QlikView consultant. The Yields & Production application was an important priority for US Synthetic, as it allowed the company to track and compare yields and problems across days, factories, and shifts. US Synthetic is now able to determine which factories are performing best against standard cost/yield. Product line and floor managers are able to identify trends in product quality and performance and proactively make adjustments at any factory that may be underperforming.

Impact #1	Significantly lowered scrap rate
Impact #2	Enabled real-time access to yields and production data that once took five days of prep time each month
Impact #3	Empowered end users to perform their own changes and customizations

Impact #1

Significantly lowered scrap rate

Impact #2

Enabled real-time access to yields and production data that once took five days of prep time each month

Impact #3

Empowered end users to perform their own changes and customizations

Benefit #1	Lowered scrap rate significantly
Benefit #2	Saved five days of prep time each month for accessing yields and production data
Benefit #3	Avoided hiring one or two additional employees for data analysis

Benefit #1

Lowered scrap rate significantly

Benefit #2

Saved five days of prep time each month for accessing yields and production data

Benefit #3

Avoided hiring one or two additional employees for data analysis

Download PDF Version

Overview

US Synthetic cuts the scrap with QlikView business analysis

Operational Impact

Quantitative Benefit