Gunjan's BI Projects

Click any project to explore the full details

Power BI + SQL
Power BIT-SQLInsurance

Insurance Claims Analytics Dashboard

Multi-page Power BI dashboard on 300K+ claims. Tracks claim frequency, SLA breaches and adjuster performance with drill-through capabilities.

↓ 22%Processing Time
$1.8MCost Identified
View Details →
Base SAS + SQL
Base SASSAS EGPredictive

Policy Renewal Prediction & Retention Analysis

SAS logistic regression predicts policy lapse risk 60 days before renewal. Trained on 5 relational tables with Power BI results view.

↑ 9.4%Retention
87%Model AUC
View Details →
Power Automate + SSIS
Power AutomateSSISSQL Server

Automated KPI Reporting Pipeline

Replaced 12 hrs of manual Excel reporting. SSIS ETL loads data nightly; Power Automate triggers PDF report distribution via email.

12 hrsSaved Weekly
0Manual Errors
View Details →
T-SQL + SAS + Power BI
T-SQLSAS FASTCLUSMarketing

Customer Segmentation & Marketing Analytics

RFM scoring on 500K policyholders with SAS k-means clustering into 6 segments. Power BI tracks campaign ROI per segment.

↑ 31%Response Rate
6Segments
View Details →
Base SAS + SSIS
Base SAST-SQLFraud Analytics

Insurance Fraud Detection Analytics

18-rule SAS scoring engine flags suspicious claims before payment. SSIS nightly batch feeds a Power BI SIU alert dashboard.

₹2.4 CrFraud Prevented
↓ 41%False Positives
View Details →
SAS EG + Power BI
SAS EGGLMPower BI RLS

Premium Pricing Sophistication Dashboard

PROC GENMOD GLM models 12 rating variables. Power BI with RLS compares actual vs expected loss ratios for underwriters.

↑ 6.2%Loss Ratio Improvement
12Rating Variables
View Details →