Exam QSBA2018 All QuestionsBrowse all questions from this exam
Question 31

A business analyst has a QVD containing Sales, Manager, Date, and Region.

The business analyst needs to quickly create a sheet with three visualizations: Total Sales, Sales By Manager, and Sales by Date. The sheet must allow for analysis by Region.

In the search bar, the analyst enters `Sales`, `Manager`, and `Date`, and adds the objects to the sheet.

Which steps should the business analyst perform to finish creating the sheet?

    Correct Answer: D

    To meet the requirement of allowing analysis by Region, it is essential to add a filter pane for Region. Additionally, to create the Sales by Date visualization, a line chart with Date as the dimension and Sales as the measure is needed. Only option D correctly outlines these steps. First, adding filter panes for Region and Manager allows analysis by Region and visualization breakdown by Managers. Next, dragging and dropping Sales from the Fields list onto the sheet includes the total sales data. Finally, adding a line chart with Date as the dimension and Sales as the measure finalizes the Sales by Date visualization.

Discussion
turchinadOption: D

D. 1. Add two filter panes: Region and Manager 2. Drag and drop Sales from the Fields list onto the sheet 3. Add a line chart with Date as the dimension and Sales as the measure