Question: Part 2 Data Visualization and Business Intelligence ( 1 0 points ) ( a ) Create a Location hierarchy using the Customer s [ State

Part 2 Data Visualization and Business Intelligence (10 points)
(a) Create a Location hierarchy using the Customers [State] and [City].
(b) Add a worksheet showing a Map chart of [City] and average quantity purchased ([Product Quantity]).
(c) Create a new calculated field [Revenue] out of [Product Quantity] and [MSRP].
(d) Add a worksheet showing an Area chart of daily revenue.
(e) Add a worksheet showing the distribution of revenue in a table whose columns and rows are states and product names, respectively.
(f) Add [Transaction Date] to Filters and show it.
(g) Create a dashboard using the worksheets you created.
(h) Ensure that changing the filter changes all three sheets on the Dashboard.
(i) Save As: Part 2
(j) Upload to LMS using the link, Exam 4 Data Visualization and BI in Tableau Desktop workbook follow instructions like a data analyst professional

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!