Becoming a data-driven company with Microsoft Fabric

Arrow to the right

How can data silos be reduced? 

Arrow to the right

How is an analytics platform built with Microsoft Fabric? 

Arrow to the right

How is growth and innovation driven by the use of AI? 

The company
Industrial companies
Technologies
Microsoft Fabric, Microsoft Azure, Microsoft Power BI
The challenge
Optimization of analysis workflows and elimination of data silos.
Result
Introduction of a unified analytics platform and improvement of AI capability through Fabric.
Read the case study now
Blinkist logo

Customer Data Platform

Arrow to the right

How can data from different touchpoints be merged in a meaningful way?

Arrow to the right

What is necessary to be able to interpret the behavior of customers?

Arrow to the right

Which technical components are essential for customer journey analytics?

The company
Blinkist, an app with over 20 million users worldwide that distills the key insights of the best nonfiction books into concise text and audio summaries.
Technologies
Fivetran, Snowflake & dbt Labs
The challenge
Outdated data architecture for error-free processing and analysis of complex data.
Result
Modernized tech stack and development of a customer data analytics platform.

Case study on modern analytics solution for intelligent data sharing


Technologies and customer needs are constantly changing. Therefore, modern analytics tools are needed to drive innovation and develop new digital products.

Our client from the industrial sector has recognized the value of analytics. Together, we were able to improve the analytics processes so that their teams can access information more easily and make customer-oriented decisions.

Due to an extensive data history, the company has data that is up to 200 years old. Despite good management, a lot of information remains unused. Using this data efficiently and eliminating data silos was crucial. The aim was to make better decisions and accelerate innovation.

Technical Implementation of the Medallion Architecture
Transformations using low-code/no code & optionally code (PySpark + SQL)
Industry / Sector
  • Industrial companies
The challenge
  • Optimization of analysis workflows
  • Elimination of data silos
  • Exchange of information between different teams
  • Improvement of AI capability & creation of a basis for (optional) streaming evaluation
Solutions through taod
  • Development of a modern, robust and high-performance medallion architecture
  • Data Vault 2.0 in Silver Layer and dimensional model in Gold Layer
  • Further development of the Data Analytics Platform
Result
Improving data sharing by merging and eliminating data silos and developing new data products.

Step by step to a high-performance data analytics platform with Microsoft Fabric

A data analytics platform is crucial for companies. It helps with digital transformation. It enables companies to make faster decisions and work more efficiently. Microsoft Fabric uses technologies and methods to process data. With the medallion architecture in Fabric, data can be easily sorted and analyzed. This allows different teams to make better use of the data.

Use Case Workshop

Together with the customer, we discuss the company's goals and problems and set priorities. Concrete use cases emerge during brainstorming. We check these for costs, benefits and feasibility. Important goals are the improvement of analytics processes, easy access to information and the use of AI.

Development of a modern, robust and high-performance medallion architecture

The Medallion architecture of Microsoft Fabric offers efficient and scalable data processing with three layers: Bronze, Silver and Gold.
The Bronze Layer collects and stores raw data unchanged.
The Silver Layer cleanses, transforms and enriches this data. Thanks to Data Vault 2.0, data changes can be tracked and easily restored.
The Gold Layer optimizes the processed data for analysis and reporting, making queries fast and efficient.

Use of state-of-the-art data models

Data Vault 2.0 in the Silver Layer offers many advantages. It adapts easily to new requirements and data sources. It stores data and changes clearly and comprehensibly. Many data processing steps are automated. This makes work faster and more reliable. These features make Data Vault 2.0 a powerful solution for data processing.

Use of various components of Microsoft Fabric

Microsoft Fabric offers many tools for data analysis. These include OneLake, a central data store, and traditional data warehouse functions. Another tool is Lakehouse, which combines Data Lake and Data Warehouse. Interactive workspaces, also known as notebooks, use Apache (Py)Spark for data processing. Power BI displays data in reports and dashboards.

Further development of the Data Analytics Platform

The above-mentioned technologies and approaches are constantly improving the Data Analytics Platform. This enables the company to react quickly to new data requirements. Microsoft Fabric increases the efficiency of data analysis. Decisions are based on current and accurate data. As Fabric is accessible from any location, it promotes collaboration between users and enables more efficient access to data. The new platform can be expanded without additional infrastructure and adapts quickly to growing data requirements.

More on the topic of AI & Business Intelligence

BI & Data Analytics Consulting taod Consulting
Service

BI & Data Analytics Consulting

BI strategy, tool selection or modern dashboards. We advise you and implement

For advice
Case Study

Automated sales controlling

Development of an automated reporting landscape for hundreds of employees

Read now
Tableau vs. Power BI Whitepaper
Whitepaper

Azure OpenAI and ChatGPT

The functions of Azure OpenAI and how to tailor the GPT models to your use cases

Read now
Your contact to us

Do you have a similar use case or questions about our case? Just write to us!

Sabrina Tonnicchi
Sales Consultant
Stay up to date with our monthly newsletter. All new white papers, blog articles and information included.
Subscribe to our newsletter
Company headquarters Cologne

taod Consulting GmbH
Oskar-Jäger-Str. 173, K4
50825 Cologne‍‍‍
Hamburg location

taod Consulting GmbH
Alter Wall 32
20457 Hamburg‍‍‍‍
Stuttgart location

taod Consulting GmbH
Schelmenwasenstraße 37
70567 Stuttgart