6.5.Course challenge - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

Scenario 1 (Q1 - Q9)

You have been working as a junior data analyst at Bowling Green Business Intelligence for nearly a year. Your supervisor, Kate, tells you that she believes you are ready for more responsibility. She asks you to lead an upcoming client presentation. You will be responsible for creating the data story, identifying the right tools to use, building the slideshow, and delivering the presentation to stakeholders.

Your client is Gaea, an automotive manufacturer that makes eco-friendly electric cars. For the past year, you have been working with the data team in Gaea’s Bowling Green, Kentucky, headquarters. For the presentation, you will engage the data team, as well as its regional sales representatives and distributors. Your presentation will inform their business strategy for the next three-to-five years.

Question 1

You begin by getting together with your team to discuss the data story you want to tell. You know the first step in data storytelling is to engage your audience.

Fill in the blank: A big part of engagement is knowing how to eliminate less important details. So, you use spotlighting to _____ the data in order to identify the most important insights.

  • study
  • research
  • scan
  • recheck

Correct. You use spotlighting to scan through data to quickly identify the most important insights. Spotlighting enables data analysts to identify broad, universal ideas and messages.

Question 2

Once you have identified the most important insights, it’s time to create your primary message. Your team’s analysis has revealed three key insights:

  1. Electric vehicle sales demand is expected to grow by more than 400% by 2025.
  2. The number of publicly available vehicle charging stations is a significant factor in consumer buying decisions. Currently, there are many locations with so few charging stations that electric car owners would run out of power when traveling between stations.
  3. Vehicle battery range is also a significant factor for consumers. In 2020, the average battery range was 210 miles. However, the vast majority of survey respondents report they will not buy an electric car until the battery range is at least 300 miles per charge.

Based on these insights, you create your primary message. What are the expectations of a primary message? Select all that apply.

  • Subtle
  • Comprehensive
  • Clear
  • Direct

Correct. A primary message should be clear and direct.

Question 3

Next, you decide on your data narrative’s characters, setting, plot, big reveal, and aha moment. During the narrative, you want to communicate to your stakeholders about the challenges associated with the current lack of vehicle charging stations and why it's important for Gaea to increase its cars’ battery range by 2025.

Information about charging stations and the need to increase battery range will be part of the setting of your data story.

  • True
  • False

Correct. This information will be part of the plot*. The plot, or conflict, is used to create tension in the data story. For Gaea’s situation, it would include two ideas: An explanation of some of the challenges associated with lack of vehicle charging stations and details about why it’s important for Gaea to increase its cars’ battery range by 2025.*

Question 4

Now, it’s time to consider which tools to use to create data visualizations that will clearly communicate the results of your analysis. You and your team decide to make both spreadsheet charts and Tableau data visualizations. In addition, you agree to build a dashboard to share live, incoming data with your stakeholders. This will help them achieve the following goals:

  • Organize multiple datasets about electric vehicle battery ranges into a central location
  • Enable tracking and analysis of electric vehicle data
  • Simplify data visualizations about the number of available charging stations using maps of the different geographies

Another key benefit of dashboards is that they enable you to maintain control of your data narrative.

  • True
  • False

Correct. Sharing dashboards with stakeholders likely means that you will lose control of the narrative. This is because you won’t be there to tell the story of your data and share your key message.

Question 5

Now that you have finished planning the data story with your team, it’s time to create data visualizations. First, you consider electric vehicle sales worldwide in 2015 compared to 2020. You use a spreadsheet to create the following bar graph to compare the two values:

You want to add a label to represent the scale (total count by year) of electric vehicle sales. Where on the graph do you label these values?

  • The x-axis
  • The vertical bars
  • The y-axis
  • The colors

Correct. In bar graphs with vertical bars, the y-axis is used to represent a scale of values for the variables. The y-axis is the vertical line of a bar graph usually placed to the left.

Question 6

Next, you explore how access to public car-charging stations is influencing electric vehicle purchases. As your analysis has revealed, there are many areas without enough places for people to plug in and charge their cars. This lack of charging stations has a negative impact on demand for electric cars and overall vehicle sales.

You use Tableau to create the following draft of a visualization, which organizes the charging station data geographically:

After reviewing your draft, you realize that it could be improved. What steps do you take to make your map more effective? Select all that apply.

  • Add more space between each state
  • Choose darker values

Correct. To make the map more effective, you make the intensity of the colors stronger, select more varied hues, and choose darker values. Intensity will make the colors brighter. Different hues will help the states stand out from one another. And darker values will make the color differences easier to see.

  • Make the intensity of the colors stronger

Correct. A map’s colors should be used to help the audience understand the data it contains. To make the map more effective, you make the intensity of the colors stronger, select more varied hues, and choose darker values. Intensity will make the colors brighter. Different hues will help the states stand out from one another. And darker values will make the color differences easier to see.

  • Select more varied hues

Correct. To make the map more effective, you make the intensity of the colors stronger, select more varied hues, and choose darker values. Intensity will make the colors brighter. Different hues will help the states stand out from one another. And darker values will make the color differences easier to see.

Question 7

Now, you want to highlight what your team’s analysis discovered about the number of charging stations available compared to the number of cars purchased. Your data has confirmed that the lack of charging stations causes the effect of fewer car sales. To communicate this effectively, you will need to convey causation to the stakeholders.

Fill in the blank: You explain that causation is when an action _____ an outcome. In the case of Gaea’s business, causation can be used to discuss the relationship between lack of charging stations and fewer car sales.

  • changes the timing of
  • prevents occurrence of
  • moves in relationship to
  • directly leads to

Correct. Causation is when an action directly leads to an outcome, such as a cause-effect relationship. In the case of Gaea’s business, the lack of charging stations directly leads to the outcome of fewer car sales.

Question 8

Once you finish creating data visualizations about the current state of the electric vehicle market, you turn to projections for the future. You want to communicate to stakeholders about the importance of longer vehicle battery range to consumers.

Your team’s data includes feedback from a consumer survey that investigated the importance of longer battery when choosing whether to purchase an electric car. The current average battery range is about 210 miles. By 2025, that distance is expected to grow to 450 miles per charge.

You create the following pie chart:

Fill in the blank: After reviewing your pie chart, you realize that it could be improved. You resize the _____ so they visually show the different values.

  • labels
  • values
  • axes
  • segments

Correct. To make this chart more effective, you resize the segments so they visually show the different values. When the segments are all the same size, even though they represent different values, this will confuse the audience.

Question 9

It’s time to build your Tableau dashboard for stakeholders. You consider what type of layout to use.

You decide that you want to be able to adjust the height of the views and the data visualizations about electric vehicle sales, charging stations, and battery range. Which type of layout will enable you to do that?

  • Diagonal layout
  • Vertical layout
  • Horizontal layout
  • Circular layout

Correct. A vertical layout will enable you to adjust the height of the views and objects contained.

Scenario 2 (Q10 - Q15)

Question 10

You have created your narrative and visuals, so now it’s time to build a professional and appealing slideshow. You choose a theme that matches the tone of your presentation. Then, you create a title slide with a title, subtitle, and the date.

Next, you create the following slide about electric vehicle sales in 2015 compared to 2020:

After reviewing it, you decide to decrease the number of words on your slide. For what reasons will this make your slide more effective? Select all that apply.

  • Slide text should be fewer than 25 words total
  • Slide text should be no more than 10 lines total
  • The text shouldn’t simply repeat the words you say
  • The font size is too small for your audience to read

Correct. Removing the text box at the bottom improves your slide in three ways: First, it eliminates text with a font size that is too small to read. Second, it reduces the slide’s word count to fewer than 25 words. Third, it ensures that the text does not simply repeat the words you say.

Question 11

You then create the following slide to demonstrate the challenges associated with battery range and charging stations:

After reviewing your slide, you realize that the visual elements could be improved. Which of the following options would help you make the visual elements on this slide more effective? Select all that apply.

  • Provide a detailed written explanation of both data visualizations
  • Use more colors in the map
  • Use a consistent font size and color for data visualization titles
  • Choose one data visualization to share on this slide, then create another slide for the second data visualization

Correct. To make the visual elements more effective, you should choose one data point to share, then create another slide for the second data visualization. In addition, you should use a consistent font size and color for data visualization titles.

Question 12

You complete your slideshow and share it with your team. Once it is approved by your supervisor, you prepare to give your presentation. You consider presentation best practices: maintaining good posture, being aware of nervous habits, and making eye contact. In addition, you think about how you will present your data visualizations.

What strategies can help you explain the data visualizations effectively? Select all that apply.

  • Speak quickly to save time and cover all important data points
  • Channel your excitement
  • Start with the broader ideas
  • Use the five-second rule

Correct. To explain the data visualizations effectively, you should channel your excitement, start with the broader ideas, and use the five-second rule.

What strategies can help you speak effectively? Select all that apply.

  • Keeping the pitch of your sentences level so that your statements are not confused for questions
  • Building in intentional pauses to give your audience time to think about what you have just said
  • Speaking quickly so you are sure to have time to include all important data points
  • Using short words and sentences

Correct. To speak effectively, you should practice using short words and sentences, keeping the pitch of your sentences level, and building in intentional pauses.

Question 13

Next, you prepare for the question-and-answer session that will follow your presentation. What methods help you predict what questions your audience may ask? Select all that apply.

  • Be prepared to consider and describe any limitations of your data
  • Make sure you have a clear understanding of Gaea stakeholder objectives
  • Add automotive jargon to your presentation to demonstrate that you understand these industry terms.
  • Do a test-run, or colleague test, of your presentation

Correct. To predict what questions stakeholders may ask, make sure you have a clear understanding of Gaea stakeholder objectives. You should also do a test-run of your presentation and consider and describe any limitations of your data.

Question 14

Now that you have some idea of the questions the stakeholders will ask, you and a team member consider different objections that might arise.

Your team member asks you how you will respond if someone from Gaea questions your data-cleaning process. How do you prepare for this objection? Select all that apply.

  • Be prepared to explain why data cleaning is not relevant at this stage of the project
  • Add your data-cleaning log to the slideshow appendix
  • Practice answering questions about your data-cleaning process
  • Keep a detailed log of your data-cleaning process

Correct. You prepare by keeping a detailed log of your data-cleaning process. Then, you add your data-cleaning log to the slideshow appendix and practice answering questions about your data-cleaning process.

Question 15

The big day has arrived, and you have just finished giving your presentation to the Gaea team. It’s now time for the question-and-answer session, and a stakeholder asks you a very detailed question about one specific electric vehicle charging station initiative.

You listen to the whole question, then repeat it. For what reasons is this important? Select all that apply.

  • It helps you confirm that you understand the question
  • It gives the stakeholder a chance to correct you if you misunderstand
  • It ensures the entire audience has heard the question, in case they did not when it was originally asked
  • It enables you to rephrase it in a way that is easier to answer

Correct. Listening to the whole question and repeating it helps you confirm that you understand the question. It also gives the stakeholder a chance to correct you if you are misunderstanding and ensures the entire audience has heard the question.

What strategies do you use in order to respond effectively? Select all that apply.

  • Involve the whole audience when you respond to the stakeholder
  • Keep your response short and to the point, then add detail if there are follow-up questions
  • Be certain that you understand the context of the question that the stakeholder is asking
  • Give yourself extra time by planning your thoughtful response when the stakeholder begins speaking

Correct. To respond to questions effectively, you should listen to the whole question. In addition, it’s important to understand the context of the question and involve the whole audience. Finally, Keep your response short and to the point.