What is Caboodle? - Answer- A data warehouse, designed to store Epic and non-Epic data in a unified data model for efficient reporting
Caboodle staging
... [Show More] database - Answer- Data is transformed, checked for referential integrity, and cleaned
Caboodle reporting database - Answer- Comes from the staging database and is used by caboodle report writers to write reports
SSIS Packages - Answer- SQL Server Integration Services. The mechanism used to move data during the caboodle ETL process
True or false: your organization can create custom SSIS packages to extract Clarity data or additional data sets - Answer- True
Schema - Answer- A collection of database objects
dbo schema - Answer- Stores reporting data and acts as the data source for SlicerDicer
FullAccess Schema - Answer- Everything for report writers from the dbo schema and more
FilteredAccess Schema - Answer- Similar to FullAccess, but results are filtered based on user security
Which schema should be the default schema for reporting? - Answer- FullAccess
How to see what schema is being used for reports? - Answer- SELECT SCHEMA_NAME()
Which Cogito tools query from Caboodle? - Answer- Mainly SlicerDicer, but also certain custom Radar metrics and Workbench templates
True or false: all tables and columns in Caboodle are written in PascalCase - Answer- True
True or false: all key columns in Caboodle are surrogate keys - Answer- True
Surrogate key - Answer- The column's value does not exist in the source database and is created during the ETL process. This is necessary because Caboodle contains both Epic and non-Epic data
Lookup column - Answer- A column in one table whose value identifies at least one row in another table. Most tables in Caboodle have at least one
Compared to Fact tables, Dimension tables usually contain.. - Answer- More data and fewer lookup columns
True or false: lookup columns end in -Key - Answer- True
Where to look for identifying information for validation in Caboodle? - Answer- EpicId or EpicCsn columns
DMC - Answer- Data Model Component. Consists of the table, the packages used to populate the table, and underlying metadata tables that assist with ETL
Dimension tables - Answer- One row for each entity within the set. Examples are ProviderDim, PatientDim
Fact tables - Answer- One row for each occurrence of some significant, measurable event. Examples are MedicationOrderFact and EncounterFact
Bridge tables - Answer- For many to many relationships
DataMart - Answer- Report on data points from several DMCs in one place
What does it mean when a DMC name ends with X.? - Answer- It's custom made
What are some of the pros of Caboodle being a dimensional data model? - Answer- Intuitive, quicker to write a report, quicker run times due to fewer tables and joins
What is the downside of Caboodle being a dimensional data model? - Answer- More complicated ETL process to m [Show Less]