To Warehouse or to Mart

I was recently asked about the influence of business intelligence (BI) in schools of medicine (SOMs), what the difference is between a data warehouse and a data mart, and which one of the two is better suited for an SOM.

SOMs have two choices to make in determining the overarching scope of the BI effort:  a full-scale data warehouse or an academic mission- or department-specific data mart (or series of marts). A data warehouse integrates information from multiple information systems. Data marts, however, are specific to one subject area or system – for example, finance, research, or grants management – and are often smaller in size and scope than a warehouse.

Business Intelligence Overview

Continue reading