Kaia with Dune Workshop Highlights

Decode Kaia with Dune Workshop Highlights

Who caught the “Decode Kaia with Dune” workshop? It was packed with insights! :light_bulb:

Start here for Kaia data on Dune: https://dune.com/chains/kaia
Full recording on YouTube: https://www.youtube.com/watch?v=K1rG1yp4OeA
Recording on X: https://x.com/BuildonKaia/status/1962485703872532957

1) What is Dune?

:blue_circle: Analytics Studio: build & share dashboards

:orange_circle: Data Streams: pipe Dune’s data into your database

:green_circle: Dune Engine: real-time APIs for developers

2) Table types you will use

:blue_circle: Raw Data: transactions, logs, traces

:orange_circle: Decoded Projects: human-readable data for specific contracts

:green_circle: Curated Data: cleaned & aggregated tables for DEXs, NFTs, and more ~

3) Don’t start from scratch — use “Fork” :rocket:

Clone any query or even an entire dashboard, tweak it, and make it yours. The fastest way to learn and ship! ~

4) Dashboarding 101 — readability first :eyes:

:sparkles: Format numbers, for example 1M or add a dollar sign when needed.

:memo: Add parameters so users can filter by timeframe (daily, weekly, monthly) for interactive analysis.

5) Level up presentation :up_button:

:card_index_dividers: Organize: use text widgets for titles, notes, and logos to create clean sections.

:artist_palette: Customize: adjust chart colors to match your brand or highlight key trends.

6) Performance tip :high_voltage:

Filter early by block_number or a time range (block_time) in your WHERE clause.
You will scan less data and the query will run much faster.

7) Decoded vs Curated — when to use which

:right_arrow: Use Decoded Projects for deep dives into a specific protocol’s unique functions (e.g, staking events).

:right_arrow: Use Curated Data (like dex.trades) for high-level analysis and comparing activity across multiple projects.

8) Docs

If you get stuck, the docs have your back:
:books: Dune Docs: https://docs.dune.com/home
:books: Kaia data overview: https://docs.dune.com/data-catalog/evm/kaia/overview

1개의 좋아요