Cloud-based Analytics and Data Management

Big Data and Modern Data Warehouse in Microsoft Azure Highly scalable data storage in Azure Data Lake Relational Data in Azure SQL Database / Data Warehouse Data Streaming from events and IoT hubs Data Integration and Movement with Azure Data Factory and Databricks Real-time Event Processing with Azure Stream Analytics Online Ad-hoc Analysis and Dashboarding / Visualising in Power BI Data Science with Azure Machine Learning User data management with Azure Web Apps

Data Warehousing based on Microsoft BI Stacks Relational data storage with Microsoft SQL Server Data integration with Integration Services OLAP and Tabular Mode with Analysis Services Online Ad-hoc Analysis and Visualisation in Power BI Traditional reporting with Power BI Report Server User data management with Master Data Services Job management with SQL Server Agent

Data Warehousing based on Open Source Technology Pentaho Data Integration Relational data storage with PostgreSQL Multidimensional data storage with Mondrian Data analysis and dashboarding with Pentaho Business Analytics Advanced Dashboarding with CTools

Business Intelligence Solutions

Home / Our services / Business Intelligence

In this era of Big Data and self-service Business Intelligence, there is an increasing demand for business intelligence solutions to be used as company-wide KPI and performance systems. A well-planned BI landscape integrates these new developments, leveraging their particular benefits – such as low-cost storage and agile rapid prototyping – and combining them with quality-assured, intuitive standard reporting. Skills like data warehouse design, intelligent data extraction and preparing data for transfer to analytical databases, reporting and dashboards are needed more than ever.

We specialise in specific BI requirements, including the modelling of highly complex cubes, the integration of heterogeneous data sources, the implementation of mobile dashboards, and data warehouse tuning. As a long-term Microsoft partner, we also have a great deal of experience with this technology stack.

BI Tech Stack

Big Data and Modern Data Warehouse in Microsoft Azure

Highly scalable data storage in Azure Data Lake
Relational Data in Azure SQL Database / Data Warehouse
Data Streaming from events and IoT hubs
Data Integration and Movement with Azure Data Factory and Databricks
Real-time Event Processing with Azure Stream Analytics
Online Ad-hoc Analysis and Dashboarding / Visualising in Power BI
Data Science with Azure Machine Learning
User data management with Azure Web Apps

Data Warehousing based on Microsoft BI Stacks

Relational data storage with Microsoft SQL Server
Data integration with Integration Services
OLAP and Tabular Mode with Analysis Services
Online Ad-hoc Analysis and Visualisation in Power BI
Traditional reporting with Power BI Report Server
User data management with Master Data Services
Job management with SQL Server Agent

Data Warehousing based on Open Source Technology

- Pentaho Data Integration
- Relational data storage with PostgreSQL
- Multidimensional data storage with Mondrian
- Data analysis and dashboarding with Pentaho Business Analytics
- Advanced Dashboarding with CTools

Case Studies

Business Intelligence

dmTech: Creation of a hybrid BI architecture with Big Data components

The IT subsidiary of dm, the chain of cosmetics and healthcare stores with the biggest sales in Germany, has more than 800 employees focused on digitalising the company’s retail operation.
The emphasis is on the development of innovative solutions: for the online shop and customer and employee apps as well as for the IT infrastructure in the dm stores, distribution centres and headquarters. With a number of innovations, a key role is played by the efficient handling and analysis of large amounts of data in order to produce added benefits from the combination of data sources (Big Data).

READ CASE STUDY

TimoCom: Agile Data Warehousing using BIML and Microsoft SQL Server

The core business of TimoCom Soft- und Hardware GmbH consists of various IT-based services in the transport and logistics sector. As the company’s existing BI solution was no longer able to reliably fulfil these requirements, inovex GmbH and Axians GmbH helped to analyse the current situation, design a new system architecture, and plan and implement the migration of the company’s data warehouse.

READ CASE STUDY

Get in touch!