Question 1
In PowerBI:
1. 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. Enter yes, if completed
Question 2
In PowerBI:
1. 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. Enter Yes, if completed
Question 3
In PowerBI:
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.
2. Clustered Column Chart Visualization. Add the following fields to the chart: Country and Units Sold. Format the Data color: #a8337d Theme color 5, 25% darker. Enter yes, if completed.
What is the total Units Sold for all countries?
3. Apply the following Filter to the Page to show the values for the following countries only: Germany, Mexico, Thailand, United Kingdom. Enter yes, if completed.
4. Change the name of Page 1 to your First Name, e.g. Maria
What is the total Units Sold for the 4 countries?
What is % of the Grand Total for the 4 countries?
Which of the 4 countries has the highest total Units Sold? What is this number?
Which of the 4 countries has the lowest total Units Sold? What is this number?
Question 4
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.
2. Clustered Bar Chart Visualization. Add the following fields to the chart: Product Code and Units Sold. Format the Data color: #a0a7d8, Theme color 2, 60% lighter. Enter yes, if completed.
3. Apply the following Filter to the Page to show the following products: PC1429, PG4152, PO2382, PZ2297. Enter yes, if completed.
What is the total Units Sold for the 4 products?
What is % of the Grand Total for the 4 products?
Which of the 4 products (Product code) has the highest total Units Sold? What is this number?
Which of the 4 products (Product code) has the lowest total Units Sold?
What is this number?