CASE STUDY $-$ Using Files as a Data Source

As a Data Analyst in Adventure works, you will be using power BI to create reports that the business analysts can use to create dashboard in the power BI service. One of the business analysts has asked you to use excel files as the data source for the report

The tasks to be completed:

$1.$ Reduce the size of the Excel file by formatting it

$2.$ Change the cell style to normal

$3.$ Convert the cells into table

$4.$ Import Adventure Sales excel file into Power BI Desktop

$5.$ Convert the OrderDate, DueDate and ShipDate to a Date type in Power BI Desktop

$6.$ Convert the StandardCost, SalesAmount, TaxAmt to the US Dollar Currency type

$7.$ Load Sales table into Power BI Desktop

$8.$ Create a Column chart of SalesAmount vsSalesTerritoryGroup

$9.$ Create a Map Visual with SalesTerritoryCountry and SalesAmount

$10.$ Display the Top $10$ products based on the salesAmount

$11.$ Show the product distribution based on category using a pie chart

$12.$ Save the Report as Adventure Works Excel

please perform with screen shots in power bi