Question 1 In PowerBI: On Page 3, Click on the Year field in the Dataset table.
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
Question 1
In PowerBI:
On Page 3, Click on the Year field in the Dataset table. In the Summarization box on the Column Tools ribbon, select Don’t Summarize.
Create the following visualizations:
1. Table Visualization: Add the following fields to the table: Year, Units Sold, % of Grand Total. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show data.
2. Pie Chart Visualization. Add the following fields to the chart: Year and Units Sold. Format the Data color: #893395, Theme color 4, 20% lighter. Format the Legend and Chart Title as Font: Segoe Bold, 15 pt. Change the Chart Title to Naima
3. Apply the following Filter to the Page to show the following years: 2017, 2018, 2019. Format the largest slice of the pie as #893395, Theme color 4, 20% lighter.
What is the total Units Sold for the 3 years?
What is % of the Grand Total for the 3 years?
Which of the 3 years has the highest total Units Sold? What is this number?
Which of the 3 years has the lowest total Units Sold? What is this number?
Question 2
In PowerBI:
On Page 4, create the following visualizations:
1. Table Visualization: Add the following fields to the table: Country, Units Sold, % of Grand Total. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show data.
2. Map Visualization. Add the following fields from the Country table to the Map: Add the Latitude and Longitude fields to Latitude and Longitude boxes in Location on the Visualizations Pane.
3. Add the Units Sold field to the Size box in Location on the Visualization Pane. Format the Bubbles: Size: 25; Data color: #41a4ff, Theme color 1, 20% lighter.
4. Apply the following Filter to the Page to show the following countries: Argentina, China, Mexico, South Africa, Spain, Thailand, United Kingdom.
What is the total Units Sold for the filtered countries?
What is % of the Grand Total for the the filtered countries?
Question 3
In PowerBI:
Add a new page and, if necessary, name it Page 5. On Page 5:
1. Create a new Table Visualization: Add the new measure, Sales in $, to the table visual to show the total Sales in $ for all the dataset. Format the visual: Font: Segoe, Size: 30 pt. Move this visual to the bottom of the page and centre across the page.
What is the total Sales in $ for all the dataset? .
2. Create a new Table Visualization and add it to the top of Page 5. Add the following fields to this table visual: Product Code, Product Description and the new measure, Sales in $. Format the Table Visual: Font: Segoe, Size: 15 pt, Column Headers: 14 pt. Adjust columns as required to show the data fully.
3. Apply the following Filter to this Table Visual only to show the total Sales in $ for the following products with Product Description: Arborio Rice, Brown Rice, Red Rice.
What is the total Sales in $ for the filtered products above?
Question 4
In PowerBI:
Add a new page and, if necessary, name it Page 6. On Page 6: 1. Create a Matrix Visualization. Add the following fields to the Matrix visual: Product Description, Year and Sales in $ (measure). Format the Visual: Font: Segoe, Size: 13 pt, Column Headers: 13 pt. Adjust columns as required to show the data fully. Place the matrix visual in the top half of the page.
2. Create a Clustered Column Chart Visualization. Add the following fields to the Chart visual: Product Description, Year and Sales in $ (measure). Place the chart in the bottom half of the page.
3. Apply the following Advanced Filter criteria to the Matrix and Chart Visuals: Product Description contains Sauce.
What is the total Sales in $ for Sauce C for all years?
What is the total Sales in $ for all Sauces in 2015?
Question 5
In PowerBI:
Add a new page and, if necessary, name it Page 7. On Page 7: 1. Create a new measure name Profit, which multiplies the Sales in $ measure by 62%.
2. Create a Matrix Visualization. Add the following fields to the Matrix visual: Country, Year and Profit (measure). Format the Visual: Font: Segoe, Size: 14 pt, Row and Column Headers: 13 pt. Adjust columns as required to show the data fully.
What is the total Profit for all Countries for all years?
What is the total Profit for Australia for the Year 2019?
