Drei Männer gucken gemeinsam auf Laptop

Business Intelligence

Business Intelligence/BI is one of inovex’s core competencies. It is also one which, in this age of Digital Transformation and increasingly large data volumes, has not lost its significance – quite the opposite, in fact.

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

Cloud-based Analytics and Data Management

Modern Data Warehouse in Microsoft Azure

  • Highly scalable data storage in Azure Data Lake
  • Relational Data in Azure SQL Database / Data Warehouse (Synapse)
  • Data Streaming from event hub and IoT hub
  • Data Integration and Movement with Azure Data Factory and Databricks
  • Real-time Event Processing with Azure Stream Analytics
  • Online Ad-hoc Analysis, Reporting and Dashboarding in Power BI
  • Data Science with Azure Machine Learning
  • Data Governance with Purview
On-Premise Data Warehousing

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

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

Technology partners

As a fundamentally technologically independent project house, we can design and implement individual end-to-end BI solutions thanks to our extensive experience in the individual architectures and applications.

Amazon Web Services (AWS)

Amazon Web Services (AWS) is a secure platform for cloud services. It is designed to support the growth of your company by providing computing performance, database storage, content delivery and other functions. As an AWS Certified Solutions Achitect Associate, we can draw on a wide range of tools, training courses, and support in order to develop your AWS solutions more efficiently.

databricks

The mission of our partner Databricks is to accelerate innovation for all customers by unifying Data Science, Data Engineering and Business Intelligence in one solution.

Google Cloud

Google Cloud Platform offers a variety of services that enable companies to operate and process their systems and data on a modern, highly scalable and proven infrastructure.

Microsoft

We are a certified Microsoft Partner: Certified Gold Partner for Cloud Platform, Data Platform and Data Analytics, and Certified Silver Partner for Application Development.

Snowflake

Snowflake is a cloud data platform that powers enterprise data workloads. As a partner of Snowflake, we help to make the potential of the Snowflake ecosystem practically usable – in the areas of business intelligence, analytics, machine learning & data engineering and data science.

Get in touch!

Florian Wilhelm

Head of Data Science, Contact for Data Management & Analytics

Blog

Business Intelligence