Skip to content

Live workshopOnchain NAV for Tokenized Assets with Octav (opens in a new tab)

Starts Wednesday 18 November, 12:00 PM ET

Register: Onchain NAV for Tokenized Assets with Octav (opens the OCF platform in a new tab)
All workshops
Past workshop ToolsCPE/CPD: 1

Beginner’s Guide to Onchain Analytics with Dune

Public blockchains hold a goldmine of verifiable financial data, if you know how to tap it. Learn the basics of Dune for verifying client transactions, preparing statements, audits and DeFi exposure

Filippo Armani and Roderick McKinley

What's inside

10 chapters, 70 min. The preview plays the first 5 minutes here; the full recording is on the platform.

Chapters

10 chapters · 3 in the preview

About this workshop

Blockchain data is built for machines, not accountants. Public chains hold the economic information finance teams need, but it comes in small technical pieces that take real work to shape into something you can analyse. Dune indexes data from more than 100 blockchains into tables you can query with SQL.

Filippo Armani (Research & Content Lead, Dune) and Roderick McKinley (DeFi Risk & Onchain Analytics Consultant) gave the vendor's view and an independent practitioner's view of the same platform. They covered how blockchain data differs from an accounting ledger, how to find and reuse existing work on Dune, and how Sky, Franklin Templeton, Lido and Arbitrum DAO publish financial reporting there. Roderick closed with how to use AI to write and check queries.

What you'll learn

  • Why blockchain data differs from an accounting ledger, and why the gap between data and insight is still real work
  • How queries, charts and dashboards fit together, and why you fork an existing query instead of starting from scratch
  • The three levels of Dune tables (raw, decoded and curated) and why beginners should start with curated
  • How to read the SQL and lineage behind a dashboard to check what it claims
  • How to set up a ChatGPT project with table schemas, contract code and documentation so AI writes better queries

Who it's for

Accountants, auditors and finance teams who want to verify transactions, treasury positions or DeFi exposure from public blockchain data.

Meet the speakers

More workshops

All workshops

Choose which cookies and similar technologies (local storage, embedded players) we may use. You can change this at any time from "Cookie settings" at the bottom of every page.

Strictly necessary

Remembers this choice. Always on.

Always on