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 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 maintain
Star schema-ANSWER-Fact table surrounded by and linked to dimensions
Where is the Caboodle data dictionary found?-ANSWER-Analytics catalog
data in a unified data model for efficient reporting
Caboodle staging 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 maintain
Star schema-ANSWER-Fact table surrounded by and linked to dimensions
Where is the Caboodle data dictionary found?-ANSWER-Analytics catalog
