Business Intelligence Project

it_user2226

CIO at a financial services firm with 51-200 employees

10000000 people affected

5 people managed

6 month project

Project Description

Develop a healthcare claims analytic data warehouse with KPI dashboards highlighting claim detail anomalies.

Lessons Learned

Healthcare claim data is extremely corrupt and inconsistent across health plans. Would have spent more time understanding the data source requirements.

Highlights

Ahead of schedule

Under budget

Received recognition / award

Support from colleagues

Difficulties

Management had to be convinced

Dirty Data

Products Used

SQL Server

MicroStrategy

Technical Skills Used

MDM
Data Warehouse Modeling
Data Analytics
Geo Spatial Data
Web Development
KPI Dashboards
ETL Processing
SSIS
SQL Development

Technical Certifications

Microstrategy Certified Developers