Dataset - On-Chain Analytics

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