Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a dashboard from the data file. The dashboard should consist of at least 3 (sets of) graphs which provide a coherent set of information.

Create a dashboard from the data file. The dashboard should consist of at least 3 (sets of) graphs which provide a coherent set of information. (30 marks) (Hint: you should design a dashboard to address a single business question / facilitate a business decision. Think about what question / decision you want to provide information for, then locate the necessary information from the data file to create the dashboard.)image text in transcribed

Data Element Order ID Order Date Ship Date Ship Mode Customer ID Description Unique identifier of each order Date the order is received Date the order is shipped Shipping services requested by the customer Unique identifier of each customer Complete name of customer Segment the customer belongs to Region the customer is located at Market the area belongs to Unique identifier of each product Customer Name Segment Region Market Product ID Category Category of the product Sub-category Sales Detailed category of the product Sales revenue in dollars Number of products ordered in pallets Sales discount and settlement discount given to the customer Quantity Discount Profit Profit of the item in dollars Shipping Cost Shipping cost in dollars Order Priority Internal priority of processing the order Data Element Order ID Order Date Ship Date Ship Mode Customer ID Description Unique identifier of each order Date the order is received Date the order is shipped Shipping services requested by the customer Unique identifier of each customer Complete name of customer Segment the customer belongs to Region the customer is located at Market the area belongs to Unique identifier of each product Customer Name Segment Region Market Product ID Category Category of the product Sub-category Sales Detailed category of the product Sales revenue in dollars Number of products ordered in pallets Sales discount and settlement discount given to the customer Quantity Discount Profit Profit of the item in dollars Shipping Cost Shipping cost in dollars Order Priority Internal priority of processing the order

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_2

Step: 3

blur-text-image_3

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

The Curriculum Management Audit

Authors: Larry E. Frase, Fenwick W. English, William K. Poston

1st Edition

0810839318, 9780810839311

More Books

Students also viewed these Accounting questions

Question

1. Define and explain culture and its impact on your communication

Answered: 1 week ago