The utility company responsible for providing clean, safe water to the Greater London region, Thames Water has only a GPB 400 million annual budget to maintain and upgrade an infrastructure which in some locations is more than 100 years old. To decide how best to allocate its resources, the utility needed to integrate a wide variety of data into a single data warehouse supporting a complex decision support system.

Challenges

  • Extract data from multiple heterogeneous databases and flat files
  • Transform data into a common format for loading into a data warehouse
  • Enable end users to cross-reference data from every aspect of operations
Historically, asset management relied on a mixture of maps, people's knowledge and a host of independent legacy systems. Some were paper maintenance records going back 40 or more years, others were in Excel documents, others were in databases. We needed a system that could pull together all that information and present it in a way to help inform our decision-making and ensure we set the right priorities.
— Jim Weir
Business Support Programme Manager
Thames Water

Results

  • Delivered continuous access to all data across all departments
  • Improved decision-making by facilitating fast, accurate reporting
  • Saved significant time and money in development process

Technologies Used

  • Accesses, integrates, and delivers any and all data quickly and cost-effectively, without hand coding.