David Gasquez

@kalendium.eth

137 Following

80 Followers

David Gasquez pfp

Filecoin Pulse (https://filecoinpulse.pages.dev), the PoC where I'm publishing most of the data and metrics has received lots of updates. But more importantly, it is now also fully open source! https://github.com/davidgasquez/filecoin-pulse

0 reply

0 recast

1 reaction

David Gasquez pfp

You can find the code in GitHub and the up to date datasets on IPFS. - Code: https://github.com/davidgasquez/filecoin-data-portal - Datasets: https://filecoindataportal.davidgasquez.com/data/ Now, you can also get access to some datasets via Google Sheets! Check out this one gathering lots of metrics for Storage Providers. 👇 https://docs.google.com/spreadsheets/d/1hC5HwuiqQvQcVvV06n3SH0wKkZwbw20EufGYHSyENs0

1 reply

0 recast

0 reaction

David Gasquez pfp

It has been a while since the last update on the Filecoin Data Portal! This is a small thread with some of the recent changes and additions to the open source, serverless, and local-first Data Platform for the Filecoin ecosystem! https://filecoindataportal.davidgasquez.com

1 reply

0 recast

2 reactions

David Gasquez pfp

Since these spreadsheets are updated every few days, users can reference it or import (IMPORTRANGE) and build downstream segments/charts that will remain up to date.

0 reply

0 recast

0 reaction

David Gasquez pfp

I'm pushing some of the Filecoin Data Portal datasets to Google Sheets. Feels weird, but already seen folks use them to dig and build their own visualizations! This is how the Filecoin Clients one looks like! https://docs.google.com/spreadsheets/d/15xi39OheVJ-_WyI7sxwmvgMIVFkZN07NOYWLe5iKXnI

1 reply

0 recast

1 reaction

David Gasquez pfp

Redash and Superset are great alternatives!

1 reply

0 recast

1 reaction

David Gasquez pfp

Fun way to learn about the Pareto Frontier and Efficiency! https://www.mayerowitz.io/blog/mario-meets-pareto

0 reply

0 recast

0 reaction

carl pfp

I created an NCAA-style knockout tourney to determine who to fund for the @gitcoin Citizen Retro Round. 1500 USDC -> 32 individuals -> 2 co-champions https://gov.gitcoin.co/t/signal-boosting-for-gitcoin-citizens-retro-3/18518/3 congrats to @luciano for being one of my co-champions 🐐

2 replies

3 recasts

12 reactions

David Gasquez pfp

If you're interested on how it works, all the code is open! Feedback and ideas appreciated! https://github.com/davidgasquez/filecoin-data-portal/

0 reply

0 recast

0 reaction

David Gasquez pfp

Another week, another small update on the Filecoin Daily Metrics Dune Dashboard! https://dune.com/kalen/filecoin-daily-metrics Since all is coming from the Filecoin Data Portal, I'm also publishing it as a static website on IPFS! https://filecoinpulse.davidgasquez.com/

1 reply

1 recast

3 reactions

David Gasquez pfp

Finished a post about the pattern I've been iterating on to build lean Open Data Portals. 🌐 The key ideas: - Modern open source tools and formats (DuckDB, Dagster, dbt, Parquet) - Version controlled declarative transformations - Build and Serve phases https://davidgasquez.com/modern-open-data-portals/

1 reply

0 recast

2 reactions

David Gasquez pfp

Brushed up the Filecoin Dune dashboard with some new metrics and charts! ✨ https://dune.com/kalen/filecoin-daily-metrics Next up, better automation and more metrics!

0 reply

1 recast

5 reactions

David Gasquez pfp

Been a while since the last Gitcoin Grants Data Portal update! 🔥 https://davidgasquez.github.io/gitcoin-grants-data-portal/ - Moved Allo assets to use the new GraphQL endpoint. - Added Giveth, Discourse, and Chain Metadata datasets. - UX, dbt docs, CI, ... Kudos to DistributedDoge for all the contributions!

0 reply

0 recast

0 reaction

David Gasquez pfp

If you're not using them and work with VS Code, check them out! See if you can add one of the templates to your repository and take it from there.

0 reply

0 recast

0 reaction

David Gasquez pfp

Development Containers (containers.dev) and GitHub Codespaces (github.com/features/codespaces) are not as popular as they should be. They are incredible for development workflows and makes my life so much easier. Specially as a Python developer.

1 reply

0 recast

0 reaction

David Gasquez pfp

Tinybird team rocks! They're doing awesome stuff on top of Clickhouse and they're probably the easiest way to get started with it.

0 reply

0 recast

0 reaction

carl pfp

Introducing /regenlearnings - What: regenlearnings.xyz - Why: https://gov.gitcoin.co/t/regenlearnings-xyz-research-group/17361 - When: https://lu.ma/RegenLearnings (next call --> 2/22) - Who: you (click the follow cast button)

2 replies

5 recasts

16 reactions

David Gasquez pfp

What are some underrated and simple statistical techniques that can help folks graps "data" better? These two have been helpful in my experience: - Time Lagged Conversions to show conversion rates. - Process Behaviour Charts to understand variation.

0 reply

0 recast

0 reaction

Justin Hunter pfp

@polluterofminds

Anyone here building on IPFS without an associated blockchain layer?

1 reply

2 recasts

2 reactions

David Gasquez pfp

Looking for a data challenge? I've gathered a small list of platforms to test your ML skills. - https://kaggle.com/competitions - https://app.humyn.ai - https://drivendata.org/competitions/ - https://xeek.ai/challenges - https://mlcontests.com Have fun!

0 reply

0 recast

1 reaction