Final Project

For the final project, I created a Tableau Story viewable on Tableau Public. This story examines the popularity of Fake News using a “Drill Down” approach. In other words, we begin by assessing the websites’ popularity and iteratively narrow down on the popularity of the stories posted.

There are three Story Points:

  1. Website Domain Rank Popularity
  2. Website Domain Rank and Published Content Volume
  3. Story Titles by Facebook Likes

We begin by examining the websites and how much traffic they receive, based on the Domain Rank field. Next, we look at how much published content each site is contributing, based on the number of story records. Lastly, we glimpse the published story titles receiving the most Facebook Likes, sorted in descending order, and hypothesize a genre theme.

ENJOY!

ER Diagramming

One method to analyze our data, which is useful for grouping and understanding relationships within it, is a simple Entity Relationship (“ER”) diagram. ER diagrams were originally developed for database design. Lucid Charts provides a good tutorial including history of ER Diagrams HERE.

In our example, we have three Entities and two Relationships, described below.

Entity

  1. “News” Story – a story written and published online.
  2. Website – a website hosting a story or stories.
  3. Social Media Posts – a posting about a story, including Likes, Comments or Shares on Facebook.

Relationship

  1. A “News” Story can be published on many Websites. Cardinality is One to Many.
  2. A “News” Story is referenced by many Social Media Posts. Cardinality is One to Many.

ER Diagram