An analytics and data warehousing infrastructure and services system that uses an analytic rather than a transactional data model. The system preferably has at least one extracted source data store, at least one staging data store, and at least one analytic data store. The at least one staging data store preferably has at least one staging data table. The at least one analytic data store preferably has at least one analytic data table for storing transformed data. A staging data table loading algorithm may be used for populating the at least one staging data table with source data. A data transformation algorithm may be used for moving and transforming data from a staging data table into an analytic data store. Other algorithms that may be used in the present invention include algorithms for creating derived variables, creating event proxies, and restructuring data. In one preferred embodiment, the system is a data model based on a clinical rather than a financial understanding of healthcare.