Data warehouse

• Datamodelling
• Architecture and physical design
• ETL and Data Integration
• Databases

We have consultants with practical experience in working with design, architecture and database models for data warehouse. In this work is included translation of the user demands into existing data, and to work out an information architecture with a data model. The data model can be self-developed or purchased and can later be adapted and filed against the system sources.

All of our collaborators have a great deal of experience in working with data warehouse. Infotrek was one of the first to offer training in SAS9 and has participated in many SAS9-projects. We have profound competence within the areas SAS Data Integration Server (former ETL Server), SAS OLAP Server and a general knowledge of SAS Enterprise Intelligence Platform. Even before SAS9 we were designing, populating and optimizing data storage in data warehouse, either with SAS’s own database alternatives (Base, SPDE and SAS/SPD Server®) or by using other databases such as Oracle and Teradata.