PROGRAM 12: Analysis of Amazon Prime Dataset
i) Create a Donut chart to show the percentage of movie and tv shows
ii) Create area chart to shows by release year and type
iii) Create a horizontal bar chart to show Top 10 genre
iv) Create a map to display total shows by country
v) Create a text sheet to show the description of any movie/movies.
vi) Build an interactive Dashboard.
Step1: Upload the Amazon CSV dataset.
Step2: Transform data and make the data ready for reporting.
As part of Transformation remove you can remove blank, null values and
remove columns which is not required for analysis.
Step3: Select close and apply.
i).Create a Donut chart to show the percentage of movie and tv shows
From the Visualizations pane, select the Donut chart.
Drag the 'Type' field to the Legend section.
Drag any suitable column (e.g., ID or Title) to Values, then set the
aggregation to Count.
Use filters to filter only movie and TV [Link] will show the
percentage of Movies vs TV Shows.
Dept. of ISE 85
Downloaded by Ballari Ramesh (ballariramesh0825@[Link])
ii) Create a area chart to shows by release year and type.
Ensure your dataset contains a Release Year column and a Type column
(Movies/TV Shows).
Steps to Create Area Chart:
Choose Area chart from the Visualizations pane.
Drag the 'Release Year' field to the Axis section.
Drag the 'Type' field to Legend.
Drag the Title (or other identifying fields) to Values(Y Axis), and set the
aggregation to Count.
You’ll now see an area chart with Movies and TV Shows distributed over the
years.
Note: Use filters to filter only movies and TV show.
iii. Create a horizontal bar chart to show Top 10 genre.
Note: Make sure you have a Genre column in your dataset.(Rename the column
listed in to Genre)
Dept. of ISE 86
Downloaded by Ballari Ramesh (ballariramesh0825@[Link])
Steps to Create Horizontal Bar Chart:
From the Visualizations pane, select Bar chart and adjust it to display
horizontally.
Drag the Genre column to the Axis section.
Drag the Title (or other identifier) to Values, and set the aggregation to Count.
In the Filters pane, filter the Top N to display the Top 10 Genres by the count
of content.
From the Visualizations pane, select Bar chart and adjust it to display
horizontally.
iv. Create a map to display total shows by country.
Make sure you have a country column in your dataset.
Steps to Create a Map:
Choose Filled Map from the Visualizations pane.
Write a new measure to count show id
count showid = count(amazon_prime_titles[release_year])
Drag the Country field to the Location section.
Check the count showed measure in the data pane.
This will show a world map representing the total number of shows produced
in each country.
Dept. of ISE 87
Downloaded by Ballari Ramesh (ballariramesh0825@[Link])
iv) Create a text sheet to show the description of any movie/movies.
Ensure your dataset has a Description column for each movie/TV show.
Choose Table from the visuals and check the title and description
columns. You can add slicer to search by title to get the description.
Dept. of ISE 88
Downloaded by Ballari Ramesh (ballariramesh0825@[Link])
v) Build an interactive Dashboard:
Dept. of AIML 89
Downloaded by Ballari Ramesh (ballariramesh0825@[Link])