Online Access Free QSBA2018 Exam Questions

A business analyst must create a horizontal bar chart to identify the top Sales Reps. Customer Segment Description, and Customer City
* Users must be able t(^analyze the data for one field at a time
* The chart should show the unique number of customers for each dimension being analyzed
* The dimensions and measures created must be re-used on other charts
Which steps should the business analyst perform to configure the chart correctly?

• A.* Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
  * Create a master item measure using Count(Distinct [Customer Number]) and add it to the chart
  * Change the chart presentation to Horizontal and sort it by the measure
• B.* Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions
  * Create a master item measure using Count(Total (Customer Number)) and add it to the chart
  * Change the chart presentation to Horizontal and sort it by the measure
• C.* Create all three dimensions as master items and add to the bar chart
  * Create a master item measure using Count{Distinct [Customer Number]) and add it to the chart
  * Change the chart presentation to Horizontal and sort it by the first dimension
• D.* Create a cyclic dimension as a master item using all three dimensions and add it to the chart
  * Create a master item measure using Count{Distinct [Customer Number]) and add it to the chart
  * Change the chart presentation to Horizontal and sort it by the measure

The sales department requests a new Qlik Sense app to show the amount of sales in each territory The app must:
* Allow analysis of aggregate views of big data stores
* Include objects that allow the user to jump to a specific sheet
* Provide a way to send a report through email
Which three products or features should the business analyst use to meet these requirements? (Select three.)

• A.Bookmarks
• B.Qlik NPrinting
• C.On Demand App Generation
• D.Qlik DataMarket
• E.Qlik Sense Enterprise for Elastic

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.Drag and drop fields on the workspace, then click Add to sheet
• B.Use smart search to find visualizations, then click Add to sheet
• C.Click Generate insights to find visualizations, then click Add to sheet
• D.Use the selection tool to find visualizations, then click Add to sheet

Refer to the exhibit.

A business analyst must provide a visualization to show the trends of the number of orders generated per employee The Customer must be searchable.
EmployeelDT EmployeeName, OrderlD. and CustomerlD will be included in the load.
Which additional fields must be loaded to meet this requirement?

• A.Customer. ProductID
• B.OrderDate. UnitPrice
• C.OrderDate Customer. ProductID
• D.OrderDate. Customer

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)

• A.Option D
• B.Option C
• C.Option A
• D.Option B