USF Health Data USF Health Data WarehouseWarehouse

AIMS Council

May 11, 2006

Why a Data Warehouse?

• The successful Implementation of AIMS Pay for Performance Plan and Mission-Based Management Budgeting, requires quick, accurate, and timely data.

• To increase effectiveness of the Business Office accounting centralization, requires accurate and integrated financial data.

• To comply with Board of Trustees quarterly budget request requires the ability to forecast and project financial data.

• LCME Financial Questionnaire requires integrated financial data.

• The list of data requirements are endless…..

Successful AIMS Implementation requires Data:

• To align Resources and Effort, we need to compile data.

• To apply Metrics, we need to compile data.

• To make Decision and Policy, we need to compile data.

The Birth of HARTThe Birth of HART

• Health

• Analysis

• Reporting

• Tracking

AIMSAIMS

FoundationFinancial data

IFISSpace

FAIRFaculty Activity

CMEFinancial data

UMSA/USFPGFinancial/Payroll data

Clinical/USFPGRVU

Billing and Collections

USF Data WarehouseFinancial/Payroll data

Banner/MD BannerCourse data

USF Res. FoundationFinancial data

HART

HART ROI ( Return on Investment)

• The college benefits are: better delivery of information that can be trusted and quickly delivered to support positive business/operation activities. (i.e. - obtain contracts & grants, retain students, faculty & staff, conserve resources…)

• Provide historical perspective to determine whether current data points are outliers or indicative of a trend;

• Permit deeper analysis and what-if investigations, which are not possible in our current source systems; and

• Unify all relevant data and thereby establish a single version of the truth. This requires the integration of our internal, external and third-party data in order to establish a comprehensive view of our operations.

HARTHART Project Status Report

• Business requirements- documented• Project Scope- determined• Data Sources- identified• Software and Hardware- evaluated,

approved and purchased• Software- delivered• Hardware deliver within 2 weeks• Official engagement - Initial meeting

with consultants June 5th

Business Intelligence Vendors EvaluatedBusiness Intelligence Vendors Evaluated

• Cognos

• Information Builders

• Micro Strategy

• Business Objects

Business Objects- Scorecard

– Measures performance vs. goals.

– Tracks organization performance at a glance.

– Provides tools that IDs trends and root causes of performance issues

– Alerts stakeholders when goals are not being met.

Business Objects- Dashboard

• Collection of visual analysis techniques that help us analyze current organization conditions, trends or anomalies at a glance.

• Track critical organization measures.

• Personalized Dashboard to monitor operations at any level.

Business Objects BI 8 Demo

Consultant

decision first technologies

Levi Sales, Senior Account Manager