You must make a Power BI file using the uploaded Excel data
1- Create a new measure named Sales Tax by using the appropriate Expression to multiply the Sold Price from the Inventory table by the State Tax from the related Location table. Format Sales Tax as a whole number, 0 decimal.
2- Create a new measure named Gain/Loss by using the appropriate Expression to subract the SUM of the Sold Price from the SUM of the List Price. Format Gain/Loss as a whole number, 0 decimal.
3- In PowerBI:
Create a new Report.
On Page 1, create the following visualizations:
a) Table Visualization: Add the following fields and measure to the table visual: Model Year, Sold Price, Sales Tax. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show all data. Enter yes, if completed.
b) Clustered Column Chart Visualization. Add the following fields to the chart: Model Year, Sold Price, Sales Tax. Format the Sold Price Data color: #41a4ff, Theme color 1, 20% lighter. Enter yes, if completed.
c) Apply the following Advanced Filter to the Page to show data for Model Years Between 2005 and 2015 (inclusive). Enter yes, if completed.
Rename Page 1 your First and Last Name, for example John Brown.
What is the total Sold Price for the filtered Model Years?
What is the total Sales Tax for the filtered Model Years?
4- In PowerBI:
Add a new Page to the Report.
On Page 2, create the following visualizations:
a) Table Visualization: Add the following fields and measure to the table visual: Location ID, Sold Price, Sales Tax. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show all data. Enter yes, if completed.
b) Pie Chart Visualization. Add the following fields to the chart: Location ID, Sold Price. Format the larger slice of the Pie as Data color: #e1c233, Theme color 7, 20% lighter. Enter yes, if completed.
c) Apply the following Filter to the Page to show data for Location ID: LOC01 and LOC02 . Enter yes, if completed.
What is the total Sold Price for the filtered Location ID?
What is the total Sales Tax for the filtered Location ID?
What % of the Pie chart is the larger slice?
5- In PowerBI:
Add a new Page to the Report.
On Page 3, add the following visualizations:
a) Table Visualization: Add the following fields and measure to the table visual: State, Sold Price, Gain/Loss. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show all data. Enter yes, if completed.
Click on the Latitude field in the Location table. On the Column Tool ribbon change the Data Category from Uncategorized to Latitude.
Click on the Longitude field in the Location table. On the Column Tool ribbon change the Data Category from Uncategorized to Longitude.
b) Map Visualization. Add the Latitude and Longitude fields to the Latitude and Longitude boxes in the Location field on Visualizations Pane. Enter yes, if completed.
c) Add the Sold Price field to the Size box in the Location field on the Visualizations Pane. Format the Bubble Size to 10 and Data color #ad5129 Theme color 3 25% darker. Enter yes, if completed
Select the State of Colorado (CO), and Washington (WA), so that only these States show up on the map (adjust the zoom to show the States with less details). What is the combined total Sold Price for the 2 states?