Answered step by step
Verified Expert Solution
Question
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
Import AdventureWorksDW Database into Power BI Desktop
Import FactInternetSales table and other related tables from AdventureWorks Database
Create a Column chart of SalesAmount vs English name of the week
Rename the title as Sales by day of the Week and center align it
Create a Pie chart with legend as CalendarQuarter and values asSalesAmount
Rename the title as Sales by Calendar Quarter and center align
In the pie chart, give st Quarter Red color, nd Quarter blue color, rd Quarter yellow andth Quarter green
Create a Map visual with SalesTerritoryCountry and SalesAmount
Rename it as sales by country and center align
Create a Funnel of CommuteDistance and SalesAmount
Rename it as Sales by commute Distance and center align it
Save it as Adventure WorksSales
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