Creating a Dashboard in Power BI Presentation

docx

School

Grand Canyon University *

*We aren’t endorsed by this school

Course

MIS 655

Subject

Information Systems

Date

May 2, 2024

Type

docx

Pages

Uploaded by ProfInternet10544

Creating a Dashboard in Power BI Presentation Bryan Howard Colangelo College of Business, Grand Canyon University MIS-620: Descriptive and Diagnostic Analytics Dr. Andrew Madson October 8,2023

Part 1 Below is reference to the completed Power BI module.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Part 2 Below is a screenshot of total sales by country for 2018 with a tooltip that shows units sold of that country. Tooltip will not save on screenshots. This is a screenshot of gross sales by profit for each segment in 2019.

Here is a screenshot of profit per unit by product, with the average profit per unit line. This stacked column chart shows the units manufactured and defective units by product.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Below is a chart that shows the breakdown of discounts against profits for each product in each segment. Part 3 According to the charts requested, the segment with the highest sales in 2019 was the Government segment, and this segment also had the highest profit. Unfortunately, the Enterprise segment had a negative figure for profit. Based on the charts above, the Paseo product was the only product with an above average profit per unit. These charts also reflect a percent defective per product, and it appears the Paseo has the highest percent, but there needs more investigation or more info added to the chart. Conversely, the Amarilla has the lowest percent of defective pieces manufactured. Investigating the negative profits, it is apparent that there is a relationship between profits per segment and discounts per segment. It appeared to be a product; however, the loss is in every product for the Enterprise segment. It is recommended to limit the discounts given to the Enterprise segment or look into the sales to see why there are more discounts than any other segment.

Creating a Dashboard in Power BI Presentation

Related Documents