Analytics Ready Data Sets
Analytics Ready Data Sets are pre-staged tables optimized for reporting and analytics
They are curated based on the needs of different groups or Distributed Analytics Team in UCLA Health: Clinical, Financial, Operational, etc. They provide data elements to support the various needs of these DATs.
- Data elements needed to calculate measures and solve use cases for provider performance, patient access, and clinic throughput
- Data elements needed to report on Quality measures
- Data elements needed to report on eligibility of care, claims, and payments (Professional and Hospital billing)
Users are able to explore these data sets quickly and easier because they have user-friendly column names and simplified data models.
The Office of Health Informatics & Analytics (OHIA) has curated many Analytics Read Data Sets, some of which are described below.
To request access to these Data Sets, please visit the CART page.
These data sets are being enhanced continually. If you have specific enhancement requests, e.g. adding more data elements, please send us a request via the Data Dictionary Dashboard in Collibra. Click on the yellow button to the bottom left shown below.
Foundational Data Marts
The Clinical Data Mart contains Outpatient and Inpatient clinical data of UCLA patient population.
For more information about our Clinical Data Mart, please click this link: Clinical Data MartMart
The Finance Data Mart contains Professional and Hospital Billing data and Managed Care / Tapestry data.
For more information about our Finance Data Mart, that does not include Restricted and Protected Health Information, please click this link: Finance Data Mart (FDM-NRI)
For more information about our Finance Data Mart, that includes Restricted and Protected Health Information, please click this link: Finance Data Mart (FDM-RI)
The Ambulatory Data Mart contains the data elements needed to support measures and use cases for provider performance, patient access, and clinic throughput. This data mart supports reporting on ambulatory operations and complements the existing Clinical and Finance Data Marts.
For more information about our Ambulatory Data Mart, please click this link: Ambulatory Data
Analytics Ready Data Set Office Hours
We host a monthly session to allow our Distributed Analytics Teams (DATs/CoEs) opportunities to ask questions about our data sets/marts. Please feel free to join and forward this invite to other analysts/developers on your team.
Support
For any further questions relating to our Analytics Ready Data Sets, please contact SelfServiceAnalytics@mednet.ucla.edu
OHIA Release Notes: We store our Analytics Ready Data Set release notes in Collibra. You can find all the historical release notes here: OHIA Release Notes.
Collibra Data Dictionary Dashboard Tip Sheet: As part of OHIA’s Self-Service Offering, OHIA provides access to various data sets that we curate. Our Analytics Ready Data Sets are designed to be user-friendly, with descriptive column names and a simple data model. There is a lot of information about these data sets (metadata) available in our Data Dictionaries in Collibra. They can help users find information regarding the data elements, including; descriptions, data type, etc. Please review the Collibra Data Dictionary Dashboard Tip Sheet.
Collibra Office Hours
We host weekly office hours for Collibra. Please join if you have questions about CART, measure documentation, etc.