Information Builders Case Studies WebFOCUS Dashboards Give Ainsworth a Decisive Edge Over the Competition

Edit This Case Study Record

	WebFOCUS Dashboards Give Ainsworth a Decisive Edge Over the Competition Information Builders

WebFOCUS Dashboards Give Ainsworth a Decisive Edge Over the Competition

Information Builders

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	More projects are coming in under budget
Impact #2	Invoices get paid more quickly
Impact #3	Sales forecasts are more accurate

Impact #1

More projects are coming in under budget

Impact #2

Invoices get paid more quickly

Impact #3

Sales forecasts are more accurate

Benefit #1	Work-in-progress account has dropped from 90 to 30 days
Benefit #2	Uncollected revenue has dropped significantly
Benefit #3	Customer disputes reduced by over 50 percent

Benefit #1

Work-in-progress account has dropped from 90 to 30 days

Benefit #2

Uncollected revenue has dropped significantly

Benefit #3

Customer disputes reduced by over 50 percent

Download PDF Version

Overview

WebFOCUS Dashboards Give Ainsworth a Decisive Edge Over the Competition

Operational Impact

Quantitative Benefit