Any modern enterprise in general would have a minimum of three essential elements as part of
its IT strategy: A robust ERP system, a data warehouse platform that usually runs on a batch
managed (ETL) process and a BI analysis and reporting tool. Forrester refers to this as the “layer
cake” BI architecture.
One of UXLI’s clients had a similar setup – SAP ERP, BW and Business Objects (BO) and approached us to help decommission and migrate their existing SAP BW & BO systems, to a “modern” data warehouse in cloud.
After an early assessment of the requirements, our proposed solution involved the use of multiple cloud-based technologies architected to work seamlessly while leveraging and recognising the boundaries of the existing technologies.
The customer benefitted from retaining the existing core systems and there was no impact
existing business processes (figure below).
Migration to the new data warehouse was achieved for all the core business processes
finance (FI), Inventory (MM/IM), logistics (SD), procurement (PUR) and plant maintenance
The new data warehouse (figure below) was flexible, scalable and not restrictive. The
able to explore data in different ways. Reporting was possible from multiple
PowerBI and /or BIRST.
Data Lake is an important complement to the modern data warehouse. All the SAP and non-SAP data is extracted into the Data Lake. The data lake also allows the interconnection of data sets to explore and identify early patterns / indications without going through an elaborate development cycle. Early growth allows the storage of structured and unstructured data at any scale and helps improve data/information predicative operations by using alerting algorithms.
AWS Redshift forms the backbone of the data warehouse, providing information to all downstream applications. It is used to govern and manage the data models and acts as a shared meta data library.
A data warehouse becomes truly flexible when it allows the Line of Business (LoB)
users to use the corporate and local Business Intelligence layers seamlessly. The LOB
able to have their own Operational Reporting, Exploration, Text, GIS or simple data
services; thereby reducing the IT dependence.
This flexibility and independence removed the dependence on a single BI toolset. “Bring your own BI tool” became a reality!
Information / Data security remains the top priority. UXLI recommended a “least privilege” approach which means that data is exposed to users only on need basis. The solution used the inherent infrastructure and related services security provided by the cloud platform and the customer was responsible for data content and user security.
The new data warehouse in the cloud was ready for business use within six months from inception.
UXLI’s Agile Business Intelligence approach was applied for the timely delivery of this project. Our Agile BI methodology is focused on creating business value through the early and frequent delivery of working BI solutions.
Energy Supplier Benefits from Fully Integrated Business Intelligence and Planning Solution