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
IO Group is wishing our clients and partners a Happy New Year. 2022 was a fantastic year, and we are very pleased with our client delivery results and the continued product roadmap outcome. 2022 was a year that covered many successful client deliveries combined with...
Power BI – management reporting FF Forsikring is constantly striving to improve client offering to distinguish in the insurance market and obtain highest customer satisfaction. To support this journey, it is key to have a transparent and updated view of current and...
Some stories are more interesting than others... The below link is for sure one of the more interesting ones. The post is released by a client expressing in positive words their satisfaction and benefit from using the Power BI / DW Lite solution delivered by IO Group....
We have now launched an updated version of our Website. The main domain is now www.iogroup.ai, though we can still be reached on www.iogroup.dk. The main objective is to improve communication of our strategic journey, including our offerings. A News feed tab has been...
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...
Et par fantastiske, produktive dage i det fynske er nu vel overstået hos Frie. Godt gået Frie – jeres ihærdige indsats har resulteret i effektive og agile data-overviews som I helt sikker får gavn af fremadrettet. Tak Frie, som altid en fornøjelse at arbejde sammen...
Frie Forsikring og IO Group i DW Lite / Power Bi samarbejde ! IO DW Lite / Power Bi er en af vores løsninger som giver vores kunder et stærkt og yderst informativt værktøj til at skabe et aktuelt billede af virksomhedens forretning. Vi er stolte af at Frie Forsikring...