Cloud DWH

More and more companies need an environment where they can consolidate and process data from different sources. The classic on-premise solutions are no longer enough.


The Advantages of Cloud DWH

We created Cloud DWH, which has many advantages, for dynamically growing or data-driven companies.

  • A virtually unlimited selection in both storage size and computing power
  • Lower support requirements
  • High connectivity (MSSQL, Postgre, MySQL, Google Big Query, FTP and more)
  • Complete solutions from ETL to reporting and analysis

Migration to Azure + Azure Synapse


We help with the transition to a modern architecture in the MS Azure environment:

  • Training in individual components of MS Azure and their basic settings
  • Design of a suitable cloud architecture
  • Preparation of end to end BI solutions

Modern Data Pipelines: ADF


We solve the consolidation of data from different data sources in several steps:

  • Centralized logistic for tracking changes in primary sources
  • We use Azure Data Factory where we create transformation processes
  • All data pumps are metadata driven
  • We centralize system logs and create a&nbps;comprehensive monitoring tool

Azure Data Lake


We help with the issue of storing large volumes of data, for example, by moving to Azure Data Lake, which allows us to:

  • Store high volumes of data at minimal cost
  • Always have data available for reading and analysis
  • Data is stored centrally, in any structure
  • Removing barriers between individual systems and departmets

Data Vault business data warehouse modelling


We also implement the design of the data model so that the overall output meets today's standards for the speed and stability of the solution, thus we guarantee among other things:

  • Historization data layer
  • Modularity and easy expandability with new indicators
  • Standardized monitoring and alerting


Tabular modelling


For data visualization, we focus on implementation in Power BI, where we help with

  • Consultation and help with the optimization of the Tabular model on the PBI Backend
  • Modeling Tabular model of your needs
  • Introduction of incremental load to PBI
  • Preparation, design and operation of a complete solution