data visualization using tableau|Legit essays

Posted: February 27th, 2023

HW – 3

[ Team] project:

Deadlines from 1 hour
Get A+ help
with any paper

 

Requirements:

(1) provide short answer to each of the following questions

(2) if possible, provide proper charts/tables that can support your arguments in each question

(3) ensure the measures used in your visual are good fit to answer the question, especially the LOD of you chart/table fits the question/answer.

 

Questions:

1. Describe the dataset:

Data type of each column: categorical or quantitative (dimension or measure in Tableau terms)

Are there hierarchical variable structures? If yes, what are they?

What is the entity that each row represents, and LOD?

2. Given these categorical and quantitative variables, would you be able to answer the following questions by analyzing the dataset? Explain your answer.

Example:

Question: Is the company profit growing overtime?

Exemplar Yes answer:

Yes. This question can be answered by analyzing the given data. To answer this question, required data include sum of sales profit over time. The dataset provides the variable of sales profit and order date, which is sufficient to answer this question. Following is a chart to support our answer.

Chart, line chart  Description automatically generated

Exemplar No answer:

No. This question cannot be answered by analyzing the given data. To answer this question, required data include sum of sales profit over time. The dataset does not have the profit variable and it is not inferable from any existing variables.

 

Your questions:

* Are stores the coastal areas have a higher profit than the inland areas?

* What are the products having the highest and lowest average profit?

* What products are usually purchased in multiple units?

* What products or categories are frequently shipped late?

* What areas are frequently having orders shipped late?

* What the branch offices/areas have relatively high cost?

* What the branch offices/areas have relatively high operation cost?

 

3. Visualize the company’s financial performance:

* Make line chart on top of bar chart to show sum profits on top of sum sales. A bar represent a state.

* Make line chart on top of bar chart to show sum profits on top of sum sales. A bar represent a month. It must show all the months over all available years.

 

* Use Map to show states of US. On each state, show average orders quantity (use size to code it) and order profits (use color to code it) for the state. If the average order profit is negative, use the red color family else use green color family to show it. Required filters:

(a) By customer segment

(b) By product categories

(c) By region

 

Optional question (You don’t have to do it. Good work here can compensate you for any points you lost in previous questions)

Explore the data and find evidence for root causes of some states losing money.

Hints: (1) comparing top/bottom 3 states (2) make a theory (reasonable guess) about causes of losing money. (3) study the variables, visualize, and keep digging towards finding evidence to prove your theory.

 

SOLUTION

  1. Describe the dataset: Data type of each column: The dataset contains both categorical and quantitative variables. Categorical variables include customer name, region, product category, and order priority, while quantitative variables include order date, order quantity, sales, profit, and shipping cost. Hierarchical variable structures: Yes, there are hierarchical variable structures. For example, region is a higher-level variable that contains individual states. Entity represented in each row and LOD: Each row in the dataset represents an individual order with details such as the customer name, order date, product, quantity, sales, profit, and shipping cost. The LOD is at the order level.

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00