The Tenzer Visualization Contest for Fall 2021 was created for all current DePauw students. It involves participants using the Tableau Public visualization platform to create an interactive dashboard for a provided data set.
The primary goal is to learn and practice data visualization skills which can be applied throughout your tenure at DePauw and/or as an intern/professional after graduation. A secondary goal is to expose DePauw students to the LinkedIn Learning platform. LinkedIn Learning provides access to more than 16,000 online courses ranging across technology, business, and creative topics that offer up-to-date expertise from subject matter experts in their respective fields. It is available to all DePauw students at any time of the day on every day of the year.
This contest is suitable for students who have never created any type of visualization and/or have never used the Tableau platform. Your results will be kept confidential (being shared only with Tenzer personnel and the judges) so please don't be shy to try. Two Tenzer interns (who are current DePauw students) have worked with this data, helped to create this contest, and will serve as judges.
For this contest, you are required to use the Tableau Public software and online sharing platform. Tableau Public is free to everyone and available for PC and Mac. Click the icon to the left to sign up for a free account and then download the software and post your visualization to your portfolio.
Did you know that LinkedIn Learning is now available to all DePauw students at no cost? If you haven't signed up yet, please do so now. You're going to need access to LinkedIn Learning for this contest. Instructions are here.
You are required to use the "Bank Failures 2000 - 2017" dataset available from the From Excel to Tableau LinkedIn Learning course; see the Exercise Files resources linked directly from the course.
The following examples were built by Lauren Nguyen '23 and Hai Phan '23. Lauren and Hai have experience with Tableau, and are interning with the Tenzer Technology Center this fall. They will also be available for consultation and problem solving, and they will help judge for this contest!
The goal of this exercise is to use the provided dataset to create and post an interactive dashboard to Tableau Public. In order to be considered for prizes, your visualization (an interactive dashboard) must meet the following minimum criteria:
Use the provided dataset (available from this LinkedIn Learning video)
Have a main title (which captures the essence of the dashboard as a whole)
Include your name and expected DPU class year in the dashboard itself
Include a text box (small font is fine) on your dashboard acknowledging the source of the data... "Data was provided by, and downloaded from, the From Excel to Tableau LinkedIn Learning course, by Heather Johnson and Madecraft, October 2021."
Contain at least two separate but related charts
Choose a suitable size for your dashboard and ensure it is visible to anyone using the link that you submit
Your dashboard may focus on one state or one region, or perhaps you aren't going to show geography at all, and instead, you may choose to look at other features of the dataset. You decide the story you want to tell. Narrow your focus; do not try to include or utilize all aspects of the dataset. Be creative; there are dozens of possibilities. Just be sure to use the provided data and meet the above minimum criteria.
Lastly, you may take inspiration from any number of sources, but plagiarism under any form will disqualify participants from this contest. We want to see your ideas and skills, not someone else's work!
The submission form will close at 5:00 pm EDT on Monday, November 15. We will not accept late entries.
This contest is open to all current DePauw students. Use your DePauw credentials to access the submission form.
Judging will focus on clarity, accuracy, creativity, and aesthetics, but it will be very friendly and forgiving. You are not expected to be visualization experts. Just do the best you can with whatever you know about visualization best practices. Here are some recommendations:
Prepare and present a concise and accurate story; focus.
Ensure you have an accurate title and perhaps a short description.
Think creatively and bring your own style; even seemingly small things like color choices and layout can have a big impact and will help separate your visualization.
Less material that is clearly presented with clean aesthetics is usually better than multiple clumsy charts that don’t coalesce.
We intend to have at least one grand prize, other top finishers, and several honorable mentions. Prize packs may feature technology equipment and/or DePauw swag, gear or clothing. Winners will be announced via email and on this page as soon as possible after the deadline and no later than the end of November.
We will only judge one submission from each student. If you make 2 or more submissions, we'll simply use the most recent while ignoring the others.
Your visualization only needs to be visible to anyone with the direct URL (so that we can view and judge it). We won't share or post your visualization without your explicit consent. If you have any doubts or concerns about it being viewed more broadly or with random people finding it (i.e. what we typically refer to as public), just list it as “not visible" on your Tableau Public portfolio. This will ensure that only people with the direct URL can view it and essentially eliminate the possibility that is "found" by random people.
Definitely not! Our goal is to encourage and promote your learning of a new technology and data visualization skills. This contest is designed to get you started with Tableau while also providing a fun co-curricular opportunity during the term.
Start by watching the From Excel to Tableau LinkedIn Learning course by Heather Johnson and Madecraft. This 90 minutes video walks you through the basics of Tableau and introduces a variety of different charts, all while using the required dataset.
Here is the online How-to Videos page for Tableau Public. We recommend concentrating on the following videos first as these may best relate to this contest:
1. Tableau Public Overview
2. Connecting to Excel and Text Files
11. Creating Your First Chart
12. Using the Show Me Tool Bar
13. Understanding the Logic of Charts
14. Combining Sheets on a Dashboard
15. Adding Interactivity to Dashboards
16. Dashboard Formatting
21. Adding a custom Viz in Tooltip
And here is the online Free Training Videos page from Tableau Desktop. Tableau Desktop is technically a separate software, but most of its features that you may leverage for this contest work similarly in Tableau Public. These are the Tableau Desktop video sections that we recommend:
Getting Started
Visual Analytics
Dashboards and Stories (but ignore the Stories videos)
Mapping
Yes, but only if it supports or extends upon the provided dataset. In other words, don't forget to leverage the required dataset (in order to meet the posted minimum requirements, see above).
Accuracy and clarity are critical, but artistic expression and aesthetics are also important
Less material that is clearly presented is often better than a bunch of seemingly random charts that don’t coalesce
Focus on telling a story; do not try to impress us by demonstrating a bunch of Tableau Public features and functions
Even seemingly small things like color choices and layout can have a big impact and will help separate your visualization
Check your work carefully; ask yourself how each chart, title, color, font, data point, etc. is contributing to your visualization
Do not hesitate to ask questions!
If you have any concerns related to the contest, the data, or the Tableau software, please direct them to the Tenzer Technology Center director, Michael Boyles, at michaelboyles@depauw.edu.
You can also contact the current Tenzer Technology Center interns, Lauren Nguyen '23 (trangnguyen_2023@depauw.edu) or Hai Phan '23 (haiphan_2023@depauw.edu).
Runner-up: Hieu (Bu) Tran ‘23
Honorable Mentions: Truc Nguyen ‘25, Tam Thanh My Ngo ‘25, Linh (Lindsie) Nguyen ‘25