IO Group has developed a Data Warehouse (DW) Lite solution that is serving as a data-factory to structure data for multiple purposes. The DW Lite is, like any other IO solutions, backend system agnostic and is Cloud solution based on Azure (ADF – Azure Data Factory).
The DW Lite solution is our Datafactory to allow us to load in already existing client business data by using logic for required Extract, Transfer and Load Data (ETL) logic per client to structure and standardize data. Same structural data approach is used for all clients, though there is a complete data segregation per client.
The DW Lite solution serves multiple client purposes such as the basis for a Power BI Solution / management reporting, AI initiatives and / or any other Data analysis purposes. The data in the DW Lite solution can be updated on ad hoc requests, with scheduled Delta loads or Full data loads, all dependent on Client demands.
General approach for loading client data into the DW Lite solution:
- Data extract directly from your back-end system
- ETL process:
- Remove GDPR data (identification number,
- name, and address etc.)
- Structure data for purpose
- Create relations
- Product specific data can be used
- Datatypes being added
- Calculation logic being added
- To create calculated data
- Combination data
- Earned calculation
Examples of projects and news related to this area
Power BI / SMART reporting – a Management and decision proposition Our client requested an enhanced and more efficient way forward to get a business overview. Our SMART reporting / Management and Decision proposition is based upon a DW lite cloud-based solution to...