DW Lite

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

Client benefit – IO Power BI / DW Lite solution

Client benefit – IO Power BI / DW Lite solution

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....

read more
IO Group Company Website update

IO Group Company Website update

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...

read more
Power BI – Frie forsikring / IO Group

Power BI – Frie forsikring / IO Group

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...

read more