COURSE 3: GO BEYOND THE NUMBERS: TRANSLATE DATA INTO INSIGHTS

Module 4: Data Visualizations and Presentations

GOOGLE ADVANCED DATA ANALYTICS PROFESSIONAL CERTIFICATE

Complete Coursera Study Guide

INTRODUCTION – Data Visualizations and Presentations

This course segment focuses on refining your skills in creating and presenting data stories ethically, accessibly, and professionally. You’ll explore advanced data visualization techniques using Tableau, enhancing your ability to craft compelling and impactful visuals. The emphasis is on responsible data presentation, considering ethical considerations and ensuring transparency, while also delving into the sophisticated features of Tableau for more dynamic storytelling. By the end, you’ll be equipped to convey insights with precision and professionalism in the ever-evolving landscape of data analysis.

Learning Objectives

  • Create dynamic visualizations with Tableau while using interactive and motion elements
  • Use data visualizations to explain technical concepts to non-technical audiences
  • Alter data visualizations to fit different audiences needs with regard to the overall story
  • Create visualizations with Tableau that share the story of a dataset
  • Recognize the importance of being ethically true to dataset in data visualizations
  • Identify techniques for making accessible dashboards, decks, and charts with Tableau

PRACTICE QUIZ: TEST YOUR KNOWLEDGE: PRESENT A STORY

1. Fill in the blank: In Tableau, qualitative data values called _____ are used to categorize and group data to reveal details about it.

  • dimensions (CORRECT)
  • aggregates
  • comparisons
  • measures

Correct: Qualitative data values called dimensions are used to categorize and group data to reveal details about it.

2. What does the term continuous indicate in data analytics?

  • A measure or dimension will continuously reduce until it reaches zero.
  • A measure or dimension has a finite and countable number of outcomes.
  • A measure or dimension is continuously growing at an exponential rate.
  • A measure or dimension has an infinite and uncountable number of outcomes. (CORRECT)

Correct: The term continuous is a mathematical concept indicating that a measure or dimension has an infinite and uncountable number of outcomes. 

PRACTICE QUIZ: ACTIVITY: DESIGN A BAR GRAPH THAT TELLS A STORY IN TABLEAU PUBLIC

1. Did you complete this activity?

  • Yes (CORRECT)
  • No

Correct: Thank you for completing this activity! Plotting data visualizations is a valuable skill for data professionals because it is the most impactful and engaging way to tell the story of data. Review the quiz question feedback to find out how you did. Then go to the next course item to compare your work to a completed exemplar.

2. In order to structure the data to show only the most relevant details based on the business need, which of the following should your visualization include? Select all that apply.

  • Data for the hours of 5:00 p.m. to 8:00 a.m.
  • Data for the year 2018 (CORRECT)
  • Data for all weekdays (CORRECT)
  • Data for the hours of 8:00 a.m. to 5:00 p.m. (CORRECT)

Correct: The director asked you to analyze the rented bicycle data they gathered in 2018. They also wanted to analyze data during the hours of 8 a.m. to 5 p.m. on weekdays.

Correct: The director asked you to determine the hour bike rentals are lowest during the hours of 8 a.m. to 5 p.m. on weekdays in 2018.

3. What are some goals of how you use color, contrast, labeling, and emphasis elements in the data visualization? Select all that apply.

  • Present all of the available data.
  • Meet accessibility standards. (CORRECT)
  • Help the audience understand important information on the chart. (CORRECT)
  • Include the colors of the company requested for the visualization. (CORRECT)

Correct: Color and contrast should be used to ensure that all members of the audience, including people with color blindness, can still perceive the difference in the bars’ contrast. The visualization should also include the colors the company requested and help the audience understand the data.

Correct: The data visualization should include color, contrast, labeling, and emphasis elements that draw attention to the most relevant data. The visualization should also meet accessibility standards and include the colors the company requested.

Correct: The visualization should include gradients of orange, which are the colors the company requested for the visualization. The visualization should also meet accessibility standards and help the audience understand the data.

PRACTICE QUIZ: ACTIVITY: BUILD AN INTERACTIVE DASHBOARD IN TABLEAU PUBLIC

1. Did you complete this activity?

  • Yes (CORRECT)
  • No

Correct: Thank you for completing this activity! Dynamic dashboards in Tableau are valuable for data professionals because they can condense vast amounts of data into easy-to-access pieces. Review the quiz question feedback to find out how you did. Then go to the next course item to compare your work to a completed exemplar.

2. The dashboard you built divides the data into two bar graphs. What do each of the bar graphs illustrate? Select two answers.

  • The data by dates for each holiday
  •  The data by dates for each weekend day
  • The data divided by dates for each day of the week (CORRECT)
  • The data divided by dates and months (CORRECT)

Correct: The Weekday bar graph is divided into dates for each day of the week, and the Adjacent Day bar graph is divided into dates and months.

3. Which design elements help you showcase relevant information in your dashboard? Select all that apply.

  • Portrait format
  • Contrasting colors (CORRECT)
  • Filters (CORRECT)
  • Titles (CORRECT)

Correct: Using contrasting colors ensures that all members of the audience can still clearly perceive the difference in the bars’ contrast. Giving each worksheet a unique title and creating useful filters can also help highlight relevant information in your dashboard.

Correct: Creating relevant and useful filters in the sidebar helps eliminate clutter in the dashboard tab. Giving each worksheet a unique title and using contrasting colors can also help identify and highlight relevant information in your dashboard.

Correct: Titling each worksheet helps ensure that they are easily discernible in the dashboard. Creating useful filters and using contrasting colors can also help highlight relevant information in your dashboard.

PRACTICE QUIZ: TEST YOUR KNOWLEDGE: ADVANCED TABLEAU

1. A histogram is a data visualization that depicts a precise representation of the distribution of values in a dataset.

  • True
  • False (CORRECT)

Correct:  A histogram is a data visualization that depicts an approximate representation of the distribution of values in a dataset.  

2. Which Tableau tool enables users to interact with data visualizations or dashboards by giving them control of a selection?

  • Bin
  • Action (CORRECT)
  • Set
  • Blending

Correct: An action is a Tableau tool that enables users to interact with data visualizations or dashboards by giving them control of a selection.

3. A data professional wants to visualize data in a time series. Which approach should they take?

  • Generic-to-specific
  • Specific-to-generic
  • Chronological (CORRECT)
  • Systemized

Correct: They should take a chronological approach, which is useful for data that is best understood as a time series

QUIZ: MODULE 4 CHALLENGE

1. Which of the following statements correctly describe dimensions and measures in Tableau? Select all that apply.

  • Dimensions are numeric values that can be aggregated or placed in calculations.
  • Measures are qualitative data values used to categorize and group data.
  • Dimensions are qualitative data values used to categorize and group data. (CORRECT)
  • Measures are numeric values that can be aggregated or placed in calculations. (CORRECT)

Correct!

2. Fill in the blank: The term _____ is a mathematical concept indicating that a measure or dimension has a finite and countable number of outcomes.

  • radical
  • discrete (CORRECT)
  • ordinal
  • continuous

Correct!

3. In Tableau, what feature enables the creation of data value groupings in a histogram?

  • Bins (CORRECT)
  • Plots
  • Sorts
  • Joins

Correct!

4. A data professional at a lumber supplier creates a presentation for stakeholders about how environmental conditions affect tree growth. They first focus on growth patterns in 20 counties. Then, they share broader insights about growth nationwide. What type of approach to data visualization does this scenario describe?

  • Generic-to-specific
  • Broad
  • Specific-to-generic (CORRECT)
  • Chronological

Correct!

5. A data analytics team at a jewelry designer creates a presentation for stakeholders about supplier sourcing practices. They first share broad insights about suppliers nationwide. Then, they focus on suppliers in particular states and counties. What type of approach to data visualization does this scenario describe?

  • Broad
  • Generic-to-specific (CORRECT)
  • Specific-to-generic
  • Chronological

Correct!

6. A data professional at a shoe retailer creates a presentation for stakeholders about the best-selling sneakers. They share insights about three popular sneaker brand sales, beginning with January and continuing through year end. What type of approach to data visualization does this scenario describe?

  • Generic-to-specific
  • Specific-to-generic
  • Chronological (CORRECT)
  • Fluid

Correct!

7. Fill in the blank: A set in Tableau is a custom field of data created from a _____ based on custom conditions.

  • Dashboard
  • notebook
  • data warehouse
  • larger dataset (CORRECT)

Correct!

8. Fill in the blank: A worksheet in Tableau Public is a data page that contains a _____ view of a data visualization.

  • Duplicated
  • mirrored
  • single (CORRECT)
  • paired

Correct!

9. In Tableau, what feature is used to determine how the data is segmented and compared in a histogram?

  • Joins
  • Filters
  • Sources
  • Bins (CORRECT)

Correct!

10. A data professional at a convention center creates a presentation for stakeholders about the events that take place in their facility. They share insights about meetings over a five-year period, beginning in 2018 and continuing through 2023. What type of approach to data visualization does this scenario describe?

  • Fluid
  • Specific-to-generic
  • Chronological (CORRECT)
  • Generic-to-specific

Correct!

11. Fill in the blank: A _____ in Tableau is a custom field of data created from a larger dataset based on custom conditions.

  • Set (CORRECT)
  • worksheet
  • trend line
  • custom view

Correct!

12. Fill in the blank: A _____ in Tableau Public is a data page that contains a single view of a data visualization.

  • Bin
  • Worksheet (CORRECT)
  • source
  • field

Correct!

13. Which of the following statements correctly describe dimensions and measures in Tableau? Select all that apply.

  • Dimensions can be aggregated or placed in calculations.
  • Dimensions are used to categorize and group data. (CORRECT)
  • Measures are numeric values. (CORRECT)
  • Dimensions are qualitative data values. (CORRECT)

Correct!

14. Fill in the blank: The term _____ is a mathematical concept indicating that a measure or dimension has an infinite and uncountable number of outcomes.

  • factorial
  • discrete
  • continuous (CORRECT)
  • operative

Correct!

15. In Tableau, what are the custom segments of data that create the groups of values used in a histogram?

  • Bins (CORRECT)
  • Worksheets
  • Fields
  • Filters

Correct!

16. A data analytics team at a beverage company creates a presentation for stakeholders about juice sales. They first focus on sales in 15 cities. Then, they share broader insights about sales throughout the state. What type of approach to data visualization does this scenario describe?

  • Specific-to-generic (CORRECT)
  • Descriptive
  • Generic-to-specific
  • Chronological

Correct! 

17. Fill in the blank: A set in Tableau is a custom _____ created from a larger dataset based on custom conditions.

  • heat map
  • workbook
  • field of data (CORRECT)
  • plot

Correct!

18. Fill in the blank: A continuous dimension has an infinite number of outcomes, whereas the _____ dimension has a finite number of outcomes.

  • Measureless
  • connected
  • discrete (CORRECT)
  • perpetual

Correct!

19. Fill in the blank: A worksheet in Tableau Public is a data page that contains a _____ in a single view.

  • Dashboard
  • data visualization (CORRECT)
  • bin
  • dataset

Correct!

20. Which of the following statements correctly describe dimensions and measures in Tableau? Select all that apply.

  • Dimensions can be aggregated or placed in calculations.
  • Measures are qualitative data values.
  • Measures can be aggregated or placed in calculations. (CORRECT)
  • Measures are numeric values. (CORRECT)

Correct!

21. A data professional at a restaurant distributor creates a presentation for stakeholders about delivery efficiency. They first share broad insights about delivery speeds nationwide. Then, they focus on particular states and counties. What type of approach to data visualization does this scenario describe?

  • Chronological
  • Generic-to-specific (CORRECT)
  • Broad
  • Specific-to-generic

Correct!

22. A data analytics team at a music venue creates a presentation for stakeholders about merchandise sales. They first focus on average t-shirt purchases at five particular venues. Then, they share broader insights about purchases across all their venues. What type of approach to data visualization does this scenario describe?

  • Fluid
  • Generic-to-specific
  • Specific-to-generic (CORRECT)
  • Chronological

Correct!

23. A data analytics team working for a party planner creates a presentation for stakeholders about food and beverage needs. They share data about parties six months ago through to the present day. What type of approach to data visualization does this scenario describe?

  • Generic-to-specific
  • Specific-to-generic
  • Fluid
  • Chronological (CORRECT)

Correct!

24. A data professional working for an automotive company creates a presentation for stakeholders about vehicle repair efficiency. They first share broad insights about repair performance nationwide. Then, they focus on particular states and counties. What type of approach to data visualization does this scenario describe?

  • Specific-to-generic
  • Broad
  • Chronological
  • Generic-to-specific (CORRECT)

Correct!