Answered step by step
Verified Expert Solution
Link Copied!

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:
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2017 For Windows Web And Database Applications

Authors: Corinne Hoisington

1st Edition

1337102113, 978-1337102117

More Books

Students also viewed these Databases questions