Free QSBA2018 Exam braindumps download (QSBA2018 exam dumps Free)

QUESTION: 11

A business analyst must display current year sales versus previous year sales by region, sub-region, and city
The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales
Which calculated expressions should the business analyst create to meet these requirements? A)

B)

C)

D)

Option A
Option B
Option C
Option D

Answer(s): D

Show Answer Next Question

QUESTION: 12

A business analyst needs to create an app showing sales dat

The app requirements are as follows
- Compare sales for the current year (CY Sales) versus last year (LY Sales)
- CY Sales must always be displayed in blue
- LY Sales must always be displayed in yellow
Which steps should the business analyst take to meet these requirements?
1 Create a KPI with two measures, CY Sales and LY Sales 2 Write an IF expression to set the appropriate colors for each measure
1. Create CY Sales and LY Sales measures as master items 2 Write an IF expression to set the appropriate colors for the master items
1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2 Create one KPI from the two master item measures
1 Create CY Sales and LY Sales measures as master items and set the required color for each measure using Value colors
2 Create two gauges, one for each measure and set the color for each appropriately

Answer(s): C

Show Answer Next Question

QUESTION: 13

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?

Product, Shipper. FactoryLocation
Shipper, Factor/Location
Shipper, Product
Product, ProductGroup. Shipper

Answer(s): B

Show Answer Next Question

QUESTION: 14

A business analyst uses the data manager to load customer data from a QVD file. The data manager automatically profiles the data, and recognizes City and Country values as Geo data.
The app must meet the following requirements;
- Country field should be in Geo data format
- City should NOT be allowed as a mapping option for the users
- There must be an association between the Country and City fields Which actions should the business analyst take to meet these requirements?

1. In the Associations view, select the City field
2 Delete Sgeoname-tag from field properties
1. In the Associations view, select the City field
2 Change the format from 'Geo data' to 'No data profiling'
1 In the Associations view select the City field
2 Delete the City field
1. In the Associations view, select the City field
2 Change the format from 'Geo data' to 'General'

Answer(s): D

Show Answer Next Question

QUESTION: 15

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)

B)

C)

D)