🦖
Graphtor Beta
  • 🚀Dive into the Beta Expedition
  • 🧰Beta Testers' Quickstart
  • 📈Example 1: IMDB Scores of Netflix's TV Shows and Movies Treasures
  • 📊Example 2: The Oldest Business Dinosaurs of the World
  • 🏆Data Raptor Champions
    • 🎬Week 1: Netflix IMDb Score
Powered by GitBook
On this page
  • Overview
  • Dataset 🦕
  • Start the expedition with Graphtor Beta
  • Analysis Suggestion for this Case
  • Try this Query:
  • Visualization: Crafting Your Chart 📊
  • How would you describe your overall experience with Graphtor Beta?

Example 1: IMDB Scores of Netflix's TV Shows and Movies Treasures

Here's your beta test dataset, for you expedition with Graphtor's beta features, feel free to experiment. Your feedback will be the beacon that guides us!

PreviousBeta Testers' QuickstartNextExample 2: The Oldest Business Dinosaurs of the World

Last updated 1 year ago

Overview

Welcome, data raptors, to the beta testing with Graphtor. Your goal is to harness Graphtor Beta's mighty visualization features and SQL prowess to map out the intricate patterns within the Netflix ecosystem. Your insights will illuminate the path for fellow beta tester adventurers and shape the evolution of Graphtor, ensuring it is the velociraptor in the data visualization domain.

Dataset 🦕

This CSV dataset, , a kaleidoscope of Netflix entertainment, invites you to unleash your analytical instincts.

Start the expedition with Graphtor Beta

  • Download a sample CSV

  • Create a Datasource

    • The dataset type CSV and Upload the file to Graphtor beta, and then Publish.

  • It's time to create a Chart:

Analysis Suggestion for this Case

  • What is the average IMDb score and the total count of titles for each type and release year among titles that have received 100 or more IMDb votes? Experiment with the SQL Query Editor to manipulate the dataset and review the results table.

Try this Query:

SELECT
  release_year, 
  type,
  AVG(imdb_score) AS average_imdb_score,  -- Average IMDb rating
  COUNT(*) AS title_count  -- Total count of titles
FROM
  csv_table
WHERE
  imdb_votes >= 100  -- Includes only titles with at least 100 votes on IMDb
GROUP BY
  release_year,  -- Groups the results by release year
  type           -- and by type
ORDER BY
  release_year ASC,  
  type ASC;          
  • Remember to select your data source before writing your SQL query. Click on "Save & Preview" to view the results table. Gain a comprehensive understanding of the data to craft your first chart.

Visualization: Crafting Your Chart 📊

  • Go to the Visualization tab, select Chart, and choose your chart type. Remember to click Save & Preview to see your changes and when configuring your Chart with aggregations or organizing your data.

  • Although many other features and settings exist to experiment with, take your time. Then go to the hamburger icon to download your Chart and share it with us.

How would you describe your overall experience with Graphtor Beta?

  • Then, we will send you a link with a survey so you can leave us your information. This way, we'll send you our git, an exclusive Graphtor SWAG! Thank you for your pioneering spirit and for joining us to delve deeper into the Graphtor Beta journey.

Sign up for Graphtor: Start here 👉

(direct link to CSV)

We're all ears and eyes for your Chart in our , or email us at [beta@fensteranalytics.com] with your feedback and Chart captures.

📈
beta.graphtor.io
Netflix TV Shows and Movies
Discord channel 📝🗣・feedback
Netflix TV Shows and Movies
Create a Datasource with CSV in Graphtor Beta
Create a Chart in Graphtor Beta
Data exploration in Graphtor Beta
Visualization in Graphtor Beta
Dataset from by Kaggle
Netflix IMDB Scores