Advanced BI Solution for Effective Decision-Making
Target audience
Target audience
Individual and corporate customers who look for end-to-end health insurance coverage
Project idea
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
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
Dramatically increased efficiency
Automated reports with clear and accurate data
Boosted performance
Business users can annotate & bookmark dashboards for better communication between the underwriters and adjusters
Technical efficiency
Excellent documentation, knowledge management, and data security standards
Revenue growth
Insights from the BI application offer actionable intelligence to internal business users, which help translate this into profitable growth
Strategic Edge
Faster decision-making enabled by actionable insights generated from the advanced analytics of real-time data
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
Frameworks
Yii2
AngularJS
Database
Microsoft SQL Server
Visualization
Power BI
Integrations
PayPal
Google Services
Testing tools
Selenium
CI/CD
Jenkins
Development
ASP.NET
Database
Microsoft SQL
Visualization
Power BI
Integrations
PayPal
Google Services
Testing tools
Selenium
CI/CD
Jenkins