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?
The board asked the team to review current sales by age group on a bar chart. These groups were created in Data Manager and named AgeGroup, as follows: • Children: up to 16 years; • YoungAdult: between 17 and 30 years old; • Adult: 31+ The analyst then defines the colors of the bars with an expression: If( AgeGroup = 'Children', Red(), If( AgeGroup = 'YoungAdult', Blue(), Green() )) What's left to complete the jobs and apply the result to the visualization?
A sales department has a pie chart that displays the total amount os sales by city. Users have requested several changes to the pie chart: • Display the labels in 'Red'; • Increase the font size of the title; • Change the color of the values to 'Blue'. Which technique should a business analyst use to meet these requirements?