Teck Cominco’s trail operations “refined” its reporting and analysis with QlikView
Customer Company Size
Large Corporate
Region
- America
Country
- Canada
Product
- QlikView
- JD Edwards
- Lotus Domino
- Process Data Historian (PDH)
- EtQ System
Tech Stack
- IBM System i (AS/400)
- IBM
- SQL Server
- Access
- Excel
Implementation Scale
- Departmental Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Mining
Applicable Functions
- Human Resources
Use Cases
- Predictive Maintenance
- Process Control & Optimization
- Real-Time Location System (RTLS)
Services
- Software Design & Engineering Services
- System Integration
About The Customer
Teck Cominco Limited is a diversified mining company, headquartered in Vancouver, BC, Canada with revenue totaling approximately $7 billion. The company is a world leader in the production of zinc and metallurgical coal and is also a major producer of copper and gold. Five percent of the Western world’s zinc and 2 percent of its lead are produced by Teck Cominco. The company employs an ERP solution comprised of JD Edwards, Process Data Historian (PDH) and EtQ systems to store its wealth of transactional data. It is imperative that management at Teck Cominco have reliable and timely access to this data to ensure proactive rather than reactive business decisions.
The Challenge
Teck Cominco Limited, a diversified mining company, needed a platform for turning large volumes of transactional data into usable business information. The company's ERP solution met all of management’s data capture requirements, but its cumbersome reporting capabilities proved inhibitive to providing the key performance indicator (KPI) information necessary for quickly recognizing trends and driving improvements. Temporary, Excel-based systems were implemented to deliver KPI data to management. These unsustainable, labor-intensive systems required IT managers to dedicate one day per month to prepare and distribute reports for process capability and maintenance KPI reviews. The reports provided only static views of information with a narrow focus on a single topic from a single subject area. Access to and value of overall information needed to be significantly and quickly improved.
The Solution
Teck Cominco deployed QlikView to roughly 70 employees across 3 functional areas and had its first application up and running in 2 weeks. With QlikView pulling data from JD Edwards, Lotus Domino, Excel and various other sources running on IBM System i (AS/400), Teck Cominco analyzes operations, finance and human resources information – all with a focus on reducing costs and improving overall corporate performance. With QlikView Server, Teck Cominco employees work from a single version of the truth through a common dashboard. Several additional customized applications have since been deployed to track and analyze business data related to health and safety, training compliance, cost control, labor, production, in-process and final product quality and environmental compliance. Additionally, QlikView allows Trail Operations managers to keep a close watch on their key cost drivers and business unit managers are able to quickly assess the performance of their areas.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Underground Mining Safety
The goal was to produce a safety system to monitor and support underground mining operations; existing systems were either too simple (i.e. phone line) or overly complex and expensive, inhibiting deployment, and providing little-to-no support in event of an accident. Given the dangerous nature of the mining work environment and the strict regulations placed on the industry, the solution would have to comply with Mine Safety and Health Administration (MSHA) regulations. Yet the product needed to allow for simple deployment to truly be a groundbreaking solution - increasing miner safety and changing daily operations for the better.
Case Study
Mining Firm Quadruples Production, with Internet of Everything
Dundee Precious Metal’s flagship mine, in Chelopech, Bulgaria, produces a gold, copper, and silver concentrate set a goal to increase production by 30%. Dundee wanted to increase production quality and output without increasing headcount and resources, improve miner safety, and minimize cost.
Case Study
Fastenal Builds the Future of Manufacturing with MachineMetrics
Fastenal's objective was to better understand their machine downtime, utilization, quality issues, and to embrace cutting-edge manufacturing technology/process improvement capabilities to bring their team to the next level. However, there was a lack of real-time data, visualization, and actionable insights made this transition impossible.
Case Study
Joy Mining Systems
Joy equipment faces many challenges. The first is machine integration and control. The business end of the machine has a rapidly-spinning cylinder with 6-inch diamond-studded cutting teeth. It chews through rock at rates measured in tens of tons per minute. The system grinds through the rock in front, creating a rectangular mine tunnel. Hydraulic lifters support the ceiling as the machine moves forward. Automated drills and screws drive 3-ft long screws into the ceiling to stabilize it. The rock and coal fall into a set of gathering "fingers" below the cutting cylinder. These fingers scoop up the rock and coal and deposit it onto a conveyor belt. The conveyor passes under the machine and out the back. A train of conveyor belt cars, up to a mile long, follows the cutter into the mine. The rock shoots along this train at over 400 feet per minute until it empties into rail cars at the end. Current systems place an operator cage next to the cutter. Choking dust (potentially explosive), the risk of collapse and the proximity of metal and rock mayhem make the operator cage a hazardous location.
Case Study
Improved Monitoring in Industrial Manufacturing Facility
When your crane is moving tons of magma-hot iron, you can’t afford an unexpected failure. McWane Ductile knew monitoring the crane motor metrics within their facility could help prevent a mechanical failure that would strand an enormous bucket of molten metal overhead. Unfortunately, their legacy wired monitoring system couldn’t work with moving objects in this extreme environment. If they could integrate wireless capabilities into their existing equipment they could extend their monitoring capabilities without starting over from scratch.
