Dataset - Stake Pool Analytics

Open-source code repository for generating an analytics dataset from a mixture of on chain db-sync data and external data sources

Founders of Cardano Canucks and Canuckz NFT with 30+ yrs experience in data infrastructure, analysis and visualization for enterprises.

Problem Summary

There are many opportunities to perform data analysis on pool performance, but a lack of analytics-ready data for the community to access.

Our Solution

Our plan is to build an open-source analytics-ready dataset of Cardano stake pool data which provides the community a consolidated machine-learning ready dataset for the Cardano ecosystem

Data Sources

• Cardano DB-Sync
• SMASH Metadata
• Extended metadata json files

The aim of this dataset will be to enable someone to answer such questions as:

• What are the best performing stake-pools
• What is the effect of pool parameter changes to performance over time
• What are the optimal stake pool parameters to attract stake?
• What's the rate of growth of stake pools?
• What's the rate of attrition of stake pools?
• What is my pledge earning vs my stake pool?

Deliverables

The output of this project would be an open-source Github repository containing data integration scripts and SQL Queries as well as associated schema documentation.

SQL scripts would be separated between DB-Sync only scripts, and extended scripts which require external data sources to be integrated so that developers who are already running DBSync can get maximum value without implementing the data integration components.

Additionally, if the Cardano Data Hub idea ( https://cardano.ideascale.com/a/dtd/Cardano-Analytics-Data-Hub/368258-48088 ) gets funded, this dataset will be integrated as one of the available datasets there.

Project Plan and Budget

The project will have 5 components:

Data Discovery / Requirements - $1,800

• detailed data review and profiling of existing data sources
• Collaboration with community on requirements

Data Modelling - $1,800

• Modelling datasets based on available data and community input

Data Integration - $3,000

• Creating data integration scripts to ingest external datasets

SQL Development - $1,800

• Develop SQL views to aggregate and implement modelled data

Documentation - $1,200

• Provide schema and user documentation for consumers and implementers of the data

Quality Assurance / Testing - $480

• Total Budget: $10,080

Expected completion date would be 6-8 weeks after funding is received.

Core Team Experience

Michael Stewart

• 17 years of software development and architecture experience.
• The last 10 years of focus in the data and analytics space.
• Led the development team of a boutique data / analytics firm where I designed and architected cloud based data warehouse solutions for fortune 500 companies
• Member of the Cardano community since 2017
• Co-Founder of Cardano Canucks stake pool and Canuckz NFTs
• Co-Founder of CCSPA (Canadian Cardano Stake Pool Association)

Vivek Nankissoor

• 15+ years of experience in database requirements, design and development
• Established and grew web analytics, marketing automation and QA practices
• Engaged in marketing, data and analytics strategy development with enterprise retail, cpg organizations, banks, automotive, pharma, fintech and others
• Co-Founder of Cardano Canucks stake pool and Canuckz NFTs
• Co-Founder of CCSPA (Canadian Cardano Stake Pool Association)
• Participant in community work such as financial literacy relating to crypto and raising awareness with various investment groups