Quiz: Refining Data for Effective Reports

Your score: 0%

	For the outlier analysis of Total Orders, how do the outliers impact total product orders?  a.  They increase total orders by 32.93%  b.  They decrease total orders by 32.93%  c.  They increase total orders by 27.44%  d.  They decrease total orders by 27.44% The outliers for Total Orders are all on the upper extreme (more than 1.5 times greater than the interquartile range from the interquartile range). Therefore, the outliers will increase total orders. The What Is the Effect of Outlies on Total Orders section shows their precise impact, they increase total orders by 32.93%.
	On what type of data item can you create a custom category?  a.  Aggregated measure  b.  Parameter  c.  Measure  d.  Hierarchy Custom categories can create labels for groups of category or measure data items.
	Which type of data item recalculates the expression depending on other data items used in the chart?  a.  Calculated item  b.  Aggregated measure  c.  Custom category  d.  Dynamic measure Aggregated measures recalculate the expression depending on other data items used in the chart; they are very dynamic.
	Suppose you have made the following modifications to your data source for a report: Changed aggregations for 3 measures Modified the format for 2 measures and a date Changed the name for category Created two calculated items and two quick calculations Created two geography data items and a geographic hierarchy Hid 12 unused data items What can you create to save and apply all the data settings to another report?  a.  Data view  b.  Data join  c.  Aggregate data  d.  Map data Data views can be used to save and apply all of the settings for a data source, like data item properties (such as names, formats, classifications, and aggregations), data source filters, hierarchies, calculated items, custom categories, duplicate data items, show and hide statuses for data items, unique row identifier selections, and parameters used with data source.
	A variety of filters can be applied to a report and modified by only the report designer. Which filter is applied before the data is brought into Visual Analytics?  a.  Data source filter  b.  Local filter  c.  Pre-aggregate filter  d.  Table filter A data source filter is applied to every object that uses the data source. It acts as a pre-filter by filtering the data before it is brought into Visual Analytics.
	Which type of static filter subsets data for an individual object using a single data item expression?  a.  Basic filters  b.  Post-aggregate report filters  c.  Prompts  d.  Actions Basic filters are object-level filters that subset data for individual report objects using a single data item expression.
	Which type of static filter can subset an object using any number of data items and operators in the same expression?  a.  Data source filter  b.  Basic filter  c.  Advanced filter  d.  Post-aggregate filter Advanced filters subset an object using any number of data items and operators in the same expression. For example, Country = 'United States' and Department = 'Sales'.
	Which type of filter can be applied to multiple objects in the report, even objects on different pages?  a.  Basic filter  b.  Advanced filter  c.  Common filter  d.  Post-aggregate filter Common filters can be applied to multiple objects in the report, even objects on different pages.
	What do the numbers after each category data item represent?  a.  The sort order for the category data items.  b.  The frequency of the data item in the source data.  c.  How many times the category data item has been used in the report.  d.  The cardinality, which is the number of unique values for each category data item. The number next to each category data item specifies the cardinality of the data item, or the number of unique values.
	Measure, Category, Date, Time, Datetime, and Geography are:  a.  Classifications  b.  Formats  c.  Aggregations  d.  Tooltips Measure, Category, Date, Time, Datetime, and Geography are data item classifications. In Visual Analytics, the classification provides the rules around how the data item can be used in the report.