The beauty in analytics, lies not in surfacing the most interesting metrics, but presenting them in such a way that the target audience can comprehend it.
Reading resources:
Learn Dune Analytics:
| Title | Description | Link |
|---|---|---|
| Learn SQL | Want to become a Data Analyst in Web3? Learn SQL | https://twitter.com/0xanyaa/status/1560298637019602944?s=61&t=h2YZ2fYOpx6-GBuheBPfQw |
| Dune | 12 interesting chapters on the world of blockchain data analytics with Dune. | https://1chioku.substack.com/ |
| Dune | A guide to Dune Analytics | https://twitter.com/cryptoPothu/status/1552158669759848450 |
| Dune | A beginner’s guide to Dune Analytics | https://twitter.com/0xPhillan/status/1534154295834075138 |
| Dune | A presentation on “Examining stable coin price deviation” using Dune | https://twitter.com/paulapivat/status/1587656228649734146?s=20&t=U215GNaDL5TeS35RSHMjgg |
| SQL | Learn foundational Ethereum topics with SQL | https://ethereum.org/en/developers/tutorials/learn-foundational-ethereum-topics-with-sql/ |
| Ethereum/SQL | Learn high level Ethereum/SQL concepts. |
Highly recommended | https://www.youtube.com/playlist?list=PL_7kfUeJgSzz5Fltb2nivE_8xuAe2XTJl | | SQL | 8 weeks SQL challenge | https://8weeksqlchallenge.com/ | | Dune | Solve 9 SQL challenges to learn about Ethereum staking, merge and build your first proof-of-stake dashboard using DuneAnalytics | https://twitter.com/kirubakumaresh/status/1580853079825477632 | | Dune | Dune lessons by DeFi_mochi | https://miro.com/app/board/uXjVM0nn33o=/ | | | | |
Crypto trackers and Blockchain analytics platforms
| Title | Name | Description | Link |
|---|---|---|---|
| Crypto Tracker | Github repository | A curated list of crypto project trackers and analytics dashboards. |
Highly recommended | ‣ | | Crypto Tracker | Coingecko | | | | NFT Tracker | ApeLike | Track wallets to make best NFT investment decisions | https://apelike.com/ | | Analytics API | Bitquery | Real-time & historical blockchain data, GraphQl APIs, SQL, WebSockets, AWS, Google Clouds etc. | https://bitquery.io/ | | On-chain Analytics | CryptoQuant | Provider of on-chain and market data analytics for institutions and professional cryptocurrency investors. | https://cryptoquant.com/ | | Code Reader | Etherscan Code Reader | Etherscan AI to seamlessly learn about any smart contract source code! | http://etherscan.io/code-reader
Learn more about it: https://twitter.com/etherscan/status/1670757723858956290 | | On and off chain data analytics | KyberAI | Launched by KyberSwap, integrates on-chain and off-chain data to create signals for over 4,000 tokens. | Learn more about it: https://twitter.com/jake_pahor/status/1670687907085180931 | | DeFi Aggregator | DeFilama | A DeFi TVL aggregator | https://defillama.com/ | | Analytics | DexScreener | Track and analyze real-time data from multiple decentralized exchanges and chains | https://dexscreener.com/ | | Analytics + Swap | DEX Guru | On-chain analytics combined with token swap | https://dex.guru/ | | Analytics | DexTools | Real-time charts, history and all token info from blockchain. | https://www.dextools.io/ | | Analytics tool | Scopescan | Tool to discover on-chain insights | scopescan.ai | | AI-based research | IntoTheBlocks | Applying cutting-edge research in AI to deliver actionable intelligence for the crypto market. | https://www.intotheblock.com/ | | Analytics Tool | Arkham Intelligence | Tools for linking crypto activity to real world individuals and institutions | https://www.arkhamintelligence.com/ | | Fees Analytics | CryptoFees | Check fees of various protocols | cryptofees.info | | Token tracking | CoinMarketCap | Track token activity | https://coinmarketcap.com/ | | Tracking | TapTools | Token, NFT, and Wallet Tracking Platform @Cardano | taptools.io | | Analytics | Artemis | The All-In-One Tool for Your Crypto Data | app.artemis.xyz |