📈
MetricsDAO
  • The DAO for Web3 Analytics
  • MetricsDAO Ecosystem
    • Labor Markets Docs
    • Metrics App Docs
    • Metrics App Walkthrough
    • xMETRIC
    • xMETRIC Masters
  • NETWORKS
    • Quickstart: Make a Network
    • Networks 101
    • Network List
  • Operations
    • Constitution
    • Team Structure
      • Governor and Genesis Councils
      • Treasury
    • Tooling and Processes
    • Code of Conduct
    • Partners
    • Brand Assets
    • Directory
  • Education
    • Education Overview
    • MetricsDAO Courses
    • 🧑‍🏫Web3 Analytics 101: Async Course
    • 🧑‍🏫Web3 Analytics 101: Live Course
      • Segment 0 - Live Course
    • 📚Workshops
      • 2022-10-12 Open-Source Data Analytics via Dune Spellbook (Prerequisites)
      • 2022-04-21+ Interactive Data Visualization with Python
      • 2022-03-30+ Subgrounds Workshop Series
      • 2022-03-11 Data Curation with dbt
      • 2022-02-10 Exploring Terra Data with Flipside Crypto
      • 2022-01-27 Dune Analytics and NFTs
  • Analyst Resources
    • Analytics Challenge FAQ
    • Tips for an Impactful Analytics Dashboard
      • Dos
        • 1. Do: Decide on the broad type of dashboard
        • 2. Do: Get clear on your audience(s)
        • 3. Do: Define and deliver on your purpose
        • 4. Do: Communicate your Big Idea
        • 5. Do: Establish a logical structure
        • 6. Do: Define key metrics
        • 7. Do: Maximize the signal-to-noise ratio
        • 8. Do: Use best practices for visuals
        • 9. Do: Ask for feedback
      • Don'ts
        • 10. Don’t: Disregard your audience’s knowledge
        • 11. Don’t: Go too technical in the methodology
        • 12. Don’t: Overwhelm with charts
        • 13. Don’t: Overwhelm with text
        • 14. Don’t: Submit without proofreading
      • Extras
      • Closing Thoughts
      • Resources
    • Evaluation Criteria
    • Analyst Resources
  • Reviewer Resources
    • Reviewer Basics
    • Providing Effective Feedback
  • Extras
    • Experiments
    • Useful Links
Powered by GitBook
  1. Education

Web3 Analytics 101: Async Course

An open course that teaches students how to understand and analyze blockchain data using SQL.

PreviousEducation OverviewNextWeb3 Analytics 101: Live Course

Last updated 2 years ago

Was this helpful?

Overview

This 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 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 , , , , 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.

Register for the Course

Please register using the .

Course Outline

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.

Segment 0

We will be compiling 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.

Finally, find some MetricsDAO resources here:

Segment 1 - The Basics

Establishing foundational knowledge

  • Blockchain, distilled, and what is Ethereum?

  • Data

    • What tools are out there?

    • Accessing curated datasets and using SQL to explore blockchain data.

  • Why do this kind of work?

    • The analytics ecosystem and work2earn.

Segment 2 - Building Blocks

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

Segment 3 - Leveling Up

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.

Segment 4 - Dune

  • SQL syntax: Dune Engine V2 vs. V1

  • Column-oriented data

  • Using Dune abstractions

  • Cross-chain analysis

Segment 5 - Tying it all together

  • Creating professional outputs

  • Breaking into web3 data.

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, , and discuss:

Flipside
Dune
Footprint
Dapplooker
Web3 101 Async Course Registration Form
Submission Showcase
Active Bounties
What is xMETRIC?
Flipside
Dune
chuxin.eth
Forg
GJ
Rob
🧑‍🏫
Page cover image