Visualize Netflix data with QuickSight

What is Amazon QuickSight?
Amazon QuickSight is a cloud-based business intelligence (BI)
service offered by Amazon Web Services (AWS) that enables
organizations to visualize their data and gain insights from it through interactive dashboards and report…


This content originally appeared on DEV Community and was authored by Kalsoom ahmed

What is Amazon QuickSight?
Amazon QuickSight is a cloud-based business intelligence (BI)
service offered by Amazon Web Services (AWS) that enables
organizations to visualize their data and gain insights from it through interactive dashboards and reports.

Why it’s useful:
Connect to Data Sources:QuickSight connects to avariety of data sources, including AWS services(Amazon S3, Redshift,RDS),on premises databases,and third-party sources like Salesforce, MySQL,PostgreSQL, and more.
Upload your dataset and a manifest.json file into S3

  • S3 is used in this project to host the files that will be analysed byAmazonQuicksight.

  • I edited the manifest.json file by changing the URL in the manifest file.

Image description

Create yourAmazonQuicksight account

  • Go on search bar and type Quicksort and click on that.

  • It doesn’t cost to create a quicksight account.

  • It took about 10 minutes to create the account considering the few errors I ran into.

  • I also had to enable QuickSight’s access to S3 because my dataset was saved in an S3 instance hence needed to interface it with Quicksight.

Image description
Connect S3 + QuickSight

  • I connected the S3 bucket to QuickSight by copying the
    manifest.json URI.

  • The manifest.json file was important in this step because it
    helps Quicksight find our dataset in our bucket and understand
    our data so it can represent i in charts and graphs.

Image description
Let’s make visualisations!

  • To create visualisation on QuickSight, you’ll have to drag a category to the AutoGraph dashboard

-The chart/graph shown here is a breakdown of the number of
movies released each year by their categories(movies/tv show)

  • I created this graph by having the release year on the y-axis and having the Type on group to show different colors for each category.

Image description

  • Filters are useful for specifying the variables and exact values
    you want to compare while excluding what you don’t want.

  • Here I added a filter by excluding movies and TV shows
    released before 2015.This helped me create a visualization on
    the three genres released from 2015.

Image description
Set up your dashboard!

  • As a finishing touch, I arranged my visuals in a good looking format

-Did you know you could export your dashboard as PDFs too? I
did this by clicking ‘Export’ and ‘Generate PDF’ then waiting for
it to prepare download.

Image description

My key learnings

  • An S3 bucket was used in this project to store the dataset
    and manifest.json file.

  • To connect the data stored in S3 with QuickSight, I had to
    link the manifest.json file URI to Quicksight.

  • It is easy to create visualizations in Quicksight and it is easy to navigate different toggles.

  • One thing I didn’t expect was the ease in creating
    visualizations and how it recommends if you put a graph in
    the Autograph.


This content originally appeared on DEV Community and was authored by Kalsoom ahmed


Print Share Comment Cite Upload Translate Updates
APA

Kalsoom ahmed | Sciencx (2024-09-13T20:33:31+00:00) Visualize Netflix data with QuickSight. Retrieved from https://www.scien.cx/2024/09/13/visualize-netflix-data-with-quicksight/

MLA
" » Visualize Netflix data with QuickSight." Kalsoom ahmed | Sciencx - Friday September 13, 2024, https://www.scien.cx/2024/09/13/visualize-netflix-data-with-quicksight/
HARVARD
Kalsoom ahmed | Sciencx Friday September 13, 2024 » Visualize Netflix data with QuickSight., viewed ,<https://www.scien.cx/2024/09/13/visualize-netflix-data-with-quicksight/>
VANCOUVER
Kalsoom ahmed | Sciencx - » Visualize Netflix data with QuickSight. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/09/13/visualize-netflix-data-with-quicksight/
CHICAGO
" » Visualize Netflix data with QuickSight." Kalsoom ahmed | Sciencx - Accessed . https://www.scien.cx/2024/09/13/visualize-netflix-data-with-quicksight/
IEEE
" » Visualize Netflix data with QuickSight." Kalsoom ahmed | Sciencx [Online]. Available: https://www.scien.cx/2024/09/13/visualize-netflix-data-with-quicksight/. [Accessed: ]
rf:citation
» Visualize Netflix data with QuickSight | Kalsoom ahmed | Sciencx | https://www.scien.cx/2024/09/13/visualize-netflix-data-with-quicksight/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.