(1/8) Now that winter has come, it's time to build and learn. First up is learning @DuneAnalytics.
As a disclaimer, I am currently learning but here are some resources that I've found to be extremely helpful 👇
#blockchain #crypto #DeFi #Ethereum #Bitcoin #Dune #DataScience
@DuneAnalytics (2/8) @DuneAnalytics is a SQL-based crypto analytics platform. Users can create queries for on-chain metrics and create dashboards to view the queried data. Here is an example dashboard about DEX metrics by @hagaetc, the co-founder of @DuneAnalytics: dune.com/hagaetc/dex-metrics
@DuneAnalytics @hagaetc (3/8) The dashboard combines numerous metrics from DEX volume to market share by DEX. You can view each individual SQL query by clicking on the title of each panel. For example, click on the top left corner stating "DEX 24 hours volume" to view the query: dune.com/queries/4234/16518
@DuneAnalytics @hagaetc (4/8) If you don't have a technical background in SQL, @DuneAnalytics has a tutorial page with different resources, including SQL: docs.dune.com/about/tutorials. Personally, I first began learning SQL on @Codecademy's platform since you can sign up for a free trial before trying Dune.
@DuneAnalytics @hagaetc @Codecademy (5/8) After learning a bit of SQL, I'd then recommend you make a free account and watch @DuneAnalytic's video tutorial series. You can follow each video here: docs.dune.com/about/tutorials/video-series. This will walk you through @DuneAnalytic's use cases and walk you through creating a dashboard.
@DuneAnalytics @hagaetc @Codecademy (6/8) To continue your learning process after finishing the tutorial series, I'd take a look at the @DuneAnalytics OurNetwork course here: ournetwork.mirror.xyz/gP16wLY-9BA1E_ZuOSv1EUAgYGfK9mELNza8cfgMWPQ
@DuneAnalytics @hagaetc @Codecademy (7/8) I've listed additional resources that I've found to be really helpful:
SQL Style Guide: sqlstyle.guide
@1chioku Substack: 1chioku.substack.com/about
Quick Start Guide: notion.so/Web3-Query-Quick-Start-Guide-3a261f7c225c4522b1c5f2948540ede6
Article: archive.ph/bh25O
Article: ethereumdev.io/explore-ethereum-data-with-sql-queries-on-dune-analytics
@DuneAnalytics @hagaetc @Codecademy @1chioku (8/8) I hope you found this thread helpful! Please like, retweet, and follow me for more resources and informational threads in the future. Thank you!
twitter.com/Khrippet/status/1530304712540569600?s=20&t=DE6Sxp_qsmO28hemn0fQJg