SlicerDicer Flashcards

1
Q

In Hyperspace, can you use the epic menu to open slicer dicer?

A

Yes, you put in slicer dicer to the search bar and it brings up the slicer dicer tool bar and you click on that and it takes you to electing a model.61

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is slicerDicer?

A

It is a self service reporting tool.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How does Slicer Dicer respects user security in several ways?

A

Slicer Dicer respects user security in several ways: 62
* Users will not have access to every data model in the system. Each data model is available to only a subset of users.
* When a User builds and slices populations, all of the data retrieved is implicitly filtered by service area security.
* Most users will not be able to view data about individual members of a population.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

True or False: Slicer Dicer retries its data from caboodle databases.

A

Slicer Dicer retries its data from caboodle databases. With the ability to modify your data range and aggregate over weeks, months, or even years, slicer dicer can be primary resource for discerning long-term trends across your organization. 62

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

True or False: Slicer Dicer can be used for small data sets?

A

SlicerDicer can also be a powerful tool for following up on specific, small sets of records. After a user narrows down their population to the records they need, they can view the data at the line level or export the data to Reporting Workbench where the population can be acted on directly.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

True or False: You can use slicer dicer for regional maps?

A

In addition to bar and line graphs, SlicerDicer’s geographic visualizations plot results on a regional map. For population health and risk factor analysis, this can be more intuitive than a list of ZIP Codes or addresses.63

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

True or False: You are able to customize Slicer Dicer?

A

Slicer dicer can report oof of any data in caboodle, and your organization can develop custom content for caboodle. If your developers extract custom data to caboodle, the slicerdicer can access that data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

True or False: Slicer Dicer can use non epic data?

A

True 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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

True or False: Slicer Dicer looks at data from that day?

A

False, the process that moves data into Caboodle is not instantaneous. Therefore, SlicerDicer does not know about any data entered into the system today.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A patient communications report wants a population that shows how many appointments there are today with a status of “Scheduled”. They want to reference this throughout the day to keep track of how many appoints are left to check in. Could this be done in slicerDicer?

A

No. Slicer dicer does not contain today’s data, so a list of scheduled appointments would not change throughout the day.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

True or False: I can use slicer dicer for KPIs?

A

False KPIs ﴾Key Performance Indicators﴿ need to be standardized for all consumers. Since SlicerDicer is designed to let every user adjust and manipulate their visualization of the underlying data, it is not ideal for this type of report. Instead, we use Dashboard Metrics as our primary tool for distributing KPIs to consumers. 64

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A patient communications report wants a population that shows how many appointments there are today with a status of “Scheduled”. They want to reference this throughout the day to keep track of how many appoints are left to check in. Could this be done in Slicer Dicer?

A

No. Slicer dicer does not contain today’s data, so a list of scheduled appointments would not change throughout the day.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

True or False: Slicer dicer affects your production database, chronicles?

A

False, Slicer Dicer retries its data from caboodle databases. This means it can filter and display large data sets without affecting your production database, chronicles.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How does SlicerDicer get its data?

A

Through a model, one slicerdicer data model consists of a set of data that has been curated with a pre-built set of available filters.65

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A user wants a list of surgical cases scheduled in the next week grouped by procedure. They
will reference this list at the start of each week to audit room and staff usage. Could Slicer Dicer meet this need? Why

A

Yes. Even though the list has to include future cases, these cases were scheduled in advance,
and all such surgeries scheduled at least a day earlier will be displayed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does SLicerDicer data model consists of ?

A

One SlicerDicer data model consists of a set of data that has been curated with a pre-built set of available filters.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is a different way to think of the SlicerDicer Filter?

A

Another way to think about a SlicerDicer filter is as a data point. One SlicerDIcer filter contains one data point that can be used for many purposes.65

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What does it mean when Epic says, “SlicerDicer is a data-first reporting tool”.

A

This means that when you first open a data model, you start with the entire population and then add appropriate criteria to hone in on the most important data. Your population starts with a base and is refined using criteria. 65

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What does a Base mean in Slicer dicer?

A

Depending on which data model you are working with, slicerdicer will use a different base to define your population

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

True or False: All data models have a “My Records” base?

A

False, not all data models have a “My Records” base. To see which bases are available for a data model, open a new session with that data model and check the “base” entry in the population.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

In Slicer Dicer, how does criteria work?

A

Criteria are often the first piece of a population that a user modifies. Criteria refine a population to only the desired records. 66

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

How can you add criteria in SlicerDicer?

A

A user will usually add a new criteria by clicking browse in their population to select from the available criteria. The list of available criteria for a data model is defined by SlicerDicer Filters.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What does it mean when Criteria default to being inclusive?

A

This means they only include results for whom the criterion is true. If you wish to instead create a population for whom the criteria are false, you can change from inclusive to exclusive either when adding the criterion initially, or by clicking the customizations button.67

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Slicer dicer filters, records in the FDS master file. do not have many uses?

A

False, Slicer Dicer filters, records in the FDS master file, have many uses. You may sometimes hear Slicer Dicer filters referred to as simply filters but that can be misleading given the use of the word in everyday English. Slicer dicer filters can indeed be used to refine a set of data, but they have other uses in slicer dicer as well. Think of it as a data that can be used for many purposes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

What does sequential criteria return?

A

Returns records where one criterion precedes the another.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

How can you access more powerful and complex ways to use a criterion such as sequential, overlapping criteria?

A

You will click on advance options button. The button appears as a cogwheel on the criterion once it has been added.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What does overlapping criteria return?

A

returns records where all criteria are met simultaneously

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

What does specify age range at time of event?

A

allows the addition of associate age in years tied to a single event criterion.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

What does specify date range return?

A

This allows each criterion to use its own date range.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

What is Sequential Criteria?

A

You could find all patients with a knee replacement followed by physical therapy encounter or find all office visits followed by an ED encounter.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

What is overlapping criteria?

A

You could find all patients who were diagnosed with influenzas on the same date that walk whitecoat was their provider, instead of finding all patients who has influenza in the past year and also has walk whitecoat as their provider in the past year.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

What is criteria-specific date ranges?

A

You could find all patients with a cancer diagnosis in the last year who have a visit scheduled in the next month.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

What is specifying an age at the time of an event?

A

You could find all patients who were under 18 years of age when they received a diagnosis of depression.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

In SlicerDicer, how do you apply logical operations?

A

You can do this by clicking the advance logic text on the population base tab. Clicking the logical operators between criteria can flip them between AND and OR to change how they are evaluated. In addition, a user can use the advance logic button to write their own logical expression combining the different criteria. 67

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

What is the difference between inclusive and exclusive?

A

Inclusive means they only include results for whom the criterion is true. If you wish to instead create a population for whom the criterion is false, you can change from inclusive to exclusive either when adding the criterion initially, or by clicking the advance options button.

36
Q

True or False: Criteria default to being exclusive?

A

False, criteria default to being inclusive. This means that they only include results for whom the criterion is true.

37
Q

True or False: A slice is divided by buckets?

A

True, a slice divides up the population into the appropriate buckets so you can view and compare populations quickly. 68

38
Q

After selecting a slicerDicer Filter to slice on, what can the user do?

A

*Specify what values for the SlicerDicer filter should each get their own slice
* Grab the top 10
* Grab the bottom 10
* Grab the top or bottom N records (where N is user-specified)

39
Q

Slicing meets report requests that includes some variation of:

A

Group this data by <data>
Show me the records with the most/fewest <data>68</data></data>

40
Q

True or False” By default slicing will not include a slice for none of the above. You have to add it to include the none of the above?

A

False, by default, slicing will always include a slice for “none of the above” comparing your sliced portion of the population to the rest of the population. To disable this, click settings and clear the box for ADD “NONE OF THE ABOVE” OR “NO VALUE” TO SLICES BY DEFAULT.68

41
Q

What are measures in slicer dicer?

A

Measures determine what function aggregates the data.

42
Q

True or False: You are only able to add thresholds or Goals to your slicerdicer?

A

False, while building/Changing your measures, you can add both thresholds and goals to your session. 69

43
Q

True or False: All populations begin as a count of results?

A

True, however, you can do much more. Measures determine what function aggregates the data.

44
Q

How do thresholds work in slicerdicer?

A

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

45
Q

How do goals work in slicerdicer?

A

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. 69

46
Q

True or False: goals will appear as a line for a bar graph but not in a line graph.

A

False, goals will appear as a line for bar graph and a line graph visualizations. In a pie or ring chart, a goal appears as its own separate wedge.70

47
Q

True or False: Thresholds only appear in bar and line graph visualizations?

A

True 70

48
Q

True or False: goals and thresholds appear in stacked bars?

A

False, neither appears in stack bar graph visualizations. 70

49
Q

Where can you edit the date on a slicer dicer?

A

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. 71

50
Q

True or False: The date range does not affect certain slicer dicer filters?

A

True, the date range does not affect certain slicer dicer filters. these only reflect the most recent value stored in an item and are labeled as last stored. users will see the following message when they use these so they understand how the date range wont change their results.

51
Q

True or False: Last stored modifiers are affected by date range?

A

False: Slicer Dicer filters with the last stored modifier will not be affected by the date range in slicer dicer.

52
Q

True or False: date ranges affect all SlicerDicer Filters?

A

False, the date range does not affect certain SlicerDicer Filters. These only reflect on the most recent value stored in an item and are labeled as Last Stored. Users will see the following message when they use these so they understand how the date range won’t change their results.

53
Q

True or False: By default, the last measure is what determines the height of the bars on your bar graph?

A

False, 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.

54
Q

True or False: If you have the right security you can drill down to the record level of data?

A

True, Users with the appropriate security can drill down to the record level data. Users can add new columns to the table, sort and group results and even jump right into a hyperspace activity. 72

55
Q

The Visual options card determines the size and color of the populations, what does the bar height, bar color, and Y-Axis range do?

A

Bar Height: Choose a measure that will define the size of each population. This is usually the measure you’re using to compare, rate, or rank your population.

Bar Color: Choose a measure and a color range to have the color of each population represent the output of that measure.

Y‐Axis Range: By default, the axis automatically resizes, but users can set a specific range to
standardize the display.

56
Q

When should you use a stacked bar graph?

A

Stacked bar graphs should be used when the sum of the slices is as important as each individual slice.

57
Q

When should you use a line graph?

A

Line graphs are used to show data trending over time. when you use the visual options card to choose a line graph, you will have different ways to handle missing data along your time.

58
Q

Explain the difference between interpolate, show gap, and show at zero.

A

Interpolate: Connect the available data points on either side of any missing data.
Show gap: Display a space between known points when there is a missing data point.
Show at zero: Your line graph will drop to zero for any date intervals containing no data.

59
Q

Explain the difference between a tree map and a pie graph.

A

Tree maps show hierarchical relationships via their nested rectangles and can include additional measure by using color. With tree maps users can easily distinguish between categories and values at a glance.

Pie graphs are meant to visualize and compare a part to a whole. Pie graphs should have no more than 4 slices to ensure the graphs are still easy to interpret.

60
Q

How can you sort columns in SlicerDicer?

A

Users can sort columns by clicking the column headers. They can also add new columns by clicking the add icon in the column headers. The columns available to add come from the same list of slicerdicer filters when adding a criterion, slice, or measures.

61
Q

What is a detail table in slicerdicer?

A

Slicerdicer can render the results at a detailed level in the detail table. Users with appropriate security can drill down to the record-level data. Users can add new columns to the table, sort and group results, and even jump right into a hyperspace activity. For users who need the details of the data set out of hyperspace, slicer dicer can also export it to excel.

62
Q

What can you do with columns in the detail table for slicerdicer?

A

Users can sort columns by clicking the column headers. They can also add new columns by clicking the add icon in the columns available to add come from the same list of slicerdicer filters used when adding a criterion, slice, or measure.

63
Q

True or False: Can you add a slicer dicer to a component and then to the source dashboard?

A

Yes, administrators can manually create a new slicer dicer component using component editor.

64
Q

What happens when you add a slicer dicer session and the users have different securities?

A

As with all reports in hyperspace, Slicer dicer sessions can be built to restrict data based on the security of the user viewing it. A saved session on a dashboard can look different for two users with different security. Administrators must consider the audience of the dashboard and adjust distribution strategy as necessary.

65
Q

What is the issue when adding a slicer dicer component to the dashboard view?

A

Adding an existing slicer dicer based graph component to a dashboard view is no different than adding any other component. Users can find components in the analytics catalog and add them to their view. However, slicer dicer components come with an added wrinkle. Users have the ability to create their own brand new slicer components as well. These user -created components are added directly to the users view via the create component button. The create component button is available in the dashboard options menu and launches slicer dicer directly.

From there users can create a new session or load a saved one. Users can manipulate the session like any other slicer dicer session, then use the create component button to create a slicer dicer component and add it to their dashboard view.

66
Q

When a user saves a slicer dicer session for use on a dashboard, there are a few options that will impact the session specifically on the dashboard. What are they?

A

Recalculate Base Filters: If selected, all records or my records bases will re-evaluate for each use who views the component on their dashboard.

Use dashboard dates: If selected, any changes to the dashboard’s date range will immediately change the date range of this session as well.

Dashboard parameters: This option allows you to map specific filters in this data model to parameter values that may be stored at the dashboard level. You can map parameters to criteria or slices.

67
Q

What will happen if you associate a dashboard parameter with a criterion or slice?

A

If you associate a dashboard parameter with a criterion or slice, the dashboard parameter will change the output of your slicer dicer session immediately upon viewing it on a dashboard. if you want your session to appear on a dashboard exactly as you see it in slicer dicer, you do not associate any dashboard parameters.

68
Q

When should you use slicer dicer components?

A

End users should build slicer dicer components to easily view and track the sessions they create for themselves. good use cases would be:

*Data that you want to see every time you log in.

*Data related to other metrics and graphs on an existing dashboard.

  • A query you want to be able to revisit regularly and modify or re-evaluate for unique cases.
69
Q

Study Check List: Explain Data Model in Slicer Dicer.

A

Data Model: One SlicerDicer Data Model consists of a set of data that has been curated with a pre-built set of available filters. Epic releases many data models, but an organization can create their own unique data models as well.

70
Q

Study Check List: Explain SlicerDicer Filter.

A

Filters: SlicerDicer filters, records in the FDS master file, have many uses. You may sometimes hear slicerDicer filters referred to as simply filters, but that can be misleading given the use of the word in everyday English. Slicerdicer filters can indeed be used to refine a set of data, but they have other uses in slicerdicer as well. One SilverDicer filter contains one data point that can be used for many purposes. 65

71
Q

Study Check List: Explain population.

A

SlicerDicer is a data-First Rorting tool, This means that when you first open a data model, you start with the entire population and then add appropriate criteria to hone in on the most important data. Your population starts with a base and is refined using criteria. 65

72
Q

Study Check List: Explain Base.

A

Slicerdicer will use a different base to define your population.

73
Q

Study Check List: Explain Criteria.

A

Criteria: Criteria refines a population nto only the desired records. A user will usually add new criteria by clicking Browse in their populations to select from the available criteria. The list of available criteria for a data model is defined by SlicerDicer Filters.

74
Q

Study Check List: Explain Measures

A

Measures: Measures determine what function aggregates the data. This can be thought of as the number at the top of the bar in a vertical bar graph. The slicerdicer filters use when building criteria or slices are the same as those available when choosing a measure. Any time a user wants to see their data expressed as a function of a data point. They can accomplish this by changing the measure of the population The functions available depend on the measure. 69

75
Q

Study Check List: Explain Slices.

A

Slices: A slice divides up the population into the appropriate buckets so you can view and compare populations quickly. Users select slices from the list of slicerDicer Filters. Much like the list of available criteria, the list of slicers for a data model is defined by slicerDicer Filters. In fact, these are the same. For a given data model, the list of criteria and the list of data points on which users can slice are identical. 68

76
Q

Study Check List: Explain Exclusive Criteria.

A

Criteria default to being inclusive. This means they only include results for whom the criterion is true. If you wish to instead create a population for whom the criterion is false, you can change from inclusive to
exclusive either when adding the criterion initially, or by clicking the customization button

77
Q

Study Check List: What is SlicerDicer for?

A

It is a self-service reporting tool, for large and small data sets, and for visualizing data. It is also customizable which means you can use epic data as well as nonepic data 62-63

78
Q

Study Check List: What is SlicerDicer not used for?

A

*SlicerDicer does not look at data entered today.
The process that moves data into caboodle is not instantaneous. Therefore, SlicerDicer does not know about any data entered into the system today. 64

*SlicerDicer Session are not for KPI reporting:
SlicerDicer is designed to let every user adjust and manipulate their visualization, it is not idea for KPI reporting. Instead use dashboard metrics as a primary tool for distributing KPIs to consumers. 64

79
Q

Study Check List: What are over lapping criteria?

A
  • This returns records where all criteria are met simultaneously.67
  • Using overlapping criteria, you could find all patients who were diagnosed with influenza on the same day that Walt Whitecoat was their provider, instead of finding all patients who had influenza in the past year and also had Walt Whitecoat as their providers in the past year 67
80
Q

Study Check List: What are sequential criteria?

A
  • To add sequential criteria, which returns records where one criterion precedes another. 66
  • 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.67
81
Q

Requirements for SlicerDicer to use custom data?

A
  • That user must have access to both data models (proper security)
  • the data models must have a link built out connecting them together.
82
Q

Study Check List: How would you go about sharing a SlicerDicer?

A

1.Click share on the SlicerDIcer Toolbar.
2. Grant access to your SlicerDicer Session. you can grant access to everyone or just individuals.

83
Q

Study Check List: Where can you go to add advance Criteria where would that be?

A

The button appears as a cogwheel on the criterion.66

84
Q

Study Check List: Where would you add goals and thresholds?

A

You would go to the measures tab and click on the add goals or threshold button. 69

85
Q

Study Check List: How would you create a custom measurement in SlicerDicer?

A
  1. Go to measures
  2. Add the variables that you want to measure that are already in there.
  3. add a new measure and click create new formula.
    4.Put in the Display Name of the new measure.
  4. Put in the formula
86
Q

Study Check List: How would you change which dates a population is based on using the dates card?

A

You would go to the dates tab and select slice by?