Steps I used to set up this project:

1. Downloaded "Westworld" viewership stats in Excel from the Wikipedia page

2. Downloaded IMDb "Westworld" ratings and added them to the Excel spreadsheet.

3. Downloaded Rotten Tomatoes ratings and added them to the Excel spreadsheet.

4. Converted IMDb ratings (which are out of 10) to be out of 100 to match the Rotten Tomatoes rating format, so I could compare them more directly.

5. Clean Excel data for consistency.

6. Upload Excel to Power BI and create data visualization.

==

My Hypothesis:

My hypothesis about "Westworld" viewership was that the average # of viewers per episode decreased over time (from season 1 to season 4). I also expected the IMDb and Tomatometer ratings to decrease from season to season.

My Findings for "Westworld" Viewership Over Time:

As you can see from the line chart and the trend line, "Westworld" viewership declined dramatically over time.

• The most popular "Westworld" episode was "The Bicameral Mind," with 2.24 million U.S. viewers (Season 1 finale.) Directed by Jonathan Nolan and written by Lisa Joy & Jonathan Nolan.
• The least popular episode was "Années Folles," with 0.312 million U.S. viewers (Season 4, Episode 3.) Directed by Hanelle M. Culpepper and written by Kevin Lau & Suzanne Wrubel.

The number of average U.S. viewers also decreased from season to season. Season 1 had the highest number of average viewers per episode (1.83 million) and the last season, season 4, had the lowest number of average viewers per episode (0.35 million.)

My Findings for "Westworld" Ratings Over Time:

The average Tomatometer and IMDb ratings also went down over time, but not as dramatically as I expected.

• Both IMDb and Tomatometer rated the first season as the best.

• Both IMDb and Tomatometer rated the last season as the worst.

• Tomatometer's best ratings went to "The Original," the series premiere, and "The Riddle of the Sphinx," Season 2, Episode 4 (both Tomatometer: 100.)

• Tomatometer's worst rating went to "Crisis Theory," Season 3, Episode 8. (Tomatometer: 45)

• IMDb's best rating went to "The Bicameral Mind," the Season 1 finale. (IMDb: 97)

• IMDb's worst rating went to the series finale, "Que Será, Será," Season 4, Episode 8. (IMDb: 70)

Areas for Further Research

There are other ways to analyze the popularity of HBO's "Westworld," besides just the live viewership stats and the Tomatometer and IMDb ratings. These are a few examples:

• Awards and nominations received for "Westworld" : Wikipedia lists 29 wins and 112 nominations.
• Number of articles written about "Westworld" in various news outlets.
• Google Trends for searches related to "Westworld" compared to other HBO series at the same time.
• Number of subreddit members compared to other HBO shows and number of Reddit posts.