Merit (Ø,G)

GM CT 🫡 It’s been a while since I was active here. Partly due to shadow bans... other times, my account was taken down. But giving up? That’s not in my DNA. So, here I am, back again to make an impact. Allow me to reintroduce myself👇

@Pharmkev Congratulations sir Kev 🔥🔥4️⃣🫡4️⃣👏👏🏆

Just got my🔥 C of P in BLOCKCHAIN ANALYTICS📊. Indeed this one hit differently. From night of debugging nonsense queries to building dashboards that makes sense. Infact, the growth has been insane💯. This isn’t just a certificate, but a proof that consistency pays🫴🏼

Your Journey into Blockchain Data Starts Here! 📊✨ Join Cohort 7: Become a Blockchain Data Analyst! Learn the skills that let you: → Decode any protocol's on-chain activity → Build professional-grade data dashboards → Tell compelling stories with blockchain data No prior experience needed – just curiosity and determination! 🔗 Learn more and secure your spot: forms.gle/RP4yvuSupL2Fyd… 📌 Program Timeline: Registration closes: January 30th, 2026 Program starts: 2nd February Join a global community building the future of Web3 analytics! 🌍 #BlockchainAnalytics #Web3Education #DataAnalysis #CareerGrowth #LearnSQL

This Capstone project tested my knowledge about the things I learnt in the last one month. I have enjoyed the process and I’ll continue to learn until I become a good analyst. Shout out to my data tribe; @AnalyticSages And tutor; @smartymetrics My data source: @Dune

4️⃣ Cumulative Volume in usd In this part, I summed up the total amount traded between 1st-31st October, 2025 on Meteora DEX. This dashboard shows that $34b plus, was traded on Meteora DEX last month. dune.com/queries/612812…

Gm CT It has been an amazing experience with the @AnalyticSages cohort 6 Onchain Data Analytics class and today, I am excited to share with you a major milestone in my learning process. In this thread, I’ll be breaking down my CAPSTONE project insights A 🧵 👇👇

@TPastrop @AnalyticSages Gm Trop 🫡

@DeFi_Essence @AnalyticSages gm merit

Gm CT As my Onchain Data Analytics journey continues to unfold with the @AnalyticSages cohort 6 program, I must say it's been both thrilling and overwhelming. I have been enjoying the process, and one of the tasks I have had to undertake is what I'll be sharing in this 🧵👇👇

This is not the end. It is just the beginning of my data analytics journey and I am looking forward to learning from others in the space. Thanks to; My data tribe: @AnalyticSages My Tutor: @smartymetrics Data source: @Dune

The Result The date timeframe for this analysis is 2025-10-15 to 2025-10-28 which is a 14 days window. The result shows the number of buys/buyers and sells/sellers of WEN token from 15th to 28th of Oct, 2025.

This is not the end, as the learning continues; with my data tribe @AnalyticSages and data source: @Dune

2️⃣UNION is slower to use as it takes time to select through available data while UNION ALL runs faster as there’s no need to worry about duplicates. 3️⃣UNION is best for when you need unique results while UNION ALL is suitable for when duplicates are acceptable. 👇

As part of the tasks given to us at @AnalyticSages Cohort 6 training, we were tasked to find the daily token transfer volume of any token on any blockchain of our choice. This is the first time I am challenged to query data on @dune and access various on-chain data. A 🧵