Download PDF
WESCO Standardizes on WebFOCUS, iWay Create Self-Service Support Environment
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Electronics
Applicable Functions
- Business Operation
- Procurement
Use Cases
- Predictive Maintenance
- Supply Chain Visibility
Services
- Cloud Planning, Design & Implementation Services
- Data Science Services
The Challenge
WESCO International Distribution, a large, geographically dispersed company with 350 warehouses, 6,000 employees, 200,000 products, and more than 130,000 business customers worldwide, faced the challenge of centralizing decision-making and rolling up information in a timely manner. The company's aging information systems were due for an upgrade as they were not user-friendly and required assistance from professional analysts to execute many of the reports. Furthermore, the complex reporting infrastructure required database administrators to follow a tedious process to prepare the data for reporting, which took a significant amount of time. The company needed a Web-based solution that could automatically roll up and distribute reports to users in any format.
About The Customer
WESCO International, Inc. is a worldwide distributor of industrial and construction products. The company has 350 warehouses, 6,000 employees, 200,000 products, and more than 130,000 business customers worldwide. Headquartered in Pittsburgh, Pennsylvania, and with annual sales of $3.7 billion, WESCO distributes industrial and construction products to manufacturers, data communications companies, and electric utilities. The company was an early adopter of data warehousing and decision support technology. However, the company’s aging information systems were due for an upgrade.
The Solution
WESCO chose Information Builders’ WebFOCUS to devise a powerful yet cost-effective standard framework for enterprise-wide business intelligence, analysis, self-service reporting, and making updates to production databases. Information Builders’ Consulting used WebFOCUS and iWay enterprise integration to help WESCO create an enterprise-wide self-service reporting environment, and then duplicated dozens of Pilot Lightship reports in WebFOCUS. They leveraged an existing security architecture created in Microsoft Windows NT to permit or deny access to these new reports based on previously established access requirements. WebFOCUS is installed on a Microsoft Windows NT server and communicates directly with Oracle, Teradata, and SQL Server databases through iWay gateways. WESCO developers appreciate having a mature fourth-generation language underlying the graphical toolset.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Remote Temperature Monitoring of Perishable Goods Saves Money
RMONI was facing temperature monitoring challenges in a cold chain business. A cold chain must be established and maintained to ensure goods have been properly refrigerated during every step of the process, making temperature monitoring a critical business function. Manual registration practice can be very costly, labor intensive and prone to mistakes.
Case Study
Cloud Solution for Energy Management Platform-Schneider Electric
Schneider Electric required a cloud solution for its energy management platform to manage high computational operations, which were essential for catering to client requirements. As the business involves storage and analysis of huge amounts of data, the company also needed a convenient and scalable storage solution to facilitate operations efficiently.
Case Study
Leveraging the IoT to Gain a Competitive Edge in International Competition
Many large manufacturers in and outside Japan are competing for larger market share in the same space, expecting a growing demand for projectors in the areas of entertainment, which requires glamor and strong visual performance as well as digital signage that can attract people’s attention. “It is becoming more and more difficult to differentiate ourselves with stand-alone hardware products,” says Kazuyuki Kitagawa, Director of Service & Support at Panasonic AVC Networks. “In order for Panasonic to grow market share and overall business, it is essential for us to develop solutions that deliver significant added value.” Panasonic believes projection failure and quality deterioration should never happen. This is what and has driven them to make their projectors IoT-enabled. More specifically, Panasonic has developed a system that collects data from projectors, visualizes detailed operational statuses, and predicts issues and address them before failure occurs. Their projectors are embedded with a variety of sensors that measure power supply, voltage, video input/ output signals, intake/exhaust air temperatures, cooling fan operations, and light bulb operating time. These sensors have been used to make the projector more intelligent, automatically suspending operation when the temperature rises excessively, and automatically switching light bulbs. Although this was a great first step, Panasonic projectors were still not equipped with any capability to send the data over a network.