Required information

Skip to question

[The following information applies to the questions displayed below.] This exercise provides a total of 13 data visualizations that describe a real companys performance based on 17 quarters of financial data. The visualizations are grouped into five dashboards that were created in Tableau: (1) sales analysis, (2) gross margin analysis, (3) operating expense analysis, (4) profitability analysis, and (5) market performance analysis. Required: For each section, review the Tableau visualizations and answer the questions.

Refer to the Gross Margin Analysis Dashboard below and answer the questions.

(Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.)

2a-1. Which of the following statements are true with respect to Visualization 1: Gross Margin Percentage: Year-Over-Year?

check all that apply 1

• The four red bars depict the gross margin percentage for quarters 1-4 of year 3.unanswered
• The five blue bars depict the gross margin percentage for the first quarter of years 1-5.unanswered
• The four orange bars depict the gross margin percentage for quarters 1-4 of year 2.unanswered

2a-2. Which of the following statements are true with respect to Visualization 2: Gross Margin Percentage vs. Sales?

check all that apply 2

• It provides a trend analysis of the quarterly gross margin percentage beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered
• It compares gross margin percentage and sales on a year-over-year basis beginning with quarter 1 of years 1-5 and ending with quarter 4 of years 1-4.unanswered
• It provides a trend analysis of the quarterly sales beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5.unanswered

2b-1. Which of the following statements are true with respect to Visualization 1: Gross Margin Percentage: Year-Over-Year?

check all that apply 3

• The gross margin percentage is always highest in quarter 4 of each year.unanswered
• The companys gross margin percentage has increased from 32.2% in the first quarter of year 1 to 43.2% in the first quarter of year 5.unanswered
• It shows that each quarters gross margin percentage has steadily increased over the years.unanswered

2b-2. Which of the following statements are true with respect to Visualization 2: Gross Margin Percentage vs. Sales?

check all that apply 4

• The sales always spike in the fourth quarter.unanswered
• The gross margin percentage always dips in the fourth quarter.unanswered
• The sales and gross margin percentage each achieve their peak in the third quarter of each year.unanswered

2c. Which of the following statements are true with respect to the two visualizations contained in the Gross Margin Analysis Dashboard?

check all that apply 5

• The first visualization provides data regarding the gross margin percentage, but it does not relate these percentages to the trend in sales.unanswered
• The second visualization reveals an interesting pattern with respect to the fourth sales and gross margin percentage.unanswered
• The first visualization provides data regarding trends in sales, but it does not relate these trends to the gross margin percentage.

Sales (in billions) Gross Margin Percentage Gross Margin Percentage $40 09$ 0% 20% 40% 0.0% 20.0% 30.0% 40.0% Y1 - Q1 Y1-01 32.2% Y1-Q2 Y2-Q1 35.2% Y1-Q3 Y3-01 37.2% Gross Margin Percentage vs. Sales Y1-04 Y4-Q1 39.8% Y2-Q1 Gross Margin Percentage: Year-Over-Year Y5-01 43.2% Y2-02 Y1-Q2 34.6% Y2-03 Y2-02 36.9% Y2-04 Y3-02 38.2% a s a m 2 2 3 3 3 3 M M M M 5 Y3 - Q1 Year/Quarter Y4-02 42.1% Year/Quarter Y3-Q2 Y1-Q3 33.9% Y3-Q3 Y2-03 35.0% Y3-04 Y3-03 37.0% Y4-Q1 Y4 - Q3 41.7% Y4 - Q2 Y1-04 31.9% Y4 - Q3 Y2-04 33.8% Y4-04 Y3-04 36.3% Y5 - Q1 Y4 - Q4 38.1%