POWER BI(Business Intelligence) PROJECT 2021

Have to answer these question and save it on the uploaded file.

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.

2. 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.

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.

2. Clustered Column Chart Visualization. Add the following fields to the chart: Country and Units Sold. Format the Data color: #ec8fca, Theme color 5, 40% lighter.

What is the total Units Sold for all countries? ( write these answer in different page, name answer shorts)

3. Apply the following Filter to the Page to show the values for the following countries only: Australia, France, Thailand, USA.

4. Change the name of Page 1 to Habibi.

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? Which of the 4 countries has the lowest total Units Sold? (write these answer in different page, name answer shorts 2)






>>
<<
What our clients say
Daphne Whitby
Daphne Whitby
My homework required that I use Java to produce a programming assignment. I’ve been running up and down with friends and workThank you for  your help 
Arnold M
Arnold M
This site did honor their end of the bargain. I have been searching for a college essay help services for a while, and finally, I found the best of the best.
Regina Smith
Regina Smith
I received my essay early this morning after I had placed an order last night. I was so amazed at how quickly they did my work. The most surprising thing is that I was not asked to pay for extra due to the short notice!! I am a happy student