Detailed Plan
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
<u>Deliverables</u>
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.
<u>Project Plan and Budget</u>
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.
<u>Core Team Experience</u>
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
