Information Builders
297 Case Studies
A Information Builders Case Study
Ainsworth, a Toronto‑based heating, ventilation, electrical and mechanical services contractor with 800 employees and over $300M in annual revenue, needed a simpler way for developers and end users to create reports, manipulate ERP data and share timely business information. The company found JD Edwards’ canned reports and limited development tools were too rigid to satisfy growing user demands for real‑time, actionable insight.
Working with Information Builders, Ainsworth built a data warehouse and deployed WebFOCUS dashboards (with Professional Services and training) to integrate data from JD Edwards, SQL and Lotus Notes. The solution delivered real‑time financial, sales, billing and contract dashboards that improved forecasting, sped invoice collections, cut billing disputes by more than half, increased contract renewals by about 30%, and reduced work‑in‑progress aging from 90 to roughly 30 days—uncovering significant revenue and cost‑saving opportunities.
David Lush
Director of IT