Most Boring Jeopardy ever!

Yikes!

100

What happens if a component is not enabled?

User can not view the information

200

What will happen if a dashboard is not marked as ready to use

Nobody can see your dashboard from the Analytics Catalog until you select both the Ready for use and Enabled for user selection checkboxes – 2-20

300

Name 4 Types of components available in Radar

• Graph, Link, Message Board, Native HTM,L Report Listing, Table, Tranche ﴾This type is not currently used)

400

Differentiate between database administrators for Chronicles, Clarity, and Caboodle

• Database administrators sometimes oversee operation of more than one database
• The Chronicles Administrator oversees the daily functioning and troubleshooting of Chronicles, as well as updates to the system. The Chronicles Administrator is most often referred to as the ODBA ﴾Operational Database Administrator﴿, or the Cache DBA. Reasons to contact the Chronicles Administrator include: Workbench reports are displaying queuing errors Workbench reports are running slowly or not running
• The Clarity Administrator oversees and troubleshoots nightly and ad‐hoc Clarity ETL executions that move data from Chronicles to Clarity. Because of this, they are sometimes called the Clarity ETL Administrator. They might also be called the ETL Administrator ﴾without mention of Clarity﴿, particularly if they oversee both Clarity and Caboodle ETL. The Clarity Administrator is also responsible for managing Epic‐released updates to Clarity and any custom Clarity tables or columns an organization decides to create. Reasons to contact the Clarity Administrator include:
•  A Clarity report looking at the last year's data isn't displaying anything for the most recent two monthsMeeting to decide which new Epic‐released views and derived tables should be enabled during an upgrade

500

• Assign a security class to a user
• Modify a security class
• Assign action groups to a user
• Change security settings for a single user
• Change security settings for a group of users
• Configure a template

• Use Chart Search to open the Template Manager activity. 8. Find the following templates on the Configuration tab of the Template Manager. Use the information you find there to determine whether or not your clinician will be able to find each of the templates in their Analytics Catalog. Close the Template Manager and navigate to the Analytics Catalog. 10. Find the following reports in the Analytics Catalog. Click the pencil icon for each of these reports and navigate to the General tab of the Report Settings window to determine whether or not your clinician would be able to find each of these reports in their Analytics Catalog.

SlicerDicer

100

What is SlicerDicer for? (Name 3 of 5)

• Self-service reporting tool,
• Large data sets
• Small data sets
• Visualizing data
• Customizable

200

What is Slicer Dicer not used for? (ex. it is not used for making crack)

• Does not look at data entered today

300

• What are sequential criteria?

• Add sequential criteria, which returns records where one criterion precedes another
• Using sequential criteria, you could find all patients with a knee replacement followed by a physical therapy encounter, or find all office visits followed by an ED encounter

400

What is required for SlicerDicer to use customer data?

• If your developers extract custom data to Caboodle, then SlicerDicer can access that data. That means SlicerDicer can use custom Caboodle tables built off of Epic data as well as non‐Epic data from payroll, questionnaires, external claims or any other data source

500

How do Cogito Data Models work?

no idea..this ones all you

Can you do it?

100

• Find a Chronicle INI and Item number using Record Viewer

• Chart search
• Record viewer
• INI is the first field that you type in what subject you’re looking for

200

User Chronicles shorthand to differentiate between a record ID and an Item number

In Epic shorthand, an item may be referenced as "I EPT 110" ﴾"I" stands for "item," "EPT" is the master file, and "110" is the item number﴿. A record may be referenced as "R SER 21800" ﴾"R" stands for "record," "SER" is the master file, and 21800 is the record ID﴿

300

View data lineage through SlicerDicer

Create new SlicerDicer session in the visits data model

Add a new criterion for time waiting for physician

Click the information bubble on the criterion, then select “show lineage information”

400

• Create a SlicerDicer population and share a SlicerDicer Season

Use the Visual Options to determine the size and color of your populations.

SlicerDicer always considers data within a date range specified in the population header

Click Share and share this population with Hunter Timely

500

1.Apply advanced settings to criteria

2.Add goals and thresholds to a session

3.Create a custom measure

4.Change which dates a population is based on using the dates card

1.a user can use the Advanced Logic button to write their own logical expression combining the different criteria

2.Use Thresholds to assign ranges of values to a certain color. Bars whose value for that measure fall within the range will be the chosen color. One session can contain up to 15 thresholds ranges.

3.Use Goals to assign a single value to your measure. Your visualization will display a line at that value. One session can contain up to 15 goal values

4.By default, the first new measure you add to a session will be used to determine the height of the bars on your bar graph ﴾or points on your line, or size of blocks in a tree map﴿. If you create multiple measures, you can choose which of them to use in your Visual Options, or you can combine them into a new custom measure

5.Users can change the start and end dates of this range in the Dates card. They can also slice the date range into sections like day, month, and year to trend their data over time

Lets get Technical

100

What does a trace do?

• A trace will run the report as normal but the system will keep a log of what was done. This log can be viewed to show the exact logic evaluated for the subject of the trace. You are able to specify a record or set of records, and see why each record was included or excluded from the results of the report

200

What questions should I ask to clarify a request

• What should one row in the results represent
• What will you do with these results
• What do you expect to see in the results

300

The relationship between Workbench summaries and Radar components

The Explore tab allows end users to create their own summaries with the SlicerDicer interface. The biggest differences between summaries in the explore tab and summaries created in Report Settings are as follows: 1﴿ The summaries can be saved as views of the report results only. This means they will be available to all users who run the report, but only within the results, not on a dashboard. 2﴿ The summaries can be grouped and aggregated based on only the displayed PAF columns, not those listed as “Available” in the Display tab

400

The differences between summarizing in Reporting Workbench, SlicerDicer, and Radar

• For components with a data source of SlicerDicer, the Data Source form is very simple. Just select the saved SlicerDicer session you want to display on your component. For components with a data source of Report, the Data Source form specifies the Reporting Workbench report template, report, and summary from which the component will pull its data

500

What is the purpose of tracking metadata on reporting content

• Some of the useful things that can be modified here include: Descriptions and tags to improve visibility of your content to consumers. Review status and reviewer decisions to communicate which reports and dashboards have been validated. Ownership in case something breaks and needs fixing. For dashboards only, distribution to specific user types and report groups. More on how these work in the Security lesson

Perform the Following

100

Run a trace on an ad hoc Workbench report

• Log in to Hyperspace as a Cogito Tools Administrator 2 Use Chart Search to open the Analytics Catalog 3 Find the Pediatric Patients report 4 Right click on Pediatric Patients and select Trace 5 On the Single tab, enter the name of your patient and click Accept 6 Click the Report Options menu 7 Select View Trace
• As ad hoc searches run, the system checks approximately once per 1000 records that have been searched to determine whether the maximum has been reached. After the maximum is reached, the search stops automatically. However, the search might not stop exactly at the limit; it is normal for the search to stop slightly sooner or later than your limit.

200

View another user's Catalog and run a report from another user's catelog

• When a user with the proper security accesses the Analytics Catalog, one of the options on the left is View Another User's Catalog. While viewing the other user's catalog, they can view all of the content including their private reports.
• If you try to run a report while viewing another user's catalog, you will see a message indicating that the "report's results will be generated as if it were run by the login user, and may be different than if the report were run by" the user whose catalog you are viewing

300

Categorize a reporting need by the appropriate data source and visualization tool

• Chronicles
• Caboodle
• Clarity

Chronicles

• If the report needs Chronicles data, that is usually because the consumer wants to act directly on the results as they are in real time.
• Reporting Workbench is the most appropriate way to visualize Chronicles data
• Caboodle
•  If data doesn't need to be real time, then it will probably come from Caboodle. By combining Epic and non‐Epic data into a dimensional format, Caboodle acts as a primary data source for both complex analysis and user‐facing report requests.
•  SlicerDicer is the preferred means of visualizing Caboodle data.
• Workbench reports with a SQL search engine can also retrieve an initial data set from Caboodle 
• and then refine it in Chronicles.
• Dashboard Metrics built by Epic can use Caboodle as a data source.
• 3rd party tools can also be used to retrieve and analyze Caboodle data
• Clarity
• If the data needed isn't in Caboodle and doesn't need to be real time, then Clarity will be the data source. Clarity reports often require skilled and certified BIDs to write custom queries to retrieve and assemble the data. These can be the most time-consuming requests.
•  Reporting Workbench templates with a SQL search engine can use Clarity to get a starting set of records, and then refine the results using Chronicles data.
• Dashboard Metrics built by Epic can save you a lot of time in analyzing and displaying Clarity data.
• 3rd party tools can be used to retrieve and analyze Clarity data as well

400

• Retrieve the SQL query generated by a SlicerDicer session

• The best thing you can provide for a BID to get started in tracing this data is the actual SQL query generated by SlicerDicer. This can be viewed ﴾not edited﴿ in SlicerDicer by clicking the Troubleshoot button. The SQL query can then be copied out of Hyperspace into other SQL writing software to test and validate

500

Update documentation on custom records for the Analytics Catalog

Build a tag

Change the review status and reviewers of reporting content

Access dashboard metadata from the dashboard

• However, Catalog entries can also be edited directly from the Analytics Catalog, so maintaining tags and descriptions does not require accessing all of these separate editors
• Dashboard Options > About Dashboard > Edit Details
• Dashboard Options > About Dashboard > Edit Details