Download the PDF version here.
In this workshop, we will:
1. Answer the question.
2. Share an example using the STAR technique.
Explain your favorite data visualization tools/techniques.
Job Candidate: My favorite data visualization tool is Tableau. I love how I can take a large data set and turn it into something actionable and visually appealing.
A few months ago, our Director announced that she was looking to expand our company to another major city by opening a new retail store (Situation).
My supervisor put me in charge of determining a list of possible locations (Task).
I pulled data from our online sales database to see which cities most of our customers were ordering from. I also collected location data from our email list. Lastly, I created 2 Filled Maps using Tableau to show the areas with our highest customers and potential customers and delivered it to my supervisor (Actions).
My supervisor used my maps in a presentation to the Director and they selected Houston, TX, which was in alignment with my reports! (Results)
A great way to prepare for questions like this is to think about your most impressive stories in advance. You can plan out the response you'd like to use before we practice by using the STAR Method. Try it now!
(Try to develop your own answer first. Then, scroll to the bottom to view some more example answers.)
Exercise 1: What is your favorite data visualization tool/technique?
a) Your Answer:
b) Your Example/Story:
SITUATION -
TASK -
ACTIONS -
RESULTS -
Exercise 2: What is the most effective way to visualize data for non-technical team members?
a) Your Answer:
b) Your Example/Story:
SITUATION -
TASK -
ACTIONS -
RESULTS -
(Use this rubric to guide your feedback and observations during the Breakout Sessions.)
(1) Specificity of the answer
Check each item that accurately describes the candidate's answer:
(2) Intelligibility
Could the candidate be heard and understood? Check any of the items below where the candidate could improve.
(3) Body language
How well did the candidate engage with the interviewer non-verbally?
Check any of the items below where the candidate succeeded.
Check if any of the items below are areas where the candidate could improve.
We have provided sample answers to the practice questions for your reference.
What is the most effective way to visualize data for non-technical team members?
I believe the best way to visualize data for non-technical team members has to start with which visualization techniques match the project requirements and audience best. You can then decide how to simplify the content to make it more easily understandable from a non-technical perspective.
I actually had to do this recently. I usually do more high-level data analyst work, but our CEO recently announced that she wanted all of our departments to invest in some basic-level data analysis training for all employees. She wanted my department to develop in-person training as well as an online resource center (Situation).
I was tasked with creating the in-person training workshop (Task).
One principle for helping an audience grasp the meanings in data is to develop their understanding of the context in which the data originates. So I decided to have my workshop participants involved in creating the data that we would be visualizing and analyzing. I also decided we’d use a Google Sheet for gathering and visualizing our data, since most people have some knowledge of spreadsheet tools. I created a game to collect data by having participants shoot paper balls into a trashcan. The first round, they had to do it with their non-dominant hand. The second round, they had to do it with their dominant hand. Misses were 0 points, they got 1 point if they hit the can, and 3 if they made it. I asked each person to track their data in a shared Google Sheet. When we compared the two rounds, the 2nd round scores were of course much higher. To help them visualize our data effectively, I used some key principles of data visualization, such as using an appropriate kind of plot for the data type you have, using visual patterns, such as positional changes in a plot, that make it easiest for people to understand the key information, and creating a high data-to-ink ratio.With these concepts in mind, I chose a bar chart for my participants to view the data, where the relative heights of the bars highlighted the message in the data. We then went on to engage in some basic analysis of the data they had produced as well. (Actions).
After the activity, I was surprised at how much the attendees enjoyed the experience, and gave me feedback on how they learned from the data gathering, visualization, and analysis activities . My supervisor was impressed as well and there have been conversations about me facilitating this training with our incoming cohort of interns. (Results)
How do you design a visualization to represent data?
Designing a visualization is actually my favorite part. I make my decisions based on the data types in the project, which type of plot and which visual elements will best highlight the key meanings in the data, and who the audience is.
I recently completed a Nanodegree program from Udacity in Business Analytics. One of our assignments was to analyze New York Stock Exchange data (Situation).
We had to use spreadsheets to analyze and summarize the data, and then incorporate visualizations into the professional explanation of our key findings. (Task).
I designed a visualization that used principles of effective data storytelling, beginning with my choice of a line chart, as it shows changes over time very well. I also incorporated different colors to highlight key points in the data. Finally, I made sure to keep my ratio of data to ink high, as this is another key aspect of designing high-quality data visualizations. (Actions).
My instructor was impressed with how quickly I created this effective visualization and analysis to convey my findings, and it really got me excited about combining my experience in finance with my new data analysis skills in Microsoft Excel (Results).