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 4 Refer to the Profitability Analysis Dashboard below and answer the questions.Net Income (in billions) 6.0% 4.0% 2.0% 0.0% $2 $3 $0 Y1 - Q1 Y1 - Q1 Y1 - Q2 Net Income Growth Y1 - Q2 Return on Equity (ROE) Y1 - Q3 Y1 - Q3 Net Profit Margin Percentage Y1 - Q4 Y1 - Q4 Y2 - Q1 Y2 - Q1 Y2 - Q2 Y2 - Q2 Y2 - Q3 Y2 - Q3 Y2 - Q4 Y2 - Q4 Y3 - Q1 Year/Quarter Year/Quarter Y3 - Q1 Y3 - Q2 Y3 - Q2 Y3 - Q3 Y3 - Q3 Y3 - Q4 Y3 - Q4 Y4 - Q1 Y4 - Q1 Y4 - Q2 Y4 - Q2 Y4- Q3 Y4 - Q3 Y4 - Q4 Y4 - Q4 Y5 - Q1 Y5 - Q1Return on Equity (ROE) Year/Quarter 30.0% 26.7% 27.0% 283% 21.1% 20.0% 13.5% 13.5% 13.9% 117% 12.5% 14.7% 8.9% 9.4% 8.7% 100% 4.9% 00% - I : Il N m - N N N N m m m m . >. >. >. >. >. >. >. >. >. >. >. >, a N m _ ul ul N N N N m m m m - >- >- >- >- >- >- >- >- >- >- >- >- The rst bar in this chart is computed by summing the net incomes earned during the four quarters of year 1 and then dividing this cumulative net income by the average stockholders' equity during those same four quarters. Each subsequent bar in the chart rolls forward one quarter at a time. So, for example, the second bar sums the four quarterly net incomes from the second quarter of year 1 through the rst quarter of year 2. It then divides this cumulative net income by the average stockholders' equity during those same four quarters. i++ableau 6 9 d>v l6 egg L? ED: (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.) 4a-1. Which of the following statements are true with respect to Visualization 1: Net Income Growth? ? It provides a trend analysis of quarterly net income as a percent of sales beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. ? It provides a trend analysis of quarterly net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. ? It provides a trend analysis of quarterly net income as a percent of stockholders' equity beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. 4a-2. Which of the following statements are true with respect to Visualization 2: Net Profit Margin Percentage? ? It provides a trend analysis of quarterly net income as a percent of sales beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. ? It provides a trend analysis of quarterly net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. ? It provides a trend analysis of quarterly net income as a percent of stockholders' equity beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. 4a-3. Which of the following statements are true with respect to Visualization 3: Return on Equity (ROE)? ? It provides a trend analysis of quarterly net income as a percent of sales beainnina with the first quarter of vear 1 and runnina? It provides a trend analysis of quarterly net income as a percent of sales beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. ? It provides a trend analysis of quarterly net income beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. ? It provides a trend analysis of quarterly net income as a percent of stockholders' equity beginning with the first quarter of year 1 and running consecutively through the first quarter of year 5. 4b-1. Which of the following statements are true with respect to Visualization 1: Net Income Growth? ? The net income never exceeded $1 billion between the first quarter of year 1 and the third quarter of year 3. ? The net income increased every quarter from the fourth quarter of year 3 until the first quarter of year 5. ? The net income hit its highest peak during the 17-month span during the first quarter of year 5. 4b-2. Which of the following statements are true with respect to Visualization 2: Net Profit Margin Percentage? ? The net profit margin percentage never dropped below 2% between the fourth quarter of year 3 and the first quarter of year 5.a The net profit margin percentage dropped from the second quarter of year 2 to the third quarter ofyear 2. a The net profit margin percentage never exceeded 2% between the first quarter of year1 and the third quarter of year 3. 4b-3. Which of the following statements are true with respect to Visualization 3: Return on Equity (ROE)? a The return on equity ranges from 4.9% to 28.9%. a The return on equity is higher towards the end of the 17quarter time period than it is at the beginning of this time period. a The return on equity has increased every quarter from the beginning to the end of the 17-quarter period depicted in the chart. 4c. Which of the following statements are true with respect to the three visualizations contained in the Profitability Analysis Dashboard? a A trend analysis of net income growth and net profit margin percentage reveal that the two measures have been moving in opposite directions over the course of the 17quarter period. a The third visualization is the only one of the three that looks at net income relative to the owners' investment. 4:. Which of the following statements are true with respect to the three visualizations contained in the Profitability Analysis Dashboard? a A trend analysis of net income growth and net profit margin percentage reveal that the two measures have been moving in opposite directions over the course of the 17quarter period. a The third visualization is the only one of the three that looks at net income relative to the owners' investment. 9 All three visualizations indicate improving performance from the third quarter of year 3 through the rst quarter of year 5