The client, Aveva, is a global leader in Engineering and Industrial Software that combines the power of operations and asset’s lifecycle management to improve customer profitability, efficiency and maximize return on capital.
The client had multiple discrete data sources, including Siebel and IDB, along with rigid business practices and intricate reporting with complex storage procedures. In order to eliminate existing, costly processes, the client asked us to load and synchronize disparate data sources with respect to data types, length, precision, etc.
The Orion team designed, developed and implemented a complete business intelligence platform, by transforming and migrating the data in the Central Data Repository (‘CDR’) to Azure and provided dependent data in real-time to a Microsoft Power BI-based interactive reporting platform. The CDR consolidated, extracted and managed data provided mainly by the Siebel CRM system and multiple other sources. ETL Packages must load the data from its respective source using increments and the help of timestamps from the source.
Our team built an Enterprise Data Warehouse and collected data using a predefined frequency. The warehouse leveraged historical intelligence and was powered by Business Intelligence and SRRS, ultimately creating better visibility and supporting better decision-making.