7‑Day “NEAR Data Wizard” Boot‑Camp Launches on Dune Analytics
Comprehensive, hands‑on program aims to fast‑track blockchain analysts into the NEAR ecosystem.
Overview
A new, week‑long learning series titled “7 Days to Become a NEAR Data Wizard” has been rolled out by Dune Analytics. The curriculum is designed for anyone who wants to tap into the wealth of on‑chain data generated by the NEAR blockchain—whether they are seasoned Dune users, NEAR developers, or complete newcomers to decentralized finance (DeFi) analytics.
The guide pairs written lessons with a step‑by‑step video tutorial, allowing participants to progress at their own pace while still benefiting from visual instruction. It is structured as daily modules that gradually build the analyst’s competence, from fundamental NEAR concepts to advanced SQL queries and dashboard construction.
Who Should Enroll
The program is broken into three experience tracks:
| Audience | Suggested Focus |
|---|---|
| New to NEAR | Begin with the fundamentals of NEAR’s transaction model, receipt flow, and sharding architecture. This foundation helps users identify the correct Dune tables for their queries. |
| Familiar with NEAR but new to Dune | Concentrate on the “Getting Started with Dune” segment, which covers navigation of the UI, locating the “Raw Blockchain Data” section, and accessing the NEAR datasets. |
| Experienced with both NEAR and Dune | Jump straight into the series of educational queries, which are sorted into beginner, intermediate, and advanced difficulty levels. |
All participants are encouraged to join Dune’s social channels—X (formerly Twitter), LinkedIn, a dedicated newsletter, and a Discord server—where they can share progress, ask questions, and showcase their analyses using the hashtag #NEARwizard.
Curriculum Highlights
Day 1 – Foundations of the NEAR Protocol
The opening lesson introduces NEAR’s core design: a sharded, proof‑of‑stake layer‑one blockchain. Key topics include:
- Sharding for throughput: Parallel processing of transactions across multiple shards.
- Human‑readable account names: Unlike opaque hexadecimal addresses on Ethereum, NEAR uses readable names (e.g.,
sector.near). - Account abstraction: Accounts can be contracts, allowing flexible transaction fee payment.
Students are shown how to locate the raw NEAR tables within Dune’s Data Explorer, particularly the near.actions, near.receipts, and near.logs datasets, which together reconstruct a transaction’s lifecycle.
Days 2‑4 – Navigating Dune & Building Queries
These modules walk learners through the Dune UI, how to filter for NEAR‑specific data, and the nuances of querying JSON, arrays, and VARCHAR fields using Trino/Presto syntax. Sample queries demonstrate:
- Counting successful transactions on a given date.
- Enumerating each action type (e.g.,
CreateAccount,FunctionCall,Transfer). - Extracting “simple pools” deployed on the Ref‑Finance protocol and tracking their weekly deployment cadence.
The guide also highlights common pitfalls—such as mis‑interpreting receipt logs or handling token decimal precision—and provides corrected query links for reference.
Days 5‑6 – Intermediate Analytics & Dashboard Design
Learners explore deeper DeFi metrics:
- Swap activity on Ref‑Finance, focusing on USDC/wNEAR pairs.
- Liquidity analysis including inflows, outflows, and the identification of the pool with the highest total liquidity.
- Referral fee tracking to surface power users who benefit most from protocol incentives.
The instruction stresses joining the near.actions table with near.logs to verify transaction success, a step often overlooked in novice analyses.
Day 7 – Final Challenge & Community Showcase
The program culminates in an open‑ended project: participants select a NEAR‑based protocol they are passionate about, perform a comprehensive data analysis, and publish their findings on Twitter. Tags for the creators (@0xSector) and Dune (@Dune) are required, facilitating feedback and recognition from the broader ecosystem.
Analysis: Why This Matters for DeFi Analysts
- Lowering the Barrier to Entry – By bundling NEAR concepts with hands‑on Dune tutorials, the boot‑camp removes the steep learning curve typically associated with on‑chain analytics for newer blockchains.
- Standardizing Data Practices – The course codifies best‑practice query patterns (e.g., joining actions with logs, handling receipts) that can serve as a template for future NEAR research across the industry.
- Fostering Community‑Driven Insight – The inclusion of social channels and a public challenge promotes a collaborative environment where analysts can iterate on each other’s work, accelerating collective knowledge about NEAR’s DeFi landscape.
- Strategic Timing – As NEAR continues to onboard high‑profile DeFi projects (Ref‑Finance, Aurora, etc.), a steady influx of skilled data analysts will help surface actionable intelligence for investors, developers, and protocol teams.
Key Takeaways
| Takeaway | Detail |
|---|---|
| Comprehensive, tiered curriculum | Supports beginners, intermediate users, and advanced analysts alike. |
| Hands‑on with real‑world queries | Participants immediately apply skills to actual NEAR datasets (actions, receipts, logs). |
| Community integration | Discord, X, and newsletter channels keep learners connected and enable knowledge sharing. |
| Practical final project | Encourages participants to produce publishable insights, reinforcing learning outcomes. |
| Strategic value for DeFi | The program builds the analytical talent pool needed to monitor NEAR’s growing ecosystem. |
Looking Ahead
The “7‑Day NEAR Data Wizard” series is more than a tutorial; it is an incubator for the next generation of blockchain analysts who can translate raw on‑chain data into strategic DeFi insights. As NEAR’s ecosystem expands, the demand for precise, timely analytics will only increase, making initiatives like this essential for both the platform’s health and the broader crypto market.
For those interested, the full guide and video tutorials are available on Dune’s blog, with all related queries publicly shareable through the platform’s link library.
Source: https://dune.com/blog/near
