Week 4 – Course challenge – Shuffle Q/A 1

18. Scenario 1, continued

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.

In which part of your data narrative would you include information about charging stations, the need to increase battery range, and why it’s important for Gaea to increase its cars’ battery range?

  • Aha moment
  • Setting
  • Plot
  • Big reveal

19. Scenario 1, continued

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

Describe the differences between vertical and horizontal layouts. Select all that apply.

  • Vertical layouts prevent items from being layered over other objects
  • Vertical layouts adjust the height of the views and objects contained
  • Horizontal layouts adjust the width of the views and objects contained
  • Horizontal layouts prevent items from being layered over other objects

20. Scenario 2, questions 10-15

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 to communicate information about electric vehicle sales in 2015 compared to 2020:

Alt-text: Slideshow with bar chart of electric vehicle sales from 2015 and 2022. 2022 had higher sales. There are also multiple sentences at the bottom of the slide and another piece of descriptive text near the chart.

To improve the slide, you remove the text box at the bottom. For what reasons will this make your slide more effective? Select all that apply.

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

21. Scenario 2, continued

You complete your slideshow and share it with your team. Once it is approved by your supervisor, you begin preparing to give your presentation. You consider maintaining good posture, being aware of nervous habits, and making eye contact. In addition, you think about how you will speak.

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

  • 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
  • Keeping the pitch of your sentences level so that your statements are not confused for questions

22. Scenario 2, continued

Next, you prepare for the question-and-answer session that will follow your presentation. What methods help you consider any limitations of your data? Select all that apply.

  • Understand the strengths and weaknesses of the tools
  • Eliminate the outliers
  • Look at the context
  • Critically analyze the correlations

23. Scenario 2, continued

The big day has arrived, and you finish your presentation to the Gaea team. In the question-and-answer session, a stakeholder asks you a very detailed question about a car battery range project that's still in development.

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

  • Be certain that you understand the context of the question that the stakeholder is asking
  • 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
  • Give yourself extra time by planning your thoughtful response when the stakeholder begins speaking

24. Scenario 1, continued

Your team’s analysis has revealed three key insights:

Electric vehicle sales demand is expected to grow by more than 400% by 2025.

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.

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.

Fill in the blank: Based on these insights, you create a clear and direct _____, which will guide your data story.

  • business case
  • spotlight
  • primary message
  • specific question

25. Scenario 1, continued

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

26. 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.

  • Select more varied hues
  • Add more space between each state
  • Make the intensity of the colors stronger
  • Choose darker values

27. Scenario 1, continued

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.

How do you explain causation?

  • Causation involves how often data values fall into certain ranges. In the case of Gaea’s business, data about the number of charging stations will fall into ranges associated with car sales.
  • Causation is the measure of the degree to which two variables move in relationship to each other. In the case of Gaea’s business, charging station numbers and car sales move in the same direction.
  • Causation involves everything associated with an event. In the case of Gaea’s business, the lack of charging stations has a negative effect on the entire automotive marketplace.
  • 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.

28. Scenario 2, continued

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. You do this by first choosing one data visualization to share on this slide, then create another slide for the second data visualization.

Fill in the blank: In addition, you make sure to use _____ font sizes and colors for all of your data visualization titles.

  • consistent
  • unique
  • colorful
  • different

29. Scenario 2, continued

Now that you have some idea of the questions the stakeholders will ask, you consider potential objections. You and a team member consider different objections that might arise. Your team member asks you how you will respond if someone from Gaea has an objection that you haven’t prepared for.

You say that you will respond professionally using the information you currently have available in order to move quickly past the objection.

  • True
  • False

30. Scenario 1, questions 1-9

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.

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.

A big part of audience engagement is knowing how to eliminate less important details. What practice do you use to scan quickly through the data in order to identify the most important insights?

  • Balancing
  • Ranking
  • Filtering
  • Spotlighting

31. Scenario 1, continued

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 add information on the x-axis to represent a scale of values for the total electric vehicle sales and on the y-axis to represent the time periods (2015 and 2020).

  • False
  • True

32. Scenario 2, continued

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.

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

33. Scenario 2, continued

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.

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

34. Scenario 1, continued

Scenario 1, continued

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. To improve your draft, you select more varied hues, choose darker values, and make the color intensity stronger. This will also help clarify the spacing between the states.

  • True
  • False

Devendra Kumar

Project Management Apprentice at Google

Leave a Reply