The Customer
Westfield Insurance
The Project
Enterprise Reporting Evolution: Tableau to Power BI Migration
Overview
Westfield Insurance (Westfield) is a privately held, U.S.-based property and casualty insurer that was founded in 1848. Headquartered in Westfield Center, Ohio, it is known for its multi-line insurance offerings across personal, commercial, agribusiness, and specialty sectors. Improving has had a deep partnership with Westfield Insurance for 10 years acting as their primary Microsoft technology partner. The initiative focused on migrating their reporting infrastructure from Tableau to Microsoft’s Power BI, leveraging Microsoft Fabric. The project aimed to enhance data management and reporting efficiency. Through a collaborative effort between various offices, including Toronto and Ohio, the team successfully implemented a secure environment and streamlined Westfield’s data processes.
The Business Challenge
Facing escalating licensing costs with Tableau, Westfield opted to transition to Power BI to reduce expenses and streamline analytics across departments by leveraging their existing enterprise investment in Microsoft 365.
Our Solution
Improving approached Westfield Insurance's problem by leveraging our expertise in Microsoft technologies and data management. We implemented a secure virtual network (VNet) from Microsoft Fabric to Power BI, integrating on-prem and cloud services like Netezza and Snowflake. Our team utilized our Code Explorer AI tool to quickly analyze Tableau Prep files, enabling efficient migration and consolidation of reports. We introduced best practices for environment migration, including security persona mapping, workspace and domain mapping, and data model rationalization.
The Business Benefits
The transition to Microsoft Fabric and Power BI unlocked a range of strategic and operational advantages for Westfield Insurance:
Enhanced Security: Established a secure VNet connection between Microsoft Fabric and Power BI, ensuring enterprise-grade data protection.
Improved Efficiency: Leveraged the Code Explorer AI tool to accelerate analysis workflows, reducing turnaround time from weeks to days.
Streamlined Reporting: Consolidated thousands of legacy reports, eliminating redundancy and improving clarity across business units.
Optimized Data Management: Rationalized and unified data models, reducing complexity and increasing reliability.
Cost Savings: Secured approximately $45,000 in Microsoft partner-led funding to support the proof of concept and implementation phases.
Scalable Architecture: Implemented a medallion architecture to support structured, scalable data management aligned with future growth.
User Empowerment: Our team introduced stakeholders to the intuitive user experience and powerful capabilities of Fabric and Power BI, highlighting their potential to enhance productivity and streamline data workflows across the organization.
Technologies and Methodologies Used
A modern data foundation was built using Microsoft technologies and enhancements to existing systems, guided by scalable methodologies:
Microsoft Fabric: Enabled secure networking and centralized data management, forming the backbone of the new reporting.
Power BI: Migrated and consolidated reports from Tableau, providing advanced analytics and an intuitive user experience for stakeholders.
Snowflake: Used as a primary data source; our team influenced structural changes within Snowflake to better support the models built in Fabric.
Code Explorer AI Tool: Accelerated the analysis of Tableau Prep files, significantly reducing manual effort and improving efficiency.
Medallion Architecture: Adopted a structured, scalable approach to data modeling, enhancing reliability and future readiness.
Stakeholder Enablement: Introduced stakeholders to the capabilities and user-friendly interface of Microsoft Fabric and Power BI, demonstrating how the platform could streamline workflows and boost productivity.
Partnerships
Improving leveraged its strong partnership with Microsoft to access partner-led funding, securing financial support for proof of concept and implementation phases. Collaboration between our Toronto and Ohio offices ensured seamless project execution, enhancing our reputation with Westfield Insurance. Microsoft’s support was instrumental in providing cutting-edge technologies and best practices needed for successful project completion.
Lessons Learned
Effective Communication: Seamless collaboration between offices is vital for project success.
Adoption of Best Practices: Introducing best practices can significantly improve data management and reporting efficiencies.
Leverage Technology: Utilizing AI tools like Code Explorer can drastically reduce analysis time.
Client Education: It is important to educate clients on new technologies and methodologies for better adoption.
Scalable Solutions: Developing scalable architectures can support future growth and complexity.
Funding Opportunities: Leveraging partnerships for funding can provide significant cost savings.
Conclusion
The Westfield Insurance Power BI migration project showcases Improving's ability to deliver advanced data management solutions through strategic use of Microsoft technologies. Our collaborative approach, leveraging inter-office expertise and strong partnerships, enabled us to effectively transform Westfield’s reporting infrastructure. The project not only met the immediate needs but also provided scalable solutions to support future growth, reflecting our commitment to excellence and client satisfaction.
