Data warehouse for on-premise management and reporting ERV European Insurance Company
ERV Evropská pojišťovna is the largest travel insurance company in the Czech Republic. Every year, it insures more than 1.6 million clients and cooperates with approximately 79 thousand contractual medical facilities worldwide. Data Mind helped ERV Evropská pojišťovna build a central data warehouse that unified data from internal systems and created a reliable basis for management reporting and analytics.
Data Science
We discover hidden patterns and connections in your data for better customer understanding, process optimization, and future development prediction.
Process optimizations
Sjednocení a integrace dat z různých zdrojů, automatizace, zrychlení zpracování dat...
Data Engineering
We build reliable and scalable infrastructure for data management that ensures data integrity, availability, and efficient processing.
Reporting and Power BI
We transform complex data into clear dashboards and interactive reports for quick and informed decisions.
Web analytics
We measure and analyze the behavior of visitors to your websites and applications for better performance, conversion, and user experience.
Key results
15 dashboards
for the main areas of company management
hundreds of GB of data
integrated from internal systems
first reports within 2 months
from the availability of source data
ready for integration of other agendas
spread across the company
A single source of truth as the foundation for decision-making
Operations → Management → Strategic Management
Project Context
ERV needed to create a central data warehouse that would serve as a single source of truth for reporting and analytics.
Support for:
- Planning and Controlling (KPIs, Budget, Forecasting)
- business and partnerships
- Operations and resolving client issues
- Internal and regulatory reporting
Key Challenges
The project had to address several key areas:
Integration of data from complex systems
The data had to be consolidated from multiple internal sources.
Consistent Definitions of Metrics
There was a need to harmonize KPIs across the organization.
Data Auditability
The system had to ensure data consistency and traceability.
100% on-premises operation
Due to regulatory requirements.
Does your company really have consistent data for decision-making?
We can help you build a data warehouse that will standardize reporting across your entire organization.
Solution
Data Mind designed a data warehouse built entirely on the Microsoft stack.
The project progressed from designing the data model through implementing data flows to the rapid delivery of the first reports. The platform was designed to allow for the gradual expansion of additional analytical capabilities.
Result
Fifteen comprehensive dashboards were created for key areas of the company’s management.
Today, the data warehouse processes hundreds of gigabytes of data and provides a solid foundation for analytics and the further development of the data platform.
Technologies Used
- Microsoft SQL Server
- SQL Server Integration Services (SSIS)
- SQL Server Reporting Services (SSRS)
The entire solution runs entirely on-premises within the Microsoft ecosystem.
Benefits
The new data model provided internal users with a unified foundation for working with data and enabled them to create ad-hoc reports and analyses without relying on operational system vendors.
The data is now validated, consistent, and ready for audits and regulatory requirements. As a result, reporting is fast, stable, and easily scalable, allowing it to grow alongside the needs of the entire organization.
Does your company lack a unified data source?
We can help you consolidate data from various systems into a reliable platform for reporting, analysis, and corporate management.
Want to go deeper? Dive into our knowledgebase
Customer 360
Creating a unified Customer 360 profile is not just a marketing goal, but a complex architectural challenge. This article analyzes the necessary transition to Data Lakehouse architecture in the Microsoft Fabric and Azure ecosystem. Learn how to build a modern data platform that serves as a robust foundation for advanced cloud analytics and hyper-personalized communications using AI and LLM.
RAG over company data
Want to deploy generative AI on top of your company's own know-how without the risk of hallucinations? This technical deep dive into RAG architecture shows that AI success stands and falls with quality data engineering and data architecture. Explore how to build a modern data platform for AI based on Microsoft Fabric and Azure Data Lakehouse and how to overcome the challenges of data vectorization, security, and transition to a production enterprise environment.
Propensity to Buy
How can raw data be transformed into accurate predictions of purchasing behavior? The Propensity to Buy model represents the gold standard of data monetization, but its success stands or falls on the chosen architecture. In this article, we will explore the technical background of implementation in Microsoft Fabric and Azure environments. Learn how to leverage Data Lakehouse principles, advanced machine learning, and generative AI to identify customers with the highest potential—and how to orchestrate it all in a modern, scalable infrastructure.