CLR 110 - Clarity Data Model Fundamentals
Key Exam Topics & Coverage:
Chronicles to Clarity Mapping: Identifying data elements
in Chronicles and locating them in Clarity, specifically
using INI and item numbers.
Data Storage & Types: Understanding how data is stored,
including No-Add (record-level), Overtime (contact-level),
Multiple Response, and Category items.
Clarity Compass: Using the Compass tool to find tables
and columns for reporting.
,Database Objects: Distinguishing between different types
of database objects in Clarity.
Reporting Tools: Choosing the correct reporting tool (e.g.,
Crystal Reports, Reporting Workbench) based on user
needs, such as operational (real-time) vs. analytical
(historical) reports.
ETL (Extract, Transform, Load): Basic understanding of how
data moves from Chronicles to Clarity.
Joins and Relationships: Understanding how to join tables
and recognize primary/foreign keys.
,The most important decision of the report writing process
is...
What is the first step in the report writing process?
Which reporting tool can best be used to meet the
reporting need
Analyze request for key features...
-Who needs it
, -What purpose
-How much data should it return
-How up to date does the data need to be
-How does the data need to be formatted
In general, Operational Reports share the following key
characteristics:
1. Time-sensitive
2. Relatively small
3. Easily accessible
* Actionable
Key Exam Topics & Coverage:
Chronicles to Clarity Mapping: Identifying data elements
in Chronicles and locating them in Clarity, specifically
using INI and item numbers.
Data Storage & Types: Understanding how data is stored,
including No-Add (record-level), Overtime (contact-level),
Multiple Response, and Category items.
Clarity Compass: Using the Compass tool to find tables
and columns for reporting.
,Database Objects: Distinguishing between different types
of database objects in Clarity.
Reporting Tools: Choosing the correct reporting tool (e.g.,
Crystal Reports, Reporting Workbench) based on user
needs, such as operational (real-time) vs. analytical
(historical) reports.
ETL (Extract, Transform, Load): Basic understanding of how
data moves from Chronicles to Clarity.
Joins and Relationships: Understanding how to join tables
and recognize primary/foreign keys.
,The most important decision of the report writing process
is...
What is the first step in the report writing process?
Which reporting tool can best be used to meet the
reporting need
Analyze request for key features...
-Who needs it
, -What purpose
-How much data should it return
-How up to date does the data need to be
-How does the data need to be formatted
In general, Operational Reports share the following key
characteristics:
1. Time-sensitive
2. Relatively small
3. Easily accessible
* Actionable
