Company Size
200-1,000
Region
- America
Country
- Canada
Product
- WebFOCUS
- iWay Software
- JD Edwards EnterpriseOne ERP system
Tech Stack
- SQL database
- IBM iSeries server
- Lotus Notes
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Productivity Improvements
- Revenue Growth
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Construction & Infrastructure
- Electronics
Applicable Functions
- Business Operation
- Sales & Marketing
Use Cases
- Predictive Maintenance
- Supply Chain Visibility
Services
- Data Science Services
- System Integration
About The Customer
Ainsworth, Inc. is a heating, ventilation, electrical, and mechanical services contractor serving the industrial, institutional, and commercial marketplaces. The company offers a vast array of services and can coordinate everything from retrofitting buildings to engineering complex equipment installations, including cooling, mechanical, wiring, electrical systems, diesel generators, fire alarm systems, and computer systems. Ainsworth also offers extensive post-sales service and support. The company is headquartered in Toronto with 15 offices across Canada, Ainsworth has 800 employees and annual revenues of over $300 million.
The Challenge
Ainsworth, a heating, ventilation, electrical, and mechanical services contractor, was struggling with the rigidity of canned reports from its JD Edwards ERP system and a lack of flexibility in its development tools. This was not satisfying users’ constant requests for information. The company needed a solution that would make it easier for developers and end users to create reports, manipulate data, and share information in the company’s ERP system. The company wanted to construct a data warehouse using ERP transaction data, and then build user-friendly dashboards that deliver real-time information about the business.
The Solution
Ainsworth decided to implement Information Builders' WebFOCUS business intelligence (BI) platform and integration technologies from iWay Software. The company hired Information Builders Professional Services to design and build a data warehouse, laying a foundation for financial and operational reporting. Ainsworth now has a wide variety of user-friendly dashboards that support real-time decision-making about financials, billing, customers, sales opportunities, contract renewals, work orders, and more. The company uses WebFOCUS in conjunction with a JD Edwards EnterpriseOne enterprise resource planning (ERP) system, including finance, assets, orders, projects, supply-chain planning, and other modules. In the future, Ainsworth plans to use iWay to capture GPS data and display it in Google Maps to optimize the deployment of field technicians.
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
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
IoT System for Tunnel Construction
The Zenitaka Corporation ('Zenitaka') has two major business areas: its architectural business focuses on structures such as government buildings, office buildings, and commercial facilities, while its civil engineering business is targeted at structures such as tunnels, bridges and dams. Within these areas, there presented two issues that have always persisted in regard to the construction of mountain tunnels. These issues are 'improving safety" and "reducing energy consumption". Mountain tunnels construction requires a massive amount of electricity. This is because there are many kinds of electrical equipment being used day and night, including construction machinery, construction lighting, and ventilating fan. Despite this, the amount of power consumption is generally not tightly managed. In many cases, the exact amount of power consumption is only ascertained when the bill from the power company becomes available. Sometimes, corporations install demand-monitoring equipment to help curb the maximum power demanded. However, even in these cases, the devices only allow the total volume of power consumption to be ascertained, or they may issue warnings to prevent the contracted volume of power from being exceeded. In order to tackle the issue of reducing power consumption, it was first necessary to obtain an accurate breakdown of how much power was being used in each particular area. In other words, we needed to be able to visualize the amount of power being consumed. Safety, was also not being managed very rigorously. Even now, tunnel construction sites often use a 'name label' system for managing entry into the work site. Specifically, red labels with white reverse sides that bear the workers' names on both sides are displayed at the tunnel work site entrance. The workers themselves then flip the name label to the appropriate side when entering or exiting from the work site to indicate whether or not they are working inside the tunnel at any given time. If a worker forgets to flip his or her name label when entering or exiting from the tunnel, management cannot be performed effectively. In order to tackle the challenges mentioned above, Zenitaka decided to build a system that could improve the safety of tunnel construction as well as reduce the amount of power consumed. In other words, this new system would facilitate a clear picture of which workers were working in each location at the mountain tunnel construction site, as well as which processes were being carried out at those respective locations at any given time. The system would maintain the safety of all workers while also carefully controlling the electrical equipment to reduce unnecessary power consumption. Having decided on the concept, our next concern was whether there existed any kind of robust hardware that would not break down at the construction work site, that could move freely in response to changes in the working environment, and that could accurately detect workers and vehicles using radio frequency identification (RFID). Given that this system would involve many components that were new to Zenitaka, we decided to enlist the cooperation of E.I.Sol Co., Ltd. ('E.I.Sol') as our joint development partner, as they had provided us with a highly practical proposal.
Case Study
Splunk Partnership Ties Together Big Data & IoT Services
Splunk was faced with the need to meet emerging customer demands for interfacing IoT projects to its suite of services. The company required an IoT partner that would be able to easily and quickly integrate with its Splunk Enterprise platform, rather than allocating development resources and time to building out an IoT interface and application platform.
Case Study
Bridge monitoring in Hamburg Port
Kattwyk Bridge is used for both rail and road transport, and it has played an important role in the Port of Hamburg since 1973. However, the increasing pressure from traffic requires a monitoring solution. The goal of the project is to assess in real-time the bridge's status and dynamic responses to traffic and lift processes.