About Web3 Analytics 101 Live Course

This course teaches students how to understand and analyze blockchain data using SQL. In the live course format, you will learn in real time with a cohort, and receive NFT badges and xMETRIC for your achievements.

About This Dashboard

This dashboard is used for Segment 2 in the Web3 Analytics 101 Live Course, and covers beginner SQL for blockchain data analysis. Here you will learn how blockchain data is structured, and basic operations with a SELECT statement.

Find Out More 👇

• Join our Discord community and check out the #education-chat channel!
• MetricsDAO Website
• Twitter
• YouTube

About MetricsDAO

MetricsDao is a community of data analysts who provide Web3 organizations with on-demand data insights and tooling.

1. Getting Started with SQL: Basic Syntax

2. Explore Fields

3. WHERE Condition

4. ORDER BY

5. ORDER BY DESC

6. Several conditions. E.g. filter by date

8. Filtering for Values in a List

9. What If You Don’t Know the Full Value? Wildcard Character %

Image source.

10. Refining the Use of the Wildcard Character %

7. Combining WHERE Clauses with Logic

11. Date Range: Using BETWEEN

12-13. Unique Records, Primary Key, Foreign Key

Image source: .

Why can there be several rows with the same transaction hash? Check out the difference between a table’s primary key vs. foreign key(s).

14. Let’s Look at a Different Use Case: NFT Table

What platforms can we look at?

18. Domain Knowledge: Platform Fees in ETH Take Majority

19. Average, Median, Min and Max

Next Steps:

• Submit your attendance
• Submit the quiz
  • Deadline is Monday, November 28th 2022, by 2pm EST
  • Enrolled students will find the quiz link in MetricsDAO discord #live-course channel
  • Material from the previous and this session
  • A passing score of 7/10 and higher gets you a course progress badge (on-chain NFT and on Discord) + xMETRIC
• Attend weekly Office Hours
  • Wednesday, November 23rd, 2022 9-10am EST
  • This week in office hours we’ll answer any questions we didn’t get to in the live, and start looking at Solving Bounties: First Steps
• Attend the next live lesson
  • Segment 3 is live on Monday, November 28th, 2022 at 3pm EST
• Attend our events! Tomorrow a Data & Chill with Nick (find in our Discord events).

15. Let’s Look at OpenSea

Also, using aliases.

16. Platform Fees

17. Fee Currencies

Flipside

• Database (e.g. Ethereum) → schema (e.g. core) → table (e.g.dim_labels)

  \

• Table types: fact, ez, dim

  \

  • fact describe observations or events such as blocks, tx, swaps
  • ez aggregated models built by data curators, more user friendly
  • dim describe entities—the things you analyze, such as labels, prices, decimals, tags

• For more, read Flipside docs

• Image source: app.flipsidecrypto.com

Dune

• Base tables (raw)

• Decoded tables (individual contracts)

• Aggregated by sector (Spellbook) tables

  \

• For more, watch the first 5 min of Andrew Hong’s DuneCon video

• Read Dune docs

  \

• Image source: dune.com

0. A Primer on Blockchain Data

Flipside vs. Dune Layout

How is Data Created?

Image source: Blockgeeks.

How Does Data Make its Way to the Analyst?

• A walk down memory lane (and peek into an ingestion pipeline): Flipside launching Chainwalkers in 2019.

Admin

• Submit the xMETRIC form during this live (shared midway in chat)
• Submit the first quiz
  • Available after the session to enrolled learners, due before the next live on Monday November 28th
• Attend weekly Office Hours
  • Wednesday, November 23rd, 2022 9-10am EST
  • This week in office hours: Answering any questions we don’t get to in the live, and Solving Bounties: First Steps
• This dashboard will be shared on Discord after
• Questions welcome! If not answered live, you can take them to Discord and Office Hours

That’s it for live session 2! You made it 🎉

More Resources:

1. Analyst Resources by MetricsDAO.
2. What can great prize-winning analytics look like? Check out MetricsDAO’s Stellar Submissions roundups: one, two, three, four, five, six, seven, eight.
3. [2022] Guide to Web3 Data: Thinking, Tools, and Teams by Andrew Hong.
4. Publishing your analytics, the why & how: A 🧵 by danner.eth.
5. MetricsDAO Submissions Showcase: filter by Top Tier & Stellar to see the best work by our community analysts!