Online Access Free QSBA2021 Practice Test

After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.
What should be developed to meet this requirement?

• A.Grid chart with diverging color by measure
• B.Line chart with area gradient color by measure
• C.Waterfall chart with custom positive value color
• D.Mekko chart with diverging color by dimension

A business analyst is creating an app that requires several visualizations
* A scatter plot mat shows the margin percentage and total sales by product category
* A map with a the layer that visualizes lines between retail stores and lactones
* A KPI that shows total cost
Margin% can be calculated by dividing profit by revenue Profit is the difference between total cost and total sates Which two sets of fields can the business analyst use to meet these requirements? (Select two.)

• A.Product Category
  Retail Store Location
  Factory Location
• B.Product Category
  Location
• C.Sales
  Total Cost
• D.Line Geometry
• E.Line Geometry
  Margin%

Refer to the exhibit.

After the latest data reload a business analyst notices the value tor CategoryID 'B321' seems different What is causing this discrepancy?

• A.The data type for CategorylD 332V does not match the others
• B.Some categories do NOT exist in the Category table
• C.Hyphen character ('.') is included m the source data
• D.Null values are deluded in the source data

A business analyst inherits an app full of sheets The business analyst needs to redesign the app using the DAR principle How should the business analyst order the visualizations?

• A.* KPIs
  * Table PivotTable
  * Bar Chart Pie Chart Line Chart
• B.* KPIS
  * Ba' Chart Pie Chart Line Chart
  * Table Pivot. Table
• C.* Bar Chart Pie Chart Line Chart
  * Table Pivot Table
  * KPIs
• D.* Bar Chart Pie Chart Line Chart
  * KPIs
  * Table Pivol Table

Refer to the exhibit.

A CEO wants to use a similar visualization on the company's dashboards
The visualization must meet several requirements
* Show three years of sales data
* Display sales trends by month
* Allow comparison of years using an area style display
Which set of actions should a business analyst take to meet these requirements?

• A.* Add a fine chart
  * Add Month first then Year as the dimensions
  * Add Surry Sales > as the measure
  * In the properties panel under Presentation select Area
• B.* Add an area chart
  * Add Month first then Year as the dimensions
  * Add SumfSates) as the measure
  * In the properties panel under Area select the dimension Year
• C.* Add an area chart
  * Add Year first then Month as the dimensions
  * Add Sum(Sales) as the measure
  * In the properties panel under Area select the dimensions
• D.* Add a ,line chart
  * Add a master drill-down dimension with Year and Month
  * Add Sum(Sates) as the measure
  * In the properties panel under Presentation, select Area