Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

please perform in power bi with screenshots Assignment - Intro to Power BI CASE STUDY - CREATING A REPORT IN POWER BI You work as

please perform in power bi with screenshots
Assignment -Intro to Power BI
CASE STUDY - CREATING A REPORT IN POWER BI
You work as a Power BI developer in leading Software Company. As a BI Professional, you have been asked to explore ways in which Adventure works can empower business and build a report based on the sales
The tasks to be completed
1) Import AdventureWorksDW Database into Power BI Desktop
2) Import FactInternetSales table and other related tables from AdventureWorks Database
3) Create a Column chart of SalesAmount vs. English name of the week
4) Rename the title as Sales by day of the Week and center align it
5) Create a Pie chart with legend as CalendarQuarter and values asSalesAmount
6) Rename the title as Sales by Calendar Quarter and center align
7) In the pie chart, give 1st Quarter Red color, 2nd Quarter blue color, 3rd Quarter yellow and4th Quarter green
8) Create a Map visual with SalesTerritoryCountry and SalesAmount
9) Rename it as sales by country and center align
10) Create a Funnel of CommuteDistance and SalesAmount
11)Rename it as Sales by commute Distance and center align it
12)Save it as Adventure WorksSales

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions