A client wants to see a bar chart with a single measure and three dimensions: Region, Product Category, and Month.

The business analyst creates a bar chart with the measure, Sum(Revenue).

Which final step should the business analyst take to complete the chart?

A. Add Region, Product Category, and Month as three different dimensions

B. Create a single master dimension with Region, Product Category, and Month

C. Add Region as a dimension, add Product Category and Month as alternate dimensions

D. Create a cyclic group with Region, Product Category, and Month as dimensions

A bus company wants to analyze customer travel patterns to add additional services or create new routes.

The business analyst needs to consider the following data: 190 routes across the city Start and end location of each route Volume of customers travelling per hour Customer complaints when buses are full

Which visualization should a business analyst use to meet this requirement?

A. Area layer map

B. Treemap

C. Line layer map

D. Scatter plot

A business analyst is creating a dashboard to analyze supply chains. The app must contain several elements: A bar chart that shows a number of products and product groups handled by shipper A map that shows the number of shipments sent from factory locations A bar chart that shows average delivery costs by shipper

Which dimensions should the business analyst use for this app?

A. Product, Shipper, FactoryLocation

B. Shipper, FactoryLocation

C. Shipper, Product

D. Product, ProductGroup, Shipper

Refer to the exhibit.

A business analyst must analyze sales using an existing sales order app. The Orders table in the app was added from a QVD file using the data manager The Orders table in the app and the QVD do NOT contain a SalesAmount field SalesAmount can be calculated by multiplying the Quantity and UnitPrice

How should the business analyst add a SalesAmount field into the Orders table?

A. In the data manager, create a new calculated field, SalesAmount, and set the expression value to Sum (UnitPrice * Quantity)

B. In the data mode viewer, add a calculated field named SalesAmount with the expression UnitPrice * Quantity

C. In the data manager, add a calculated field named SalesAmount with the expression UnitPrice * Quantity

D. In the Orders QVD file, add an additional field named SalesAmount with the expression UnitPrice * Quantity

Refer to the exhibit.

A business analyst creates a bar chart and notices the weekdays are NOT in a US default format. The

analyst does NOT have permissions to enter the data load editor and edit the data. The analyst only has a

few minutes before the meeting to show the insights to a manager.

The business analyst wants to quickly customize the chart to show the weekdays in US format.

Which action should the business analyst take to fix the chart?

A. Change the dimension label using the DATE() function to specify the right data format.

B. Change the dimension to a calculated dimension to specify the right data format.

C. Change the dimension label to a calculated dimension using an IF() function.

D. Change the dimension to a calculated dimension using the REPLACE() function.

A business analyst is NOT familiar with the data and is using insight advisor to create a number of visualizations.

Which steps should the business analyst take to add the visualizations to a sheet?

A. Click Generate insights to find visualizations, then click Add to sheet

B. Use the selection tool to find visualizations, then click Add to sheet

C. Use smart search to find visualizations, then click Add to sheet

D. Drag and drop fields on the workspace, then click Add to sheet

A company has customers in 16 countries. The majority of the customers are in Germany.

A business analyst creates a filter pane for Country, and wants "Germany" listed first. The rest of the

countries should be listed in alphabetical order.

Which method should the business analyst use to meet this requirement?

A. Edit the sheet, select Chart, Properties panel, Custom sorting, then select Germany

B. Edit the sheet, select Chart, Properties panel, Custom sorting, then click Descending Frequency

C. In the data manager, edit the table, select Country, then select Order from the data profiling card

D. In the data manager, edit the table, select Country, then select Order from the column header

A sales department has a pie chart that displays the total amount of sales by city.

Users have requested several changes to the pie chart:

Display the labels in `Red'

Increase the font size of the title

Change the color of the values to `Blue'

Which technique should a business analyst use to meet these requirements?

A. Create a custom theme

B. Develop a widget

C. Change chart properties

D. Use single configurator

A marketing team needs to analyze current sales by age groups in a bar chart. The following age groups

are created in the data manager, and the field is named AgeGroup:

Children: 16 years old and younger

YoungAdult: 17 to 30 years old

Adult: 31 years old and older

The business analyst will use an expression to set the colors for the bars:

If ([AgeGroup] = `Children', Red(), If ([AgeGroup] = `YoungAdult', Blue(), Green()))

Which steps must be completed to apply the correct colors in the visualization?

A. Select Data in the properties panel and create a calculated dimension using the expression editor.

B. Create a master item dimension using the expression, in the visualization, select Color by dimension and use the newly created master item.

C. Under Appearance in the properties panel, select Color, then select Color by expression, and make sure that The expression is a color code is checked.

D. Create a master item measure using the expression. In the visualization, select Color by measure and use the newly created master item.

A CEO of an automotive manufacturing company wants a single dashboard sheet to track the company's sales.

The app must meet several requirements: All charts must be on one sheet Show summary charts of key performance data Ability to scroll up and down the sheet

Which set of actions should the business analyst use to meet these requirement?

A. Use KPI objects Use Insight Advisor

B. Adjust grid spacing Use Insight Advisor

C. Use KPI objects Activate Chart assistance

D. Activate grid spacing Activate Extend sheet