About DATA MANAGEMENT
Analytical work would not be possible without data that is reliable and organized. Data Management includes data warehouses and data preparation to join, structure and clean data.
Data Warehouses
A data warehouse is a central repository of integrated data from one or many sources and is the link between the underlying data and the BI application being used to perform analyses and create reports. A well-structured data warehouse is essential for carrying out analyses and producing reports with short lead times.
A data warehouse can accumulate information from several source systems, link it together, perform calculations, clean data and assure the quality in a structured way before it is consumed in a BI solution, for example.
In our experience there are two ways of setting up a proper data warehouse. Both have advantages depending on the individual situation and circumstances:
- Build from scratch – Advectas has extensive experience of building data warehouses from scratch. We use the most common methods in this field, such as Kimball and Inmon. We are also at the forefront when it comes to new methods such as Data Vault and BIML for automated scripting.
- Use a pre-built solution – Advectas DWF (Advectas Data Warehouse Framework) is a preconfigured data warehouse automation application that is ready to install for ERP systems such as IFS, Infor, Microsoft Dynamics Ax and Iptor. Advectas DWF is based on our extensive data warehouse experience which has resulted in a data warehouse automation tool including metadata and predefined star schemas with corresponding ETL processes. Many clients have these common ERP systems and a preconfigured data warehouse solution will save a lot of time and cut the cost of development and quality assurance.
More about Xencian
Data Preparation
As the number of external data sources increases, many enterprises need a seamless way of importing, merging and preparing different kinds of data sources. The field of self-service data preparation has experienced strong growth in recent years. Examples of applications include combining sales data from the ERP system with population statistics per geographical area or scanning weather data to plan retail campaigns. Advectas uses Alteryx for data preparation, one of the leading platforms in the field. After the data is prepared, Alteryx has ready-to-use connections to the most common BI systems for further analysis.
More about Alteryx
