📊Example 2: The Oldest Business Dinosaurs of the World

Your beta test pack is ready with all you need to explore Grantor's wild features; feel free to experiment. We can't wait for your roars of feedback!

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:

Dataset from "What and Where Are the World's Oldest Businesses"

Start the expedition with Graphtor Beta

• Sign up for Graphtor: Start here 👉 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

  • Snag the Document ID from the URL, in this case, is:

    1tbJB64UBH0kwQONTz73NssW6CDY9vBR6KiTEITzz5sc

Connect Google Sheet Datasource in Graphtor Beta

A Quick Dino Fact: Check out this URL example: It's a direct gateway to a specific Google Sheets documenthttps://docs.google.com/spreadsheets/d/1tbJB64UBH0kwQONTz73NssW6CDY9vBR6KiTEITzz5sc/edit#gid=1526951718 But the orange text in the URL:"1tbJB64UBH0kwQONTz73NssW6CDY9vBR6KiTEITzz5sc"is de the document ID, acts as a unique identifier, letting Graphtor swoop in and gather the essential data for analysis and visualization.

Analysis Suggestion : Unify data and start exploring and analyzing

• To experiment 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:

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;

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.

Data Exploration with SQL query in Graphtor Beta

Crafting Your Visualization: 📊

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

Visualization in Graphtor Beta

How would you describe your overall experience with Graphtor Beta?

• We're all ears and eyes for your Chart in our Discord channel 📝🗣・feedback, or email us at [[email protected]] 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 exclusive Graphtor SWAG! Thank you for your pioneering spirit and for joining us to delve deeper into the Graphtor Beta journey.

🧰Beta Testers' Quickstart