Web3 Analytics 101: Live Course
An open, weekly course that teaches students how to understand and analyze blockchain data using SQL
Last updated
Was this helpful?
An open, weekly course that teaches students how to understand and analyze blockchain data using SQL
Last updated
Was this helpful?
This live course is designed for students who want to answer questions with data, provide context to protocol growth and change, and understand what is happening behind the scenes.
The goal of this live course is to take interested students and teach them the requisite knowledge to be a data analyst in web3. Our goal is that students emerge from the course with an intermediate level of knowledge. We define that as being able to confidently tackle challenges with tools such as Flipside, Dune, Footprint, Dapplooker, etc. While a "beginner" analyst may be limited to high-level overviews, an "intermediate" analyst is able to push beyond surface-level analysis, extracting insights from curiosity-directed exploration.
In short, a successful course will produce a cohort of talented analysts creating great content and actively competing in bounty programs. We will explore Ethereum data throughout this course as it has the most robust tooling and data available. Core concepts can be applied across a range of EVM-compatible chains and alternate blockchains.
We will meet weekly from November to December 2022 for a live session. Sessions will be recorded. If you have been accepted, be sure to attend the first live session to let us know that you intend to take the rest of the live course! An overview of each segment is available below.
Each week will have accompanying assignments. These will reinforce concepts covered in each live session. The assessment may be a quiz or an analytical prompt that requires querying blockchain data and producing a dashboard or a report. Additionally, members of the course operations team will hold Office Hours weekly in our Discord Server to assist with questions related to the prior week's course. Finally, please actively use the #course-chat channel in MetricsDAO's Discord, under the Education section, to help each other out!
The following is intended to set expectations about the content of this course, while the content covered will go into more depth than what is listed.
We have compiled vetted resources that students can dive into, on their own time, to get up to speed with the main topics that this course covers: blockchains and crypto, data analysis using SQL, working in web3, etc. Yes, the content is the same as those used for the async course. It is because these fundamental topics remain valid regardless of the course format. See more on the nested page, Finally, find some MetricsDAO resources here:
Establishing foundational knowledge
Money
Store of value
Bitcoin
Blockchain mechanics, distilled
What is Ethereum?
What is Web3?
What tools and data are out there?
Accessing curated datasets and using SQL to explore blockchain data
Why do this type of work?
The analytics ecosystem and work2earn
Expand technical abilities with live use cases.
Available data
Exploratory analysis and understanding what we're looking at
Observing trends with high-level aggregations
Comparing Ethereum transactions in data tables to block explorers
Domain knowledge - understanding your subject
Exploring data through visual representations
Introducing intermediate SQL techniques and diving into (more) raw transaction data.
SQL Aggregations - benefits and pitfalls
Data, uncurated
Moving beyond ez_ tables working with JSON message objects
SQL syntax: Dune Engine V2 vs. V1
Column-oriented data
Using Dune abstractions
Cross-chain analysis
how to get started.
how to get noticed.
how to progress in one’s career.
We will primarily use and . I suggest signing up for both websites (for free) and familiarizing yourself with them!
Expert session led by Dune Wizard .
In the closing session of the course,known industry experts who successfully created web3 careers give pointers on