Course challenge

Question 1

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?

A. Balancing

B. Filtering

C. Ranking

D. Spotlighting

The correct answer is D. Spotlighting

Question 2

Scenario 1, continued

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.

• Clear
• Direct
• Comprehensive
• Subtle

Question 3

Scenario 1, continued

Next, you decide on your data narrative’s characters, setting, plot, big reveal, and aha moment. The characters are the people affected by your story. This includes your stakeholders, Gaea’s customers, and Gaea’s potential future customers. For the setting, you describe the current situation, potential tasks, and background information about the analysis project.

As you begin to work on the plot for the data narrative, which of the following ideas would you include? Select all that apply.

• Why it’s important for Gaea to increase its cars’ battery range by 2025
• A list of your recommendations and details about why they will help Gaea be successful
• The challenges associated with the current lack of vehicle charging stations
• How your data analysis can help Gaea solve its business problems

Question 4

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 or False?

A. True

B. False

It is false statement.

Question 5

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). True or False?

A. False

B. True

It is false statement.

Question 6

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.

Fill in the blank: To improve your draft, you select more varied hues and make the color intensity stronger. In addition, you choose darker _____ in order to reflect more light.

A. values

B. variables

C. visuals

D. views

The correct answer is A. values. Explain: Value indicates how much light is being reflected.

Question 7

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.

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.

A. prevents occurrence of

B. changes the timing of

C. moves in relationship to

D. directly leads to

The correct answer is D. directly leads to. Explain: You explain that causation is when an action directly leads to 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.

Question 8

Scenario 1, continued

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

Your team analyzes data from a consumer survey that investigated the importance of longer battery range 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:

After reviewing your pie chart, you realize that it could be improved. How do you make this chart more effective?

A. Add an x-axis and y-axis to provide additional explanation about the data

B. Remove the labels for the number of miles per charge consumers will require before purchasing an electric vehicle

C. Resize the pie segments so they visually show the different values

D. Write a longer title to add more detail about the data the pie chart contains

The correct answer is C. Resize the pie segments so they visually show the different values

Question 9

Scenario 1, continued

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 width 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?

A. Circular layout

B. Vertical layout

C. Horizontal layout

D. Diagonal layout

The correct answer is C. Horizontal layout

Question 10

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

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.

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

Explain: 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

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.

• Choose one data visualization to share on this slide, then create another slide for the second data visualization
• 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

Question 12

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 explain the data visualizations.

One of the strategies you practice is the five-second rule. What are some key aspects of this rule? Select all that apply.

• Tell your audience the conclusion that you want them to understand
• Be prepared to explain the data visualization
• Ask your audience if they understand the data visualization
• Take no more than five seconds to explain the data visualization

Question 13

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.

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

Question 14

Scenario 2, continued

Now that you have some idea of the questions the stakeholders may ask, you consider potential objections. How do you ensure you are prepared for any potential objections? Select all that apply.

• Assure stakeholders that your analysis process is private so it cannot be reproduced by others
• Be sure to include numerous perspectives during the analysis process
• Include information on where the data came from in an appendix
• Keep a detailed log of your data-cleaning process

Question 15

Scenario 2, continued

As a final step in the data-sharing process, you think about how to respond during the Q&A session. What strategies will you employ when answering questions? Select all that apply.

• Involve your whole audience
• Listen to the whole question, and repeat it, if necessary
• Understand the context of the question
• Provide detailed, comprehensive responses