BETA
Back to courses
Share

Mastering Onchain Analytics: From Basics to Advanced Applications

This course is designed to guide blockchain enthusiasts from scratch to mastering Onchain Data Analytics. Through a structured learning path, participants will acquire the skills necessary to independently complete complex Onchain Data Analysis tasks and develop their own analytical tools.

Posted on Feb 19, 2025 16:10 · Latest update on Feb 21, 2025

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.


Course Objectives

  • Master the core skills of onchain data analytics.
  • Learn to use the Dune platform and SQL for querying and analyzing blockchain data.
  • Gain in-depth knowledge of analyzing blockchain ecosystems such as NFTs and DeFi.
  • Acquire advanced techniques such as network analysis and tool development.

Course Modules

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.

Learning Outcomes

By the end of the course, participants will:

  • Be proficient in conducting onchain data analysis.
  • Be able to create and interpret data dashboards.
  • Have an in-depth understanding of analyzing blockchain ecosystems.
  • Be capable of developing their own analytical tools using Dune API.

Chapters

5 Chapters / 27 Classes / 8H 20Mins

  • Chapters
  • Lessons
  • Duration
  • Progress
Chapter 1INTRODUCTION
1
10Mins

#0 Become Onchain Analyst

10Mins

Chapter 2ELEMENTARY
8
2H 15Mins

#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

Chapter 3INTERMEDIATE
11
3H 35Mins

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

Chapter 4ADVANCED
4
1H 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

Chapter 5Account Abstraction
3
1H 0Min

AA-01 Explanation of Account Abstraction

20Mins

#AA 02 Account Abstraction Data Analysis

20Mins

#AA 03 AA Aggregation Table of EVM Chains

20Mins

Speaker


Requirements

Basic computer proficiency.

A foundational understanding of blockchain and cryptocurrencies.


Take Away

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.

Product

  • Learn
  • Build
  • Developer Profile
  • On-Chain Contract & Payment

Community

  • Discord
  • Twitter
  • GitHub
  • Telegram
  • LinkedIn
  • Substack

Company

  • Apply for Cooperation
  • Terms of Use Agreement
  • Privacy Policy
  • Press Kit

© 2025 OpenBuild, All rights reserved.