OTT Media Analytics with Tableau: Exploring Nested TreeMap and HeatMap

A guided case study with OTT media data in Tableau

Image from Unsplash

Nowadays OTT Platform is very famous. Due to COVID, all theatres and cinema halls are closed and OTT is one of the key platforms to entertain the audience.

In this blog, we will do data analysis step by step with Amazon Prime’s data using Tableau.

Table of Contents

1. Data Set

2. Abstraction

3. Learning Objective

4. Import Data

5. Create Calculated Field

6. Data Visualization

7. Conclusion

Data Set

I have taken the data from Kaggle. Please find the below link.Amazon Prime MoviesMovies available on Amazon Prime Videowww.kaggle.com

Abstraction

The dataset (amazon prime movies.csv) consists of 7 variables with 8127 records.

Image by author

The variables provide the insights about

  1. Movie Name: Name of the Movie
  2. Language: Audio language of the Movie (some movies are dubbed in multiple languages)
  3. IMDb Rating: The rating a movie received in the IMDb Platform
  4. Running Time: Total running time of the movie in hours and minutes
  5. Year of Release: The year in which a movie was released in the theatres or on Amazon Prime for Amazon Prime Originals Movies
  6. Maturity Rating: Specifies the target audience.
  7. Plot: This column contains a short summary of the movie’s plot.

The below description is for Maturity Rating values.

  1. All: Appropriate for Kids
  2. 7+: Appropriate for Older Kids
  3. 13+: Appropriate for teens
  4. 16+: Appropriate for Young Adults
  5. 18+: Appropriate for Adults
  6. NR: Unrated

Learning Objective

The primary objectives of this case study are following

Functional Objectives: We will create 4 reports and one dashboard.

  1. Total Moview based on Language and Maturity Rating
  2. Top 10 Movie based on IMDb Rating
  3. Yearly Movie Trend as per Language
  4. Total Movies & Average IMDB Rating by Language and Maturity Rating

Technical Objectives: We will learn the following items in Tableau.

  1. How to create Group
  2. How to create Calculated Field
  3. Converting field to Dimension from Measure and vice-versa.
  4. How to create Nested Tree Map
  5. How to create Heat Map
  6. How to create a Column chart and Trend chart
  7. Create Dashboard

Import Data

· Open Tableau Public and go to Connect → Select Text File under To a File

· Select the file named “amazon prime movies.csv”

· After selecting the file, data will be displayed under the Data Source tab.

Image By Author

Data Processing

To process the data for effective visualization, we need to perform the below steps.

  1. Click on “Year of Release” -> Select Convert to Dimension and transform dimension from the measure.
  2. We observed IMDb Rating field is considered as a string data type due to its None value.
  3. Create “Calculated IMDB Rating” with the below steps.
Image by Author

4. Change the data type of “Calculated IMDB Rating” to Numer (Decimal) from String.

5. Create one Group based on Running Time. Consider the following conditions. (a) Below 1 hr, (b) Between 1 and 2 hr, ( c) Between 2 and 3 hr (d) 3 hr and Above

Image by Author

6. Create two measures Total Movies and Average IMDB Rating using the Calculated Field feature.

Image by Author

Data Visualization

Report 1: Nested Tree Map

TreeMap is used to display data in nested rectangles in attractive ways.

  1. Select Total Movies as measure and Maturity Rating as dimension → Click on treemaps from Show Me
Image by Author

2. Drag the Language field on the Color mark and Total Movies on the Label Mark.

3. Rename the sheet name to display the title as “Total Moview based on Language and Maturity Rating”. Format the title text based on your choice.

Image by author

Report 2: Column Chart (Vertical Bar)

Column Chart displays the comparison between items.

  1. Select Average IMDB Rating as measure and Movie Name as dimension → Click on the horizontal bar from Show Me
  2. Click on “Swap Rows and Columns” from the top bar and make the chart a vertical bar. This is now Column Chart.
  3. Now drag Movie Name to the Filters section.
  4. Select filter condition “Top” and check the “By field” option with Top 10 by Average IMDB Rating condition.
  5. Change the chart color using the color mark and rename the title with font formatting.
  6. Top 10 Movie based on IMDb Rating” report is ready.
Image by Author

Report 3: Trend Chart (Line Chart)

The Line Chart is used to show trends or progress over time.

  1. Select and click on Year of Release and select Convert to Continuos
  2. Select Year of Release and Total Movies and click on lines from the Show Me section
  3. If you see the Null indicator, click on it and hide the indicator.
  4. To put some variation in the chart, add the Language column in the Color Mark
  5. Provide some meaningful Title and format it like before.
  6. Yearly Movie Trend as per Language report is ready to serve.
Image by Author

Report 4: Relationship Chart (Heat Map)

Heat Map shows the relation between two items in the form of shape or icon size.

  1. Select LanguageAverage IMDB Rating, and Total Movies, then click on heat maps from the Show Me section
  2. Make it Entire View mode to display in an attractive manner.
  3. Now add Maturity Rating on the Columns shelf.
  4. Provide some meaningful Title and format it like before.
  5. Total Movies & Average IMDB Rating by Language and Maturity Rating analysis is ready.
Image by Author

Dashboard: Amazon Prime Movies Analysis

  1. Click on New Dashboard and create the first dashboard of this project
  2. Drag and drop four reports from the Sheets section to the dashboard canvas area and arrange those based on your choice.
  3. Make sure all the reports are displayed in Entire View mode.
  4. Click on Show Dashboard Title from the left panel under the Objects section.
  5. Add proper dashboard title with required formatting and Amazon Prime Movies Analysis dashboard is ready to present.
Image By Author

Conclusion

In this case study, we learn about different functional and technical items. We can very well add more reports and dashboards to this project. As well as we can perform more formatting in terms of look and feel purpose.

Link for my Tableau Public Profile

Arpita Ghosh — Profile | Tableau Public

If you like this blog, please provide your feedback in the comment section.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: