BALANCE - Not Delegated UTXO Data Analytics - [Open Source]

[GENERAL] Name and surname of main applicant

[GENERAL] Are you delivering this project as an individual or as an entity (whether formally incorporated or not)

[GENERAL] Requested funds in ada

[GENERAL] Please specify how many months you expect your project to last (from 2-12 months)

[GENERAL] Please indicate if your proposal has been auto-translated into English from another language

[GENERAL] Summarize your solution to the problem (200-character limit including spaces)

Proposal works to address problem through intuitive data visuals highlighting “not delegated” UTXO account activity summary & detail.  Explore the data to learn more and form new questions & answers.

[GENERAL] Does your project have any dependencies on other organizations, technical or otherwise?

[GENERAL] If YES, please describe what the dependency is and why you believe it is essential for your project’s delivery. If NO, please write “No dependencies.”

Project has dependency on DB Sync

[GENERAL] Will your project’s output/s be fully open source?

[GENERAL] Please provide here more information on the open source status of your project outputs

• SvelteKit & D3 code will be open source on Github
• SQL queries will be open source on Github

[SOLUTION] Please describe your proposed solution

PROBLEM

• Current Cardano network analysis lacks insights into the nearly 8 Billion ADA not delegated to a stake pool (value obtained at time of writing this proposal).  Given the importance delegation has on POS network health, it is important that the community is able  to monitor not only “delegated” but also “not delegated” ADA activity.  The absence of not delegated ADA activity could limit community insights into areas such as retired pools, CEX entities, Genesis Key holders, etc.

SOLUTION

• This proposal includes creation of a web application dashboard consisting of various chart, KPI, & table data visualizations created using SvelteKit + D3.  Dashboard to be created and maintained as part of the existing BALANCE web application - balanceanalytics.io.  Existing BALANCE dashboard - UTXO Allocation currently provides insights into “not delegated” aggregate history, but does not provide supporting detail analysis such as account info, balance aging, delegation history, etc.  Although aggregate analysis has proved valuable, there remain many unanswered questions which require supporting detail.  All code & queries used to develop will be open sourced to prompt education and development among the Cardano community.

[IMPACT] Please define the positive impact your project will have on the wider Cardano community

The BALANCE web application was created to provide network data transparency to the Cardano Community through carefully crafted data visualizations.  Over the past couple years BALANCE has received public recognition (Cardano Foundation) for providing outstanding contributions to the community and we believe this proposal will continue on this contribution.  Delegation data is core to the health of any POS network and by providing “not delegated” ADA insights, the community will have a more complete understanding of delegation activity.

[CAPABILITY & FEASIBILITY] What is your capability to deliver your project with high levels of trust and accountability? How do you intend to validate if your approach is feasible?

As the Lead Developer of BALANCE (balanceanalytics.io) and 17 years of design, development, and implementation experience I have the core competencies required to deliver on this proposal per details described above.

[PROJECT MILESTONES] What are the key milestones you need to achieve in order to complete your project successfully?

SQL query development

Outputs:

• Create SQL query producing required data points for not delegated detail analysis

Acceptance Criteria

• SQL script used to produce required data points when executed against BALANCE db sync server

SvelteKit + D3 development

Outputs:

• Development of SvelteKit & D3 chart board items supporting detailed analysis of not delegated UTXO data including account info, balance aging, etc.

Acceptance Criteria

• BALANCE Chart Board is accessible and all data visuals render appropriately

UAT & Public Release

Outputs:

• Execution of testing items
• Functioning chart board free from defects and errors

Acceptance Criteria

• All tests completed
• Enhanced chart board is deployed to production and available for public use

[RESOURCES] Who is in the project team and what are their roles?

I will operate as the lead developer responsible for all development tasks.  I will have support from team developer Christophe Garant during UAT.  UAT is also open to any user engagement in the BALNC matrix community space.

[BUDGET & COSTS] Please provide a cost breakdown of the proposed work and resources

Milestone 1: 5000

Milestone 2: 5000

Final Milestone: 10000

[VALUE FOR MONEY] How does the cost of the project represent value for money for the Cardano ecosystem?

Full feature data visualizations based on complex data models requires a significant commitment of time, knowledge, and resources.  This commitment although quite challenging is core to any blockchain community.  Our extensive domain knowledge and experience in data engineering and solution development afforded us the opportunity to support the community in this area by creating BALANCE and continuing to develop and build inline with the web applications mission and theme.  The Cardano community is very fortunate to have many data analysis utilities which we are proud to be a part of. 

All development will be open sourced allowing others to learn and build solutions of their own.