What is Amazon QuickSight?
Amazon QuickSight is a cloud-powered business intelligence (BI) and data visualization service offered by AWS. It allows users to easily create and analyse interactive dashboards, reports, and visualizations from various data sources.
How I used Amazon QuickSight in this project
I used it to visualize Tv shows and Movies from Netflix based on some of the grouping and labels from the dataset available. I represented those data in different graphs and tables of my choice.
One thing I didn’t expect in this project was…
I did not expect for it to be as fun and tasking. It took longer than expected because of the filter and many options to pick from.
This project took me…
I spent almost 2 hours on it.
Upload project files into S3
My S3 bucket here is used in this project to store two needed files, which are the manifest.JSON and netflix.csv file
I created the bucket, using all the default settings and named it “network-quicksight-timi”
Ensure the email used is the same as the email on your AWS Account.
Make sure to select Amazon s3, adding the right bucket that was created earlier.
Now I have successfully created a QuickSight account
My first visualization
To create visualizations on QuickSight, I would need to paste the correct object URL to the manifest.JSON file and select the graph I want and how I want it to visualise the available fields and grouping.
With QuickSight, you can sort, filter, and customise your data top create visualisations. You can also experiment with different types of graphs like bar charts, pie charts, line graphs, etc.. You can see on the left hand panel that the dataset’s fields are already imported.
To create my first visualization, I dragged Release_year into the Y-Axis heading. Now I can see a breakdown on the year that these Netflix-featured TV shows and movies were released
To create a new visual, I selected + ADD under the Visuals heading on my middle navigation bar, and another blank frame pop out.
So I can see a breakdown of TV shows vs movies for every year, I dragged the release_year label into the Y Axis heading. Next, I dragged the type label into the Group/Color heading.
The donut chart (a type of pie chart) shown below is a breakdown of the release year of Netflix shows while the bar chart shows the records by the Release_year and the type of the Netflix shows.
An Image showing The Fields that can be used to filter the data.
This visualization is a breakdown of the TV shows and movies with the listing ‘Action & Adventure’, ‘TV Comedies’, or ‘Thrillers’, how many were released on 2015 or after. Here I added a filter by selecting Release_year (2015–2021) and Genre (Action & Adventure, TV Comedies and Thrillers).
Here are some of the questions the remaining graphs on my dashboard are answering.
· A breakdown of TV shows/movies for each release year. Would it be possible to stack movies and TV shows in the same row, so you can visualise the % of each?
· Now can you show me the same thing in a table? i.e. please show me the number of movies vs TV shows per release year in a table.
· On what day did Netflix add the largest number of movies/TV shows to their catalogue
· Of the TV shows and movies featured, how many were listed as ‘Action & Adventure’, ‘TV Comedies’, or ‘Thrillers’? For simplicity, ignore the TV shows and movies that have multiple listings/categories
SOCIAL SHARE CARD GENERATOR