Visualize Netflix data with QuickSight

kalsoom_ahmed_048978ab5ac

Kalsoom ahmed

Posted on September 13, 2024

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 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.

💖 💪 🙅 🚩
kalsoom_ahmed_048978ab5ac
Kalsoom ahmed

Posted on September 13, 2024

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

Visualize Netflix data with QuickSight
webdev Visualize Netflix data with QuickSight

September 13, 2024