Blockchain technology has revolutionized the way we think about data and finance, with Onchain analytics standing at the forefront of this transformation. To help participants explore the world of Web3 data analysis, Sixdegree Lab has carefully designed a comprehensive Dune-based onchain analytics course, covering everything from foundational concepts to advanced techniques.
This course is tailored to equip participants with the skills and knowledge necessary to navigate the blockchain data landscape, from basic queries to sophisticated analytical methods. Whether you are a beginner or an experienced professional, this course offers a well-rounded learning experience designed to meet your needs and help you excel in the field of onchain analytics.
The course is structured into three progressive modules, combining theory with hands-on practice to help participants comprehensively master Dune-based onchain analytics.
Module 1: Beginner Level
Lay a solid foundation by equipping participants with the essential skills needed for onchain data analytics.
Module 2: Intermediate Level
Focus on applying onchain analytics to real-world scenarios, enabling participants to analyze practical use cases effectively.
Module 3: Advanced Level
Empower participants with advanced analytical techniques and the ability to develop their own custom tools, taking their expertise to the next level.
By the end of the course, participants will:
5 Chapters / 27 Classes / 8H 20Mins
#0 Become Onchain Analyst
10Mins
#1 Dune platform introduction
15Mins
#2 Quick start
20Mins
#3 Build first dashboard
10Mins
#4 Understanding tables
20Mins
#5 SQL Basics Part1
20Mins
#6 SQL Basics Part2
20Mins
#7 Practice - Build Lens Dashboard (I)
20Mins
#8 Practice - Build Lens Dashboard (II)
10Mins
09 Useful Queries (I): ERC20 token price queries
20Mins
10 Useful Queries (II): Token holders, total supply, account balance
20Mins
11 Useful Queries (III): custom data, number sequence, array, JSON, etc
15Mins
12 NFT Analysis
20Mins
13 Lending Analysis
20Mins
14 DeFi Analysis
20Mins
15 Introduction to DuneSQL
20Mins
16 Blockchain Analysis - Polygon
20Mins
17 MEV Data Analysis - Uniswap
20Mins
18 Uniswap Multi-Chain Analysis
20Mins
19 Useful Metrics
20Mins
20 Blockchain Network Analysis
20Mins
21 Bitcoin Analysis
20Mins
22 How to Build a Spellbook
20Mins
23 Creating an Application Using Dune API
20Mins
AA-01 Explanation of Account Abstraction
20Mins
#AA 02 Account Abstraction Data Analysis
20Mins
#AA 03 AA Aggregation Table of EVM Chains
20Mins
Basic computer proficiency.
A foundational understanding of blockchain and cryptocurrencies.
Develop the ability to independently conduct Onchain data analysis.
Create data dashboards to visualize analysis results.
Master analytical methods for blockchain ecosystems like NFTs and DeFi.
Learn to build custom analytical tools using Dune API.
© 2025 OpenBuild, All rights reserved.