Data Warehousing

A data warehouse (DWH or DW) is the central technology for company-wide reporting, data analysis and forecasting.

We introduce data warehousing for large amounts of data and their central storage and uniform analysis in your organization.

  • Relational (3NF), Data Vault modeling and multidimensional modeling (Star Schema)
  • Database development
  • Development of the data warehouse architecture
  • Data integration from various sources
  • Acquisition of legacy data and its transformation
  • Introduction of reporting systems
  • Analysis and forecasting components using methods from data science and data mining

MS SQL Server

For your data warehouse system, we use Microsoft SQL Server as a database and MS Power BI as a platform for business intelligence, and reporting.

We maintain the traditional components such as SSIS, SSAS, SSRS in your existing system and develop them further together with T-SQL programming.

Oracle DB / Cloud

We develop your data warehouse system based on Oracle DB with PL/SQL and the Oracle Business Intelligence Suite and its components for DWH systems and interactive reports in the Oracle Cloud.

For advanced statistical analyses, we develop data mining solutions with Oracle Data Mining and Oracle APEX.

MS Azure / Fabric

We use MS Azure including Azure Data Factory, Azure Data Lake Storage, Azure Databricks for business intelligence.

We create the Unified Dimensional Model for you to provide a single, consolidated business view of relational and multidimensional data, which can include business entities, business logic, calculations, and metrics.

References

We have implemented data warehouse projects for companies, banks, and public administration.

Comelio

“

Data warehouse for the analysis and forecast of tax revenues and tax expenditures

Federal authority, Berlin

“

Integration of banking systems in a DWH for regulatory reports

National bank, Kiel / Hamburg

“

Data warehouse for insurance data

Health Insurance Company, Stuttgart

“

Competitor monitoring system for evaluating technological advantage

Telecommunication, Berlin

“

Data warehouse for risk controlling using Data Vault

Bank, Düsseldorf