Share data through the art of visualization course challenge
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.
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.
2. Scenario 1, continued
After you identify the most important insights, it’s time to create your primary message. 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.
Based on these insights, you create your primary message. Which of the following reflect the expectations of a primary message?
- The number of publicly available vehicle charging stations is a significant factor in consumer buying decisions. Therefore, Gaea must begin building vehicle charging stations
- Although electric vehicle sales demand is on the rise, low availability of charging stations and short battery range are significant hurdles that Gaea must overcome
- Electric vehicle sales demand is expected to grow by more than 400% by 2025. However, 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 people say they will not buy an electric car until the battery range is at least 300 miles per charge
- Electric vehicle demand is skyrocketing
3. 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.
Information about charging stations and the need to increase battery range will be part of the setting of your data story.
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 want to provide them with a tool that will 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
What tool do you create for your stakeholders?
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?
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.
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.
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.
You explain that 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.
8. Scenario 1, continued
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.
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 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?
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 that compares electric vehicle sales in 2015 and 2020:
After reviewing your slide, you realize that it could be improved. What steps do you take to make the two text boxes beneath the header more effective? Select all that apply.Add Your Heading Text Here
- Edit the text to fewer than five lines total
- Ensure the text does not simply repeat the words you plan to say
- Use abbreviations to reduce the amount of text
- Edit the text to fewer than 25 words total
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. A good solution would be for you to choose one data visualization to share on this slide, then create another slide for the second data visualization.
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.
- Ask your audience if they understand the data visualization
- Be prepared to explain the data visualization
- Tell your audience the conclusion that you want them to understand
- Take no more than five seconds to explain the data visualization
13. Scenario 2, continued
Next, you prepare for the question-and-answer session that will follow your presentation. To predict what questions they may ask, you do a colleague test of your presentation. You should choose a colleague who has deep expertise in the electric vehicle industry.
14. Scenario 2, continued
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.
- Keep a detailed log of your data-cleaning process
- Practice answering questions about your data-cleaning process
- Add your data-cleaning log to the slideshow appendix
- Be prepared to explain why data cleaning is not relevant at this stage of the project
15. Scenario 2, continued
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 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
- It helps you confirm that you understand the question
- It gives the stakeholder a chance to correct you if you misunderstand