# Example 2: The Oldest Business Dinosaurs of the World

## Overview

The beta testing task aims to track down the oldest, most resilient businesses that, like dinosaurs, have survived and evolved through the ages. We'll harness the power of Graphtor to dive into a dataset compiled by BusinessFinancing.co.uk. We'll unearth the mightiest Business Dinosaurs that have stood the test of time through view charts and SQL query expeditions.

## Dataset 🦕

This dataset is the digital excavation site where we unearth the stories of the world's oldest "business dinosaurs" through three tables:

<figure><img src="/files/4adQzEPZe49E3HM2uYvz" alt=""><figcaption><p><em>Dataset from</em><a href="https://www.kaggle.com/datasets/manuelandresespitia/what-and-where-are-the-worlds-oldest-businesses">  <em>"What and Where Are the World's Oldest Businesses"</em></a> </p></figcaption></figure>

## Start the expedition with Graphtor Beta

* Sign up for Graphtor: Start here 👉  [**beta.graphtor.io**](https://beta.graphtor.io/)
* Ready to visualize? To start, Create a Chart.
* Select a Create a **Datasource**
  * The dataset **type** is **Google Sheet**: [The dinosaurs of the business world](https://docs.google.com/spreadsheets/d/1tbJB64UBH0kwQONTz73NssW6CDY9vBR6KiTEITzz5sc/edit?usp=sharing)
  * Snag the **Document ID** from the URL, in this case, is:&#x20;

    <mark style="color:orange;">`1tbJB64UBH0kwQONTz73NssW6CDY9vBR6KiTEITzz5sc`</mark>

<figure><img src="/files/eqgxJV9TfntIXyaertPX" alt=""><figcaption><p>Connect Google Sheet Datasource in Graphtor Beta</p></figcaption></figure>

{% hint style="info" %}
**A Quick Dino Fact:** Check out this URL example: \
It's a direct gateway to a specific Google Sheets document`https://docs.google.com/spreadsheets/d/`<mark style="color:orange;">`1tbJB64UBH0kwQONTz73NssW6CDY9vBR6KiTEITzz5sc`</mark>`/edit#gid=1526951718`\
\
`But` the <mark style="color:orange;">orange</mark> text in the URL:<mark style="color:orange;">`"1tbJB64UBH0kwQONTz73NssW6CDY9vBR6KiTEITzz5sc"`</mark>is de the document ID, acts as a unique identifier, letting Graphtor swoop in and gather the essential data for analysis and visualization.&#x20;
{% endhint %}

## Analysis Suggestion **:** Unify data and start exploring and analyzing

* **To e**xperiment with the SQL Query Editor, manipulate the dataset, and then go through the results. With just one SQL query in the Graphtor SQL editor, you can unify information like the foundation year, industry categories, and country of origin.

### Try this **Query**:

{% code lineNumbers="true" %}

```sql
SELECT    
    b.business_name,
    b.year_founded,
    c.category_name,
    co.country_name,
    co.continent
FROM businesses b
INNER JOIN categories c ON b.category_code = c.category_code     -- Join with categories to get category names
INNER JOIN countries co ON b.country_code = co.country_code      -- Join with countries to get country names and continents
ORDER BY 
b.year_founded ASC;
```

{% endcode %}

Now, you'll review be able with the **results table**, you can dive deep into the data, gaining a comprehensive understanding that adds rich context for crafting your first chart.

* Click on "Save & Preview" to view the results table. Gain a comprehensive understanding of the data to craft your first chart.

<figure><img src="/files/968oHlkOVXGx06CwZ80r" alt=""><figcaption><p>Data Exploration with SQL query in Graphtor Beta</p></figcaption></figure>

### **Crafting Your Visualization:** 📊&#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="/files/WSS0gIDITRSBdJVpbKAW" 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.

{% content-ref url="/pages/d5NE218iYVJhXWsztjPt" %}
[Beta Testers' Quickstart](/graphtor-beta/beta-testers-quickstart.md)
{% endcontent-ref %}

##


---

# 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-2-the-oldest-business-dinosaurs-of-the-world.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.