College of American Pathologists
CAP Committees & Leadership CAP Calendar of Events Estore CAP Media Center CAP Foundation
About CAP    Career Center    Contact Us      
Search: Search
  [Advanced Search]  
CAP Home CAP Advocacy CAP Reference Resources and Publications CAP Education Programs CAP Accreditation and Laboratory Improvement CAP Members
CAP Home > CAP Reference Resources and Publications > CAP TODAY > CAP TODAY 2008 Archive > Using dimensional modeling to create a laboratory data warehouse
Printable Version

  Using dimensional modeling to create a
  laboratory data warehouse


CAP Today




July 2008

Facts—What is it that we want to be able to slice and dice? These are our facts (measures):
  • Average glucose
  • Number of glucose measurements
  • Average minutes to upload
  • Average number of measures per day/patient
  • Number of patients
  • Length of stay
Attributes—What are the ways in which we want to be able to slice and dice our facts? These are our attributes:
  • Patient location
  • Discharge diagnosis
  • Race
  • Nursing shift
  • Patient age
  • Year…month…day
  • Mortality
  • Patient service
  • Length of stay
  • Results
Dimensions—Attributes are grouped naturally into what become dimensions
  • Collection date
       year, month, day, weekday, holiday
  • Patient
        MRN, age, sex, race
  • Location
        room, unit, floor, wing, building
  • Admission
        LOS, mortality, diagnoses, cost
 © 2014 College of American Pathologists. All rights reserved. | Terms and Conditions | CAP ConnectFollow Us on FacebookFollow Us on LinkedInFollow Us on TwitterFollow Us on YouTubeFollow Us on FlickrSubscribe to a CAP RSS Feed