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

Preview ended
Watch the full recording on the platform
Workshops are free for members. Sign in to keep watching: all 10 chapters, 70 min.
This recording is on the platform.
Watch on the platform (opens the OCF platform in a new tab)What's inside
10 chapters, 70 min. The preview plays the first 5 minutes here; the full recording is on the platform.
Chapters
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
-
Research & Content Lead, Dune (opens in a new tab)
-
More workshops
All workshops-

-

21 Oct 2026Tax & reporting
Crypto-Asset Reporting Framework (CARF) with ht.digital
Laeeq Shabbir, Omair Butt (ht.digital)
-

29 Apr 2026Accounting
Statement of Digital Assets (SoDA) Reports
Samuel Leichman, Kale Wright (Overland Blockchain Group)