On-chain Analytics
Course Index
28 Lessons · 3 Sections
Master blockchain data analytics — Dune SQL, Nansen smart money tracking, DeFiLlama, The Graph subgraphs, and Python web3.py. Covers Arkham entity labelling, mempool analytics & 3 production analytics builds.
28Lessons
3Sections
3Projects
FreeAccess
Section 1Blockchain Data Fundamentals & Dune AnalyticsLessons 1–10
Lesson 1
What is On-Chain Analytics?
Lesson 2
Reading Blockchain Data: How Works
Lesson 3
Block Explorers: Etherscan & Solsc
Lesson 4
Reading Transactions on Etherscan
Lesson 5
Tracking Wallets & Addresses
Lesson 6
Dune Analytics: Setup & SQL Basics
Lesson 7
Dune SQL: Querying Blockchain Data
Lesson 8
Building Dune Dashboards
Lesson 9
Nansen: Smart Money Tracking
Lesson 10
Glassnode: Bitcoin & Macro Metrics
Section 2Analytics Platforms, DeFi & Advanced TechniquesLessons 11–22
Lesson 11
DeFiLlama: TVL & Protocol Data
Lesson 12
Token Terminal: Revenue & Fees
Lesson 13
Arkham Intelligence: Entity Labels
Lesson 14
The Graph: Indexing with Subgraphs
Lesson 15
Flipside Crypto & Bitquery
Lesson 16
Tracking DeFi Flows: TVL & Liq
Lesson 17
NFT Analytics: Sales & Volume
Lesson 18
Token Holder & Whale Analysis
Lesson 19
Mempool Analytics
Lesson 20
On-Chain Metrics: MVRV, SOPR & NUPL
Lesson 21
Airdrop Eligibility Analytics
Lesson 22
Forensic Analytics: TX Tracing
Section 3Python, Custom Indexers & ProjectsLessons 23–28