Advanced BI Solution for Effective Decision-Making
A fast-growing health insurance company that operates in the US market.
- Duration6 months
- Team4 persons
- PlatformsWeb
- TypeInsurance company
- IndustryInsurance
Target audience
Individual and corporate customers who look for end-to-end health insurance coverage
Project idea
The client wished to deploy a comprehensive scalable analytics solution to consolidate data and provide a unified data analysis method with tools that were easy enough for all business users and offered assisted predictive modeling for planning and forecasting. They needed a robust BI and reporting solution with a single interactive dashboard for making faster insurance-related decisions while monitoring organization growth and sharing statistics with the appropriate management groups and partners.
Project challenges
Remodel the existing database architecture for a specific actuarial modeled product.
Develop and engineer BI application with appropriate ETL and security protocols.
Consolidate data and enforce its consistency & quality.
Create a cohesive user experience for the BI dashboard.
Roll out advanced analytics and reporting access to corresponding teams.
Ensure compatibility with current and future data sources.
Solution
ApexTech experts in business intelligence services built an effective data visualization solution and enriched its functionality with third-party integrations for more effective interaction between users. We introduced a complex architecture and specifically built data lakes, allowing them to collect data across focused markets and internal departments for customized reports. We made outputs of data models understandable and consumable with a top-notch interface so that our client could transform its decision making from "gut" to evidence-based.
Business benefits
01
Dramatically increased efficiency
Automated reports with clear and accurate data.
02
Boosted performance
Business users can annotate & bookmark dashboards for better communication between the underwriters and adjusters.
03
Technical efficiency
Excellent documentation, knowledge management, and data security standards.
04
Revenue growth
Insights from the BI application offer actionable intelligence to internal business users, which help translate this into profitable growth.
05
Strategic Edge
Faster decision-making enabled by actionable insights generated from the advanced analytics of real-time data.
06
Control and quality
One-stop-shop ensures control and quality initiatives that start from research & analysis and disseminate downstream in business decisions.
What we did
Phase 1
ApexTech deployed a technically and business-aligned team of professionals to gather requirements across the business and interview target audiences to understand the desired usage and needs of BI app interfaces. Analysis work began with producing detailed process maps and updating the non-functional requirements of the operations.
Phase 2
We calibrated an actuarial model, adopting a data warehouse architecture based on Microsoft SQL Server to facilitate data analysis and knowledge discovery. Specifically, we performed data extraction from multiple source systems: CSV, SQL, Excel, and APIs. After that, data transformation and consolidation into a data warehouse was carried out by our team. We also delivered multi-dimensional analytical cubes that embraced essential business areas identified by the client. We used SQL Server Management Studio and SQL Server Data Tools to develop the required BI solution.
Phase 3
The SQL development delivered for the numerous processes needed subsequent testing through an automation approach adopting several technologies such as Jenkins and SQL server.
Phase 4
The end-user visualization is achieved using Power BI to generate self-servicing reports, while the SQL Server Reporting Services (SSRS) was used to build standard reports. To create a consistent unified design, we built shared vocabularies, established a set of rules for layout, navigation, and filtering, focused each page within each application on presenting a single “story” with a unified structure across different technologies.
Phase 5
Our team also worked to achieve security at the SQL Server Analysis Services level. Our solution will help to avoid creating duplicate reports for different users. Instead, one report is built, and the business users access certain information blocks based on their permissions.
Phase 6
ApexTech provided technical training for administration and onsite training for end-users to improve data literacy and empower them with self-serve analytical tools. Our training program provided the foundation for user adoption for key team members.
Technologies Used
Development
ASP.NET
Database
Microsoft SQL
Visualization
Power BI
Integrations
PayPal
Google Services
Testing tools
Selenium
CI/CD
Jenkins