get-started

Get Started

Dive into blockchain insights in just 5 minutes! This guide will equip you with the essentials to unlock the power of Flipside Studio. We'll go over how to:

1. Explore Flipside's Data
2. Query data on Flipside
3. Create a chart
4. Build a dashboard to share your insights

{% hint style="info" %} Before we begin, make sure you have a Flipside account ready! If not, you can sign up for free here. {% endhint %}

---

Explore the data

Steps:

1. Launch the Studio
2. Click on the database icon to access data on 26+ protocols
3. Quick introduction to how Flipside's data is organized:
   • Hierarchy: blockchain → schemas -> tables
   • Read more on our data modeling approach here.

Data exploration tips:

• Column details: click on a table to see it's columns, and a data type for each.

• Table details: hover over a to see the description and link to documentation.

• Table preview: see sample data without writing any SQL by clicking the Preview icon.

• Add to query: enter any table name into your SQL with a single mouse click.

• View docs: hover over a database name and click the "book" icon to go direct to docs.

---

Query data on Flipside

Steps:

1. Head to flipside.new or launch the Studio and click "+" to create a new query.
2. Write some SQL! Unsure where to start? Explore our sample query below for inspiration.
3. Hit "Run Query" (or CMD+ENTER on Mac / CTRL+ENTER on PC/Linux).

-- Top 8 NFT platforms on Ethereum by total sales in the past 30 days
select
  platform_name,
  count(*) as sales_count
from ethereum.nft.ez_nft_sales
where block_timestamp > current_date - interval '30 days'
group by platform_name
order by sales_count desc
limit 8

---

Create a Chart

Steps:

1. Click "Create Visualization" button right next to your query title.
2. Choose the chart type that best captures your data's essence. Bar, line, pie?
3. Define the data points by setting your X and Y axes.

---

4. Build a Dashboard to share your insights

Steps:

1. Add your chart to a new or existing dashboard.
2. Title your dashboard
3. Any finishing touches: adjust layout, add header, text boxes, images!
4. Publish (don't worry you can always unpublish)
5. Share by posting on Twitter/X or via URL.