Exam QSBA2018 All QuestionsBrowse all questions from this exam
Question 26

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 to 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 a cyclic dimension as a master item using all three dimensions and add it to the chart

✑ 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 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

D.

✑ 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

    Correct Answer:

    The correct steps the business analyst should perform to configure the chart correctly are as follows: 1. Create all three dimensions (Sales Reps, Customer Segment Description, Customer City) as master items and add one as the chart dimension and the other two as alternative dimensions. This allows users to analyze data for one dimension at a time. 2. Create a master item measure using Count(Distinct[Customer Number]) to ensure the chart shows the unique number of customers for each dimension. 3. Change the chart presentation to Horizontal and sort it by the measure to clearly display the top Sales Reps, Customer Segment Description, or Customer City effectively. The answer is A.

Discussion
turchinad

I think it's A because the measure need the distinct not the total. Right?