- July 28, 2023
Health Insurance Data Analysis and Reporting Using PowerBI
Problem Statement
The Client is from the Health insurance industry, Involved in collecting, storing, and Analyzing huge Amounts of Data Manually. So, the business is looking to Automate the daily, weekly, and monthly data reports The business also wants to build a reporting dashboard using Power BI to get daily transaction insights and develop a business strategy.
Use cases
- Analyzing Hospital level wise Total Policy Information
- Identifying different Surgeries and the amount spent on surgeries
- Gender-wise analysis of health insurance policies
- Location-wise and category-wise policy and amount of information
System Requirements
- Data from Sources
- MS SQL Server
- Power BI
Project Architecture
Our Approach
- Loading CSV file into SQL Server Database
- Created dimension tables using fact table
- SQL Database Connection to Power BI Desktop
- Importing data from SQL Server Database to Power BI Desktop
- Imported Data into Power BI Desktop
- Create a relationship between dimension tables and fact tables in the model view
- Creating reports based on the requirement