Creating Advanced Reports with SAS Visual Analytics Quiz Answers

Creating Advanced Reports with SAS Visual Analytics Week 1 Quiz Answer

Quiz : Creating Advanced Data Items Review

Q1. What type of data items can be created outside of Visual Analytics (for example, in SAS Data Studio or using SAS code)?

• Parameters
• Geography data items
• Hierarchies
• Calculated items

Q2. In the following calculated item, why does the expression generate an error?

• You cannot name a calculated item the same name as an existing data item.
• Missing is an invalid value.
• The In operator does not work for character data.
• The calculated item type does not match the result from the expression.

Q3. Which date and time operator creates a date value?

• Now
• Month
• DatePart
• DayOfMonth

Q3. Which operator enables a numeric or datetime value to be used as a different type for the calculation?

• Replace
• Parse
• TreatAs
• Update

Q5. Which aggregated (periodic) operator can be used to return aggregated values for next month?

• RelativePeriod
• CumulativePeriod
• Period
• ParallelPeriod

Q6. For aggregated (periodic) operators, which time filters option applies all filters (object filters and interactive filters) AFTER the measure is calculated?

• ApplyAllFilters
• IgnoreInteractiveTimeFrameFilters
• IgnoreAllTimeFrameFilters
• ApplyFiltersLast

Q7. For aggregated (periodic) operators, which scope parameter will aggregate the measure for the entire period (the entire month, quarter, or year)?

• ToDate
• All
• ToToday
• Full

Q8. Which aggregated (periodic) operator can be used to calculate a running total for the fiscal year?

• CumulativePeriod
• Period
• RelativePeriod
• ParallelPeriod

Q9. Which aggregated (advanced) operator will hide values based on a condition?

• HideValues
• SuppressValues
• Suppress
• Hidden

Q10. Which aggregated operator can be used to calculate a running total over a category?

• CumulativeCells
• AggregateCells
• AggregatePeriod
• CumulativePeriod

Creating Advanced Reports with SAS Visual Analytics Week 2 Quiz Answer

Quiz : Using Parameters to Create Advanced Reports Review

Q1. Suppose you want to use parameters in a report. What do you do in the Create step?

• Add the data source to the report.
• Use the parameter in a calculation, a display rule, a filter, or a rank.
• Determine the type of parameter needed for the scenario.
• Add a control object to the canvas so the viewer can update the parameter.

Q2. Suppose you want a viewer to specify the minimum salary. What type of parameter would you create?

• Multiple values
• Date
• Numeric
• Character

Q3. Suppose you want a viewer to enter a string to search for a product. What type of parameter would you create?

• Multiple Values
• Character
• Date
• Numeric

Q4. Suppose you want a viewer to enter the number of years to view in a time series plot. What type of parameter would you create

• Numeric
• Character
• Date
• Multiple values

Q5. Suppose you want to use parameters in a report. What do you do in the Populate step?

• Add the data source to the report.
• Add a control object to the canvas so the viewer can update the parameter.
• Use the parameter in a calculation, a display rule, a filter, or a rank.
• Determine the type of parameter needed for the scenario.

Q6. Which types of controls can be used with numeric parameters?

• Slider, button bar
• Text input, button bar
• Slider, drop-down list
• Text input, slider

Q7. Which types of control CANNOT be used with character parameters?

• Drop-down list
• Text input
• Slider
• Button bar

Q8. Where can a parameter NOT be used?

• A filter
• A custom category
• A display rule
• A calculation

Q9. Suppose you want to use parameters in a report. What do you do in the Apply step?

• Add the data source to the report.
• Add a control object to the canvas so the viewer can update the parameter.
• Determine the type of parameter needed for the scenario.
• Use the parameter in a calculation, a display rule, a filter, or a rank.

Q10. Assume the following scenario:

You create a numeric parameter that ranges from 1-10 with a default value of 5.

You add a slider control to the report and assign the parameter to the control.

When you modify the value of the parameter, the report doesn’t change.

Why is the report not updating when the parameter is modified?

• You specified the incorrect range for the parameter.
• You used the incorrect control object for the parameter type.
• You forgot to apply the parameter to the report.
• You created the incorrect type of parameter.

Get SAS Visual Business Analytics Professional Certificate Quiz Answers

Getting Started with SAS Visual Analytics Coursera Quiz Answers

Data Analysis and Reporting in SAS Visual Analytics Quiz Answers

Using Data for Geographic Mapping and Forecasting in SAS Visual Analytics Quiz Answers

Performing Network, Path, and Text Analyses in SAS Visual Analytics Quiz Answers

Creating Advanced Reports with SAS Visual Analytics Quiz Answers