Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete each of the following steps. For each visual, provide the Power BI file showing that each of the required elements has been included. Use

Complete each of the following steps. For each visual, provide the Power BI file showing that each of the required elements has been included. Use appropriate colors, labels, and formatting to enhance the visual.
Show total sales by country for 2018 in a bar chart. Add the sales total above each bar. Create a tooltip that shows units sold when you hover over each country's bar.
Create a new visual that shows gross sales and profit by segment for 2019.
Create a new column "Profit per Unit" using the profit and units sold measures. Create a visual showing profit per unit by product. Add a line to the chart that shows average profit per unit.
Using the manufacturing data, create a stacked column chart showing the units manufactured and defective units by product. Make sure that the y-axis shows as a percentage and not a raw number. Ensure that your visual uses color to differentiate between units manufactured and defective units and that defective units are at the top of the stacked columns. Create a tooltip that shows the number of units manufactured when you hover over each product.
Create a fifth visual showing a business relationship of interest to you. Ensure the visual effectively presents the relationship you chose to highlight.

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

Operations Management

Authors: R. Dan Reid, Nada R. Sanders

4th edition

9780470556702, 470325046, 470556706, 978-0470325049

More Books

Students also viewed these General Management questions

Question

How would you respond to each of the girls?

Answered: 1 week ago

Question

Why do women demand and men withdraw?

Answered: 1 week ago