Tableau Dashboard Activity 16-1 (Static)

Required information Tableau Dashboard Activity 16-1 (Static) [The following information applies to the questions displayed below.] This exercise provides a total of 13 data visualizations that describe a real company's 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. Tableau Dashboard Activity 16-1 (Static) Part 1 Refer to the Sales Analysis Dashboard below and answer the questions. Sales Growth Year/Quarter $60 es (in billions) $40Sales (in billions) Sales (in billions) $60 $40 $20 $60 $40 $0 $20 $0 Y1 - Q1 $22.7 Y1 - Q1 Y2 - Q1 $29.1 Y1 - Q2 Y3 - Q1 $35.7 Quarterly Sales: Year-Over-Year Y1 - Q3 Y4 - Q1 $51.0 Y1 - Q4 Y5 - Q1 $59.7 Y2 - Q1 Y1 - Q2 $23.2 Y2 - Q2 Y2 - Q2 $30.4 Y2 - Q3 Y3 - Q2 $38.0 Y2 - Q4 Y4 - Q2 $52.9 Y3 - Q1 Year/Quarter Year/Quarter Y1 - Q3 $25.4 Y3 - Q2 Y2 - Q3 $32.7 Y3 - Q3 Y3 - Q3 $43.7 Y3 - Q4 Y4 - Q3 $56.6 Y4 - Q.. Y1 - Q4 $35.7 Y4 - Q2 Y2 - Q4 $43.7 Y4 - Q3 Y3 - Q4 $60.5 Y4 - Q4 Y4 - Q4 $72.4 Y5 - ..+ + Year-Over-Year Sales Growth 40.0% 20.0% 0.0% ? tableau Y2 - Q1 28.2% Y3 - Q1 22.6% Y4 - Q. 42.9% Quarterly Sales Growth Rate: Year-Over-Year Y5 - .. 17.0% boxes left with a question mark will be automatically graded as incorrect.) Y2 -.. 31.1% Y3 - Q2 24.8% 1a-1. Which of the following statements are true with respect to Visualization 1: Sales Growth? Y4 - Q.. 39.3% Year/Quarter Y2 - Q3 29.0% - Y3 -.. 33.7% 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 (Note that for all questions below you may select more than one answer. Single click the box with the question mark to produce V consecutively through the first quarter of year 5. Y4 - Q3 29.3% It provides a trend analysis of the quarterly sales growth rate percentages beginning with the first quarter of year 1 and running Y2 -.. 22.4% Y3 - Q4 38.2% Y4 - Q.. 19.7%a It provides a trend analysis of the quarterly sales growth rate percentages beginning with the rst quarter of year 1 and running consecutively through the rst quarter of year 5. a It depicts each quarter's total sales on a year-overyear basis beginning with quarter1 of years 1-4 and ending with quarter 4 of years 1-4. a It provides a trend analysis of quarterly sales beginning with the rst quarter of year1 and running consecutively through the rst quarter of year 5. 13-2. Which of the following statements are true with respect to Visualization 2: Quarterly Sales: Year-Over-Year? a It provides a trend analysis of the quarterly sales growth rate percentages beginning with the rst quarter of year 1 and running consecutively through the fourth quarter of year 4. a It depicts each quarter's total sales on a year-overyear basis beginning with quarter1 of years 1-5 and ending with quarter 4 of years 1-4. a It provides a trend analysis of quarterly sales beginning with the rst quarter of year1 and running consecutively through the rst quarter of year 5. 13-3. Which of the following statements are true with respect to Visualization 3: Quarterly Sales Growth Rate: Year-OverYear? a It depicts quarterly sales growth rate percentages on a yearoveryear basis beginning with the first quarter of years 25 and ending with the fourth quarter of years 24 a It depicts each quarter's total sales on a year-overyear basis beginning with quarter1 of years 1-4 and ending with quarter 4 of years 1-4. a It provides a trend analysis of quarterly sales beginning with the rst quarter of year 1 and running consecutively through the rst quarter of year 5. 1b-1. Which of the following statements are true with respect to Visualization 1: Sales Growth? 9 The company has a seasonal sales pattern because sales always spike in the second and third quarters of each year. a The company's sales have been steadily increasing from less than $25 billion in the first quarter of year 1 to almost $60 billion by the first quarter of year 5. a The company has a seasonal sales pattern because sales always spike in the fourth quarter of each year. 1b-2. Which of the following statements are true with respect to Visualization 2: Quarterly Sales: YearOverYear? a The company's sales within all four quarters have steadily grown over time. a Each year's second quarter sales are always greater than its rst quarter sales. a Each year's third quarter sales are always greater than its second quarter sales. a Each year's third quarter sales are always greater than its second quarter sales. 1b-3. Which of the following statements are true with respect to Visualization 3: Quarterly Sales Growth Rate: YearOverYear? a The fourth quarter sales in year 3 were 38.2% higher than the same quarter in the prior year. a The third quarter sales in year 3 were 33.7% higher than the second quarter sales in year 3. a The sales growth rate has not steadily increased over time in any of the four quarters. 1c. Which of the following statements are true with respect to the three visualizations contained in the Sales Analysis Dashboard? a The rst visualization highlights the seasonal nature of the company's business, but it does not explicitly depict trends in each quarter's sales on a yearoveryear basis. a The second visualization shows trends in each quarter's sales from one year to the next; however, it does not explicitly highlight trends in the sales growth rate. a The third visualization highlights trends in each quarter's sales growth rate on a yearoveryear basis