Executive Summary
The objective of this project was to successfully migrate Atlas Insurance’s data cubes from on-premises servers to a cloud solution, enhancing scalability, performance, and system connectivity.
This transition was essential for overcoming the limitations of the existing legacy systems, enabling more efficient data management and improved decision-making capabilities.
A key achievement of this project was the significant enhancement in data processing efficiency, with processing times reduced from 12 hours to under 2 hours, representing an impressive 83% reduction.
Client Background
Company Name: Atlas Insurance
Industry: Insurance
Company Size: Over 250 employees
Annual Revenue: Over €120 million in gross insurance revenue
Business Overview
Atlas Insurance is a leading insurance provider in Malta, with over 100 years of experience. Offering a wide range of personal and commercial insurance solutions, Atlas Insurance prioritises customer experience through conveniently located branches and intermediaries, and a 24/7 emergency health helpline.
Over the past years, focusing on customers and people has helped Atlas become one of Malta’s leading insurance group of companies, and indeed it counts its workforce of over 250 people as its biggest resource and asset, truly embodying its promise of being people you can trust.
Atlas is dedicated to continuous innovation and the exploration of new business avenues. Their goal is not merely to adapt to changing market needs but to anticipate and shape these changes, positioning Atlas as a leader in the insurance industry for the foreseeable future. The company is also committed to being at the forefront of environmental, social and governance (ESG) efforts in Malta, embracing a holistic approach throughout the company.
By marrying rich heritage with a progressive outlook, Atlas seeks to broaden its legacy of innovation, offering sophisticated solutions tailored to the dynamic needs of its clientele and partners for years to come.
Challenges
The migration of Atlas Insurance’s legacy data cubes presented several challenges:
- Accelerating Initiatives:
Atlas Insurance had to speed up key initiatives within its Business & Artificial Intelligence (B-AI) team, that required transitioning from an on-premise data cube to a cloud-based solution. This change was very complex and needed additional expertise and resources to ensure a smooth transition. - Extending Team Capabilities:
To effectively manage the migration, it was essential to extend the B-AI team’s capabilities by integrating Eunoia’s expert knowledge. This collaboration provided greater flexibility in resource allocation and access to expertise crucial for tackling complex tasks. - Identifying Improvement Areas:
The organisation required support in prioritising and identifying areas for improvement within its BI processes. Eunoia’s involvement helped pinpoint opportunities for enhancement and implement effective solutions, ensuring the transition aligned with business objectives. - Technology Alignment:
Atlas Insurance was using Microsoft SQL Server Analysis Services and aimed to align with new technologies such as Power BI. Eunoia’s familiarity with both existing and emerging technologies facilitated a seamless integration, meeting the company’s technological and business needs during the migration to a cloud solution.
The Solution: Insurance Data Migration to a Cloud Solution
Eunoia was entrusted with the critical task of executing the insurance data migration to a cloud solution, focusing on three key projects:
Cloud Migration of Data Cubes
Eunoia successfully migrated three data cubes to a cloud solution. This migration not only eliminated the limitations of the on-premises cubes but also enhanced speed, scalability, and connectivity.
Enhanced Performance
The cloud-based Power BI cube significantly improved performance, delivering faster query responses and report generation compared to the legacy system. The migration reduced processing times by 83 % from approximately 12 hours to less than 2 hours for incremental updates.
Seamless Transition
The transition to the cloud solution was executed with minimal disruption. Users only needed to update their connections to the new Power BI cube, which was completely rewritten to enhance functionality while maintaining the same tables and fields for easy integration into existing processes.
Quantitative Results
- Data Processing Efficiency: Reduced processing times from 12 hours to under 2 hours, thus 83% reduction.
- Improved User Performance: Faster query responses and better data accessibility and security without relying on VPNs.
Qualitative Results
- Enhanced Decision-Making: Access to high-quality data has significantly improved the decision-making processes within Atlas Insurance.
- Increased User Confidence: Stakeholders have shown increased confidence in using data, resulting in a culture that values data-driven decisions.
Working with Eunoia has been transformative for our BI processes. They helped us rewrite and migrate our legacy data cubes to a cloud solution, significantly improving scalability and processing times.
-Ian-Edward Stafrace, Chief Strategy Officer, Atlas Insurance
Key Benefits of Insurance Data Migration to a Cloud Solution
- Aligned business and data goals
- Future-proof data architecture
- Enhanced processing times
The successful insurance data migration to a cloud solution has not only resolved performance bottlenecks but has also empowered Atlas Insurance to make faster, data-driven decisions. Eunoia’s collaboration and technical expertise were pivotal in achieving these results, ensuring a smooth transition and improved operational efficiency.