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

## 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, [Netflix TV Shows and Movies](https://drive.google.com/file/d/1tArs8jg-SvzZrtVEGFxZfNwfuzb35p0Q/view?usp=sharing), a kaleidoscope of Netflix entertainment, invites you to unleash your analytical instincts.

<figure><img src="https://3609544510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLgM8PSPyH0bZpKcygbid%2Fuploads%2F8Ph8HnTqsVeKzDcTxZ5Y%2FScreenshot%202024-02-22%20at%2002.39.26.png?alt=media&#x26;token=43a8b0b4-4908-435d-ad8d-80cd15268c34" alt=""><figcaption><p>Dataset from <a href="https://www.kaggle.com/datasets/thedevastator/netflix-imdb-scores">Netflix IMDB Scores</a> by Kaggle</p></figcaption></figure>

## Start the expedition with Graphtor Beta

* Sign up for Graphtor: Start here 👉  [**beta.graphtor.io**](https://beta.graphtor.io/)
* Download a sample CSV
  * [Netflix TV Shows and Movies](https://drive.google.com/file/d/1tArs8jg-SvzZrtVEGFxZfNwfuzb35p0Q/view?usp=sharing) (direct link to CSV)
* Create a **Datasource**
  * The dataset **type CSV** and **U**pload the file to Graphtor beta, and then **Publish**.

<figure><img src="https://3609544510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLgM8PSPyH0bZpKcygbid%2Fuploads%2FfHgIwqMPJgJLlvFTta80%2FCreate%20a%20Datasource.gif?alt=media&#x26;token=812c4aa4-7afe-4336-b754-45a24a4f0aac" alt=""><figcaption><p>Create a Datasource with CSV in Graphtor Beta</p></figcaption></figure>

* **It's time to create a Chart:**&#x20;

<figure><img src="https://3609544510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLgM8PSPyH0bZpKcygbid%2Fuploads%2Fkr83XbL1ElSd0xUO6npE%2FCreate%20a%20Chart-2.gif?alt=media&#x26;token=77e00d21-37af-465e-9f74-375152b3c90c" alt=""><figcaption><p>Create a Chart in Graphtor Beta</p></figcaption></figure>

### Analysis Suggestion for this Case

* <mark style="color:green;">**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?**</mark> Experiment with the **SQL Query Editor** to manipulate the dataset and review the **results table**.&#x20;

### Try this **Query**:

{% code lineNumbers="true" %}

```sql
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;          
```

{% endcode %}

* &#x20;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.

<figure><img src="https://3609544510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLgM8PSPyH0bZpKcygbid%2Fuploads%2FRgM68txF9tKDr1cd0hRI%2FSQL%20editor.gif?alt=media&#x26;token=63abfe24-4771-480a-8079-33a9c0b2345a" alt=""><figcaption><p>Data exploration in Graphtor Beta</p></figcaption></figure>

### **Visualization: Crafting Your Chart** 📊&#x20;

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

<figure><img src="https://3609544510-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FLgM8PSPyH0bZpKcygbid%2Fuploads%2F2uMJrIO930meiBsfdeFa%2FCharts.gif?alt=media&#x26;token=d1c38fa6-da94-4ce9-bc81-2809f2ac8046" alt=""><figcaption><p>Visualization in Graphtor Beta</p></figcaption></figure>

### How would you describe your overall experience with Graphtor Beta? &#x20;

* We're all ears and eyes for your Chart in our [Discord channel 📝🗣・feedback](https://discord.gg/k6wGEk4wmw), or email us at <mark style="color:purple;">`[beta@fensteranalytics.com]`</mark> with your feedback and Chart captures.
* 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 <mark style="color:green;">exclusive Graphtor SWAG</mark>! <mark style="color:purple;">**Thank you**</mark> for your pioneering spirit and for joining us to delve deeper into the Graphtor Beta journey.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.graphtor.io/graphtor-beta/example-1-imdb-scores-of-netflixs-tv-shows-and-movies-treasures.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.