Description
Unlock the power of on-chain analytics by learning to query blockchain data using SQL on Dune, build insightful dashboards, and export findings to Python for deeper analysis.
Features
- Blockchain Data Fundamentals — Understand the structure of blockchain data including blocks, transactions, and logs.
- SQL Foundations — Learn to write SQL queries to extract meaningful insights from on-chain data.
- Dune Dashboards & Visualization — Create multi-chart dashboards to visualize DEX volume and token distributions.
- Wallet & Cohort Analysis — Analyze wallet activity and perform cohort analysis to identify user behavior.
- Python & Advanced Analytics — Export Dune query results to Python for statistical analysis and visualization.
- Capstone Project — Design and publish an original on-chain research report as a culmination of your learning.
How it works

- Enroll in the course and access the modules.
- Learn blockchain data structures and SQL basics.
- Build dashboards in Dune to visualize data.
- Perform cohort and wallet analysis for insights.
- Export results to Python for further analysis.
Requirements
- A current WordPress install
Installation
- Download the plugin from the marketplace.
- Upload it to your WordPress site.
- Activate the plugin to start using it.
Frequently asked questions
What is on-chain analytics?
On-chain analytics involves analyzing data directly from blockchain networks.
Who is this course for?
It's ideal for data analysts, researchers, traders, and engineers.
What tools will I learn to use?
You will learn to use SQL on Dune and Python for analysis.
Are there any prerequisites?
A basic understanding of SQL and blockchain concepts is helpful.
Will I receive a certificate?
Yes, a certificate is awarded upon completing the course and passing the assessments.
Support & documentation
- Support: contact@cryptoliveleak.com





Reviews
There are no reviews yet.