A data architect adds a field to an existing data model that contains new values for the ProductGroup. The business analyst needs to efficiently update the app and meet these requirements:
✑ Use the existing charts, which are built using a master item dimension called ProductGroup
✑ Existing charts must use the new values for ProductGroup
✑ Business users must be able to compare the new and old values
How should the business analyst meet these requirements?
Correct Answer:
A
🗳️
A business analysis must create new master items for quarterly calendar measures with company-specific conventions based on:
✑ The Date field and the Sum of Sales
✑ The new master items will calculate QTD Sales, Current QTD Sales, Last QTD Sales, Current Quarter Sales, Last Year Current Quarter Sales, and Last
Quarter Sales -
Which three steps should the business analyst take to meet these requirements? (Choose three.)
Correct Answer:
BCD
🗳️
A business analyst is building a dashboard to track customer loyalty. The app has several requirements:
✑ A table that shows the total number of purchases by customer
✑ A scatter plot that shows the correlation between the number of purchases and total spent by customer
✑ A bar chart that shows the top five customers by sales
Which two measures should the business analyst use to meet these requirements? (Choose two.)
Correct Answer:
BC
🗳️
A client wants to see a bar chart with a single measure and three dimensions: Region, Product Category, and Month.
The business analyst creates a bar chart with the measure, Sum(Revenue).
Which final step should the business analyst take to complete the chart?
Correct Answer:
C
🗳️