Dataset - On-Chain Analytics

Our plan is to build an open-source analytics-ready dataset of Cardano on-chain data

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

Problem Summary

DBSync data is highly normalized and hard to analyze or apply Machine Learning in its raw state.

Our Solution

Our plan is to build an open-source analytics-ready dataset of Cardano on-chain data which provides the community with an analytics-ready dataset of the Cardano blockchain.

The core data source will be Cardano DB-Sync, and the deliverable will be a Github repository of SQL views which create datasets to enable developers and data scientists to answer questions such as:

• How is transaction volume increasing over time?
• What are the transaction fees being paid to the network
• How much ada is moving around the network
• How is money consolidating or distributing amongst wallets
• How maybe ppl are delegating

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.

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 4 components:

Data Discovery and community requirement gathering - $1,200

• Detailed data review and profiling of db-sync
• Collaboration with community on requirements

Data Modelling - $1,200

• Modelling datasets based on available data and community input

SQL Development - $1,575

• Develop SQL views to aggregate and implement modelled data

Documentation - $600

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

Total Budget - $4,575

Budgets are based on a $75/h USD hourly rate. No funds are being requested for infrastructure costs or development tools.

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.
• 10 years focused 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