6.1.4.Explore visualization considerations - quanganh2001/Google-Data-Analytics-Professional-Certificate-Coursera GitHub Wiki

Pro tips for highlighting key information

Headlines, subtitles, labels, and annotations help you turn your data visualizations into more meaningful displays. After all, you want to invite your audience into your presentation and keep them engaged. When you present a visualization, they should be able to process and understand the information you are trying to share in the first five seconds. This reading will teach you what you can do to engage your audience immediately.

If you already know what headlines, subtitles, labels and annotations do, go to the guidelines and style checks at the end of this reading. If you don’t, these next sections are for you.

Headlines that pop

A headline is a line of words printed in large letters at the top of a visualization to communicate what data is being presented. It is the attention grabber that makes your audience want to read more. Here are some examples:

Check out the chart below. Can you identify what type of data is being represented? Without a headline, it can be hard to figure out what data is being presented. A graph like the one below could be anything from average rents in the tri-city area, to sales of competing products, or daily absences at the local elementary, middle, and high schools.

zu9qBFoIQBmvagRaCCAZTQ_932b75115a474428b32c50ea5c905eb4_Screen-Shot-2021-02-26-at-3 33 05-PM

Turns out, this illustration is showing average rents in the tri-city area. So, let’s add a headline to make that clear to the audience. Adding the headline, “Average Rents in the Tri-City Area” above the line chart instantly informs the audience what it is comparing.

RfxGzS5-SG68Rs0ufohu0w_fa4bf6deaa534606b2fb1f3ccf98baf5_Screen-Shot-2021-02-26-at-3 44 27-PM

Subtitles that clarify

A subtitle supports the headline by adding more context and description. Adding a subtitle will help the audience better understand the details associated with your chart. Typically, the text for subtitles has a smaller font size than the headline.

In the average rents chart, it is unclear from the headline “Average Rents in the Tri-City Area” which cities are being described. There are tri-cities near San Diego, California (Oceanside, Vista, and Carlsbad), tri-cities in the San Francisco Bay Area (Fremont, Newark, and Union City), tri-cities in North Carolina (Raleigh, Durham, and Chapel Hill), and tri-cities in the United Arab Emirates (Dubai, Ajman, and Sharjah).

We are actually reporting the data for the tri-city area near San Diego. So adding “Oceanside, Vista, and Carlsbad” becomes the subtitle in this case. This subtitle enables the audience to quickly identify which cities the data reflects.

zyTy8njIQQuk8vJ4yJEL6g_956f0070c2504191a48b8ee222e28ce2_Screen-Shot-2021-02-26-at-3 46 05-PM

Label that identify

A label in a visualization identifies data in relation to other data. Most commonly, labels in a chart identify what the x-axis and y-axis show. Always make sure you label your axes. We can add “Months (January - June 2020)” for the x-axis and “Average Monthly Rents ($)” for the y-axis in the average rents chart.

4HxZw65dSbG8WcOuXXmx9w_ccfb490a108742319e49cea6dc49a6ee_Screen-Shot-2021-02-26-at-3 50 28-PM

Data can also be labeled directly in a chart instead of through a chart legend. This makes it easier for the audience to understand data points without having to look up symbols or interpret the color coding in a legend.

We can add direct labels in the average rents chart. The audience can then identify the data for Oceanside in yellow, the data for Carlsbad in green, and the data for Vista in blue.

XVOX-a6LQbKTl_muizGy0g_31efd8df7735426c881ae8c6e2324e55_Screen-Shot-2021-02-26-at-3 56 11-PM

Annotations that focus

An annotation briefly explains data or helps focus the audience on a particular aspect of the data in a visualization.

Suppose in the average rents chart that we want the audience to pay attention to the rents at their highs. Annotating the data points representing the highest average rents will help people focus on those values for each city.

ZeR9MSknSdGkfTEpJwnRlg_32364aeca0dc447ba6cd86ee92196a4d_Screen-Shot-2021-02-26-at-4 00 53-PM

Guidelines and pro tips

Refer to the following table for recommended guidelines and style checks for headlines, subtitles, labels, and annotations in your data visualizations. Think of these guidelines as guardrails. Sometimes data visualizations can become too crowded or busy. When this happens, the audience can get confused or distracted by elements that aren’t really necessary. The guidelines will help keep your data visualizations simple, and the style checks will help make your data visualizations more elegant.

Visualization components Guidelines Style checks
Headlines - Content: Briefly describe the data - Length: Usually the width of the data frame - Position: Above the data - Use brief language - Don't use all caps - Don't use italic - Don't use acronyms - Don't use abbreviations - Don't use humor or sarcasm
Subtitles - Content: Clarify context for the data - Length: Same as or shorter than headline - Position: Directly below the headline - Use smaller font size than headline - Don't use undefined words - Don't use all caps, bold, or italic - Don't use acronyms - Don't use abbreviations
Labels - Content: Replace the need for legends - Length: Usually fewer than 30 characters - Position: Next to data or below or beside axes - Use a few words only - Use thoughtful color-coding - Use callouts to point to the data - Don’t use all caps, bold, or italic
Annotations - Content: Draw attention to certain data - Length: Varies, limited by open space - Position: Immediately next to data annotated - Don’t use all caps, bold, or italic - Don't use rotated text - Don’t distract viewers from the data

You want to be informative without getting too detailed. To meaningfully communicate the results of your data analysis, use the right visualization components with the right style. In other words, let simplicity and elegance work together to help your audience process the data you are sharing in five seconds or less.

Designing a chart in 60 minutes

By now, you understand the principles of design and how to think like a designer. Among the many options of data visualization is creating a chart, which is a graphical representation of data.

Choosing to represent your data via a chart is usually the most simple and efficient method. Let’s go through the entire process of creating any type of chart in 60 minutes. The goal here is to develop a prototype or mock up of your chart that you can quickly present to an audience. This will also enable you to have a sense of whether or not the chart is communicating the information that you want.

n11dF8pFSbKdXRfKRdmy9A_c0707d21e99d4004b8b2fe44e32c55b6_Screen-Shot-2021-02-26-at-4 35 02-PM

Follow this high level 60-minute chart to guide your thinking whenever you begin working on a data visualization.

Prep (5 min): Create the mental and physical space necessary for an environment of comprehensive thinking. This means allowing yourself room to brainstorm how you want your data to appear while considering the amount and type of data that you have.

Talk and listen (15 min): Identify the object of your work by getting to the “ask behind the ask” and establishing expectations. Ask questions and really concentrate on feedback from stakeholders regarding your projects to help you hone how to lay out your data.

Sketch and design (20 min): Draft your approach to the problem. Define the timing and output of your work to get a clear and concise idea of what you are crafting.

Prototype and improve (20 min): Generate a visual solution and gauge its effectiveness at accurately communicating your data. Take your time and repeat the process until a final visual is produced. It is alright if you go through several visuals until you find the perfect fit.

Key takeaway

This is a great overview you can use when you need to create a visualization in a short amount of time. As you become more experienced in data visualization, you will find yourself creating your own process. You will get a more detailed description of different visualization options in the next reading, including line charts, bar charts, scatterplots, and more. No matter what you choose, always remember to take the time to prep, identify your objective, take in feedback, design, and create.

Hands-On Activity: Making your own visualization

Question 1

Activity overview

UWFf-U9hTzKhX_lPYX8yBw_8c2e9cd211e3479a89816c7b1816ab07_image4

Earlier in this course, you learned the importance of visualizing data with design thinking. In this activity, you will apply this knowledge and create your own visualization from a dataset.

By the time you complete this activity, you will be able to create and customize data visualizations using the Chart Editor in a spreadsheet. This will enable you to answer a business question with a shareable representation of data, which is important for presenting your findings in your career as a data analyst.

What you will need

To get started, first access the example dataset.

Click the link to the example dataset to create a copy. If you don’t have a Google account, you may download the example dataset directly from the attachments below.

Link to example dataset: Making your own visualization

OR

Download example dataset: Making your own visualization - example dataset

The scenario

UWFf-U9hTzKhX_lPYX8yBw_8c2e9cd211e3479a89816c7b1816ab07_image4

You are a junior data analyst at a local company. In your current data analysis project, you’ve been exploring sales data for all of your company’s products, including the top products and sales trends for the last year. You need to present the results of this analysis to the company executives. Your goal for this presentation is to demonstrate how sales of the company’s products have changed over the last 12 months. Your findings about the two top-selling products include:

Product name Units sold Time period with highest sales
Product A 2.5 million 70% of total annual sales occur in October, November, and December
Product B 1.9 million Mostly consistent sales year-around, with a slight i increase in November, December, and January

Your audience is made up of the chief marketing officer (CMO) and marketing department vice presidents (VPs), not other data analysts or engineers. They will use the information you present to make decisions on how to allocate advertising dollars for each product for the coming year.

Review the design thinking process

UWFf-U9hTzKhX_lPYX8yBw_8c2e9cd211e3479a89816c7b1816ab07_image4

Now that you are familiar with the scenario, take a moment to review the steps of the design thinking process. Remember, design thinking is about keeping a user-centric focus. By understanding the needs of your audience, you can craft a data visualization that communicates your findings effectively. The steps of the Design Thinking process are:

  • Empathize: Think about the emotions and needs of the target audience.
  • Define: Understand the audience’s needs, problems, and insights.
  • Ideate: Use your findings from the previous phases to begin to create data visualizations.
  • Prototype: Start putting it all together. In this case, you can put your findings into a presentation or dashboard.
  • Test: Check that your prototype is effective. In this case, you can show your visualizations to team members before the presentation.

pN1RQfPtSPGdUUHz7Xjxvw_348460ba7d2b443faa81522f390ause1_Data-Analytics-graphic

Take a moment to empathize with your audience’s needs. What takeaways are most important to them? Which data visualization would communicate that takeaway most effectively?

As you consider which kinds of data visualizations would be most useful, review the decision tree from earlier in this course. This will help you figure out what type of story you want to tell with your data.

Create a prototype

UWFf-U9hTzKhX_lPYX8yBw_8c2e9cd211e3479a89816c7b1816ab07_image4

Now, use spreadsheet software to try out different visualizations of the data.

  1. Highlight all cells by clicking on cell A1 and dragging to M3. This should highlight all the data and headers aside from the Total column.
  1. Click on the Insert tab and select Chart.

This will insert a chart object and bring up the Chart editor on the right side of the screen.

  1. In the Chart editor, click on the Setup tab.

  2. Click on the Chart type dropdown box. This will bring up the different kinds of charts you can create. Select the data visualization you think would be most useful during your design thinking process.

Customize your chart

Now, customize your visualization by editing the titles, labels, and style.

Click on the Customize tab in the Chart Editor. Click on the Chart & axis titles dropdown to add an informative title or label your axes. Click the Legend dropdown to create a legend for your chart.

Once you decide on the style and labels, focus on the design elements of the chart. This is your chance to adjust elements such as color and font. For instance, you can change the color scheme of the chart in the Chart Style dropdown.

When creating data visualizations, accessibility is important. Set up your visualization in a way that is accessible and understandable by including highly contrasting colors.

Once you’re done customizing your chart, review your choices to ensure that your visualization is easy to understand.

  • Do you think your audience will fully understand what they are observing within five seconds?
  • Will they understand the key takeaway you’re trying to communicate after another five seconds?
  • Did you use the most clear and communicative visualization style for your data?

If the answer to any of these questions is no, try different visualization styles and design choices. Experiment with colors, shapes, and chart types to find what makes it easier or harder to understand the message you are trying to convey.

Confirmation and reflection

UWFf-U9hTzKhX_lPYX8yBw_8c2e9cd211e3479a89816c7b1816ab07_image4

Which of the following are necessary to consider while making an effective visualization? Select all that apply.

  • The needs of your audience
  • The design thinking process
  • The type of data you are visualizing
  • The brand of visualization software you use

Explain: In order to make an effective visualization, you must consider the type of data you’re visualizing, the needs of your audience, and the design thinking process. An effective visualization can be made in any visualization software. Going forward, you can use your knowledge of creating data visualizations in the chart editor to explore more types of data visualizations. This will help you better present your data and findings to peers and stakeholders.

Question 2

In this activity, you used design thinking to create a data visualization and answer a business question. In the text box below, write 2-3 sentences (40-60 words) in response to each of the following questions:

  • What insights did you gain about the two products you visualized? What trends did you notice?
  • How did design thinking (Empathize, Define, Ideate, Prototype, Test) influence the process of making the data visualization?
  • How can design thinking help make data visualizations more accessible and easier to understand?

Explain: Congratulations on completing this hands-on activity! A good response would include how design thinking should be at the heart of your visualization process because it allows analysts to create user-centric visualizations.

Design thinking helps you stay focused on your audience, message, and goal. This helps you create a data visualization that tells a meaningful story about your data that is useful to your audience. Design thinking also helps you plan for accessibility issues. By improving accessibility, you make data visualizations that communicate more effectively.

Test your knowledge on exploring data visualizations

Question 1

What are the three basic visualization considerations? Select all that apply.

  • Subtitles
  • Labels
  • Text
  • Headlines

Explain: The three basic visualization considerations are headlines, subtitles, and labels.

Question 2

Directly labeling a data visualization helps viewers identify data more efficiently. Legends are often less effective because they are positioned away from the data.

A. True

B. False

It is true statement. Explain: Directly labeling a data visualization helps viewers identify data quickly. Legends are often less effective because they are positioned away from the data.

Question 3

Why do data analysts use alternative text to make their data visualizations more accessible?

A. To make data visualizations easier to read

B. To provide a textual alternative to non-text content

C. To add context to the data visualization

D. To make the presentation of data clearer

The correct answer is B. To provide a textual alternative to non-text content. Explain: Alternative text provides a textual alternative to non-text context. Alternative text ensures that users who need to access your data visualizations in different ways, like with a screen-reader, will still absorb the information.

Question 4

You are creating a data visualization and want to ensure it is accessible. What strategies do you use to make your visualization available to a wider audience? Select all that apply.

  • Simplify your visualization
  • Do not include labels
  • Focus on necessary information over long chunks of text
  • Avoid overly complicated charts

Explain: Simplifying your data visualizations can help your audience understand and focus on the important data. To do this, avoid overly complicated visuals or unnecessary information.