Florida Hospital Centra Care Provider Performance Data Mart

Abstract

Querying a transactional database for aggregates reports can result in poorly responding queries and reports. Developing a data mart is a highly effective solution to overcome these limitations. This paper demonstrates the steps needed to create, load and read a data mart. The provider performance data mart will provide key metrics for measuring how medical staff are abiding by the policies and guidelines of the corporation. The goal of this article is to provide the reader an introduction to the world of business intelligence and analytics. Key Terms - Business Intelligence, Data Mart, Data Modeling, ETL.