Assignment 5: Creating Interactive Dashboards
Part 1: Data Preparation
Download the Excel file Pew News Story Data.xlsxand the Assignment5_Part3_AnswerTemplate.docxfrom Canvas.
Populate the News Coverage worksheet with data from the Lookups worksheet using VLOOKUPs for each section that is ends in …Code. For example, SourceCode should be followed by SourceCategory and SourceName(Short). Do the same for PlacementCode, Geographical Code, and StoryTopicCode. The purpose is to ensure that Tableau has data that humans can interpret. Those SourceCode values are of little use to people.
Part 2: Create an Interactive Dashboard
Use Tableau to create the Dashboard to reflect major story topics and is filterable by Date and Source.Feel free to experiment with styles and colors of your choosing, add an image, etc. The only requirement is that the user is able to filter major news stories by date and source (ie., newspaper, radio, etc.).
To complete this:
1) Create a new worksheet, called “Story Topics,” that lists the Story Topic labels in a bar chart, arranged in descending order. Feel free to play around with fonts and colors to get it the way you want it.
2) Add a Date filter (range of dates) and Source Category filter for that worksheet.
3) Create a worksheet called “Stories by Source”. Add the Datefilters, just like with the Story Topics worksheet.
4) Create a Dashboard with Story Topics at the top, Stories by Source at the bottom, and the filters Story Date and Source Category on the right side.
5) Set the filters so that they affect both worksheets in the Dashboard, and make sure you set Story Topics to be a filter for the rest of the Dashboard (i.e., turn on “Use as Filter”). Your dashboard should look like something like this:
When you uncheck Sources, the column chart should update as well.
6) Name your Dashboard “Story Topics Viewer.”
Part 3: Test the Dashboard
Test it out by choosing the date range of March 15 to April 11, 2012 and make sure Newspaper, Radio, Online and Television are all checked under Source Categories to start.
Use the answer template sheet to answer the following questions:
How many stories about crime appeared on the radio during this time?
How many stories about Health/Medicine appeared on television during this time?
How many stories about Government appeared in newspapers, online and on the radio during that time?
What is the only topic where radio coverage accounted for most of its stories during that time? (select each story topic bar to see the distribution of stories)
Assignment 5–Part 3 Answer Template
Name:______________________
Part 3: Test the Dashboard
Test it out by choosing the date range of March 15 to April 11, 2012, and make sure Newspaper, Radio, and Television are checked under Source Categories.
Copy and paste URL:______________________________________________________________
Then answer these questions: Answer:
How many stories about crime appeared on the radio during this time?
How many stories about Health/Medicine appeared on television during this time?
How many stories about Government appeared in newspapers, online and on the radio during that time?
What topic did radio coverage account for most of the stories during that time? (select each story topic bar to see the distribution of stories)