Queensland Rail
UTelco defined and scoped an Integrated Enterprise Data Warehouse (EDW) solution based on the Queensland Rail (QR) Enterprise Model, used as the basis in defining the Data Warehousing Strategy. The Proof of Concept project is the first milestone identified in the Data Warehousing Roadmap. Its primary objective is to prove that the proposed Data Warehousing technologies and tools work successfully end-to-end in the QR environment. The secondary objective of the Proof of Concept project is to demonstrate the business benefits of an integrated EDW. The Proof of Concept project involved eight (8) functional areas of the business and consisted of fifty (50) business entity types. This project enabled QR to answer complex questions regarding Consignment Orders, Consignments, Consignment Charges, Consignment Invoicing and Consignment Payments across four (4) disparate source systems. These questions could not be answered from the existing three (3) data warehousing systems that had been in operation since 1996.
Customer Value
- Aligned Business and IT with fully accepted Roadmap and Approach for Enterprise Data Warehousing – at QR Board level
- 10% revenue leakage recognised 1 week after implementation of first project
Solution Foundation
- OneSolution rl-EM
- OneSolution rl-LDM
- OneSolution Methodology
- Enterprise Data Warehousing
Back to Success Stories