# Question 2 In the table Dataset: Create a new column named % of Grand Total by u

Question 2
In the table Dataset: Create a new column named % of Grand Total by u

Question 2
In the table Dataset: Create a new column named % of Grand Total by using the appropriate Expression to divide the Total Units by the SUM of the Total Units. Format the new column as percentage, 2 decimals.
Question 3
Create a new measure, named Sales in \$, which multiplies the Units Sold, from the Dataset table, with the Unit Price, from the related Product table. Format this new measure as Currency, 0 decimals.
Question 4
Create a new Report.
On Page 1, 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. Enter yes, if completed.Blank 1
2. Clustered Column Chart Visualization. Add the following fields to the chart: Country and Units Sold. Format the Data color: #09124f, Theme color 2, 50% darker. Enter yes, if completed.Blank 2
What is the total Units Sold for all countries?Blank 3
3. Apply the following Filter to the Page to show the values for the following countries only: Canada, South Africa, South Korea, Spain. Enter Yes, if completed. Blank 4
4.Change the name of Page 1 to your First Name, e.g. Maria
What is the total Units Sold for the 4 countries?Blank 5
What is % of the Grand Total for the 4 countries?Blank 6
Which of the 4 countries has the highest total Units Sold?Blank 7 What is this number? Blank 8
Which of the 4 countries has the lowest total Units Sold?Blank 9 What is this number? Blank 10
Question 5
In PowerBI:
On Page 2, create the following visualizations:
1. Table Visualization: Add the following fields to the table: Product Code, Description, 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. Enter yes, if completed.Blank 1
2. Clustered Bar Chart Visualization. Add the following fields to the chart: Product Code and Units Sold. Format the Data color: #de6a73, Theme color 8, 20% lighter. Enter yes, if completed.Blank 2
3. Apply the following Filter to the Page to show the following products only: PY4206, RP8912, PN1906, PZ2297. Enter yes, if completed.Blank 3
What is the total Units Sold for the 4 products?Blank 4
What is % of the Grand Total for the 4 products?Blank 5
Which of the 4 products (Product Code) has the highest total Units Sold?Blank 6 What is this number? Blank 7
Which of the 4 products (Product Code) has the lowest total Units Sold?Blank 8 What is this number? Blank 9
Question 6
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. Enter yes, if completed.Blank 1
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 your First and Last Name. Enter yes, if completed.Blank 2
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. Enter yes, if completed.Blank 3
What is the total Units Sold for the 3 years?Blank 4
What is % of the Grand Total for the 3 years?Blank 5
Which of the 3 years has the highest total Units Sold?Blank 6 What is this number? Blank 7
Which of the 3 years has the lowest total Units Sold?Blank 8 What is this number? Blank 9
Question 7
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. Enter yes, if completed.Blank 1
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. Enter yes, if completed.Blank 2
3. Add the Units Sold field to the Size box in Location on the Visualization Pane. Format the Bubbles: Size: 15; Data color: #893395 Theme color 4, 20% lighter. Enter yes, if completed.Blank 3
4. Apply the following Filter to the Page to show the following countries: Australia, Brazil, Canada, France, Mexico, South Africa, South Korea, Thailand. Enter yes, if completed.Blank 4
What is the total Units Sold for the filtered countries?Blank 5
What is % of the Grand Total for the the filtered countries?Blank 6
Question 8
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. Enter Yes if completed Blank 1
.What is the total Sales in \$ for all the dataset?Blank 2
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.
Enter Yes, if completed Blank 3
.3. Apply the following Filter to this Table Visual only to show the total Sales in \$ for the following products with Product Description: Spaghetti Sauce D, Spaghetti Sauce E, Spaghetti Sauce F.
Enter Yes, if completed.Blank 4
What is the total Sales in \$ for the filtered products above?Blank 5
Question 9
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.
Enter Yes, if completed Blank 1
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.
Enter Yes, if completed Blank 2
3. Apply the following Advanced Filter criteria to the Matrix and Chart Visuals: Product Description contains Cheese.
Enter Yes, if completed.Blank 3
What is the total Sales in \$ for Brie Cheese for all years?Blank 4
What is the total Sales in \$ for all Cheeses in 2018?Blank 5
Question 10
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 57.5%. Blank 1
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.
Enter Yes, if completed Blank 2
What is the total Profit for all Countries for all years?Blank 3
What is the total Profit for South Africa for the Year 2016?Blank 4

The post Question 2
In the table Dataset: Create a new column named % of Grand Total by u appeared first on Accomplished Paper Tutors.