Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CASE STUDY - Using Files as a Data Source As a Data Analyst in Adventure works, you will be using power BI to create reports
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:
Reduce the size of the Excel file by formatting it
Change the cell style to normal
Convert the cells into table
Import Adventure Sales excel file into Power BI Desktop
Convert the OrderDate, DueDate and ShipDate to a Date type in Power BI Desktop
Convert the StandardCost, SalesAmount, TaxAmt to the US Dollar Currency type
Load Sales table into Power BI Desktop
Create a Column chart of SalesAmount vsSalesTerritoryGroup
Create a Map Visual with SalesTerritoryCountry and SalesAmount
Display the Top products based on the salesAmount
Show the product distribution based on category using a pie chart
Save the Report as Adventure Works Excel
please perform with screen shots in power bi
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started