[PKL] Cardano Governance Explorer Visualized with Graphs

[GENERAL] Name and surname of main applicant

Le Quoc Trung

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

Entity (Not Incorporated)

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

5

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

Yes

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

Create a comprehensive explorer, providing detailed and visual information about all governance activities, from voting result, community engagement to budget allocation through charts and statistics

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

No

[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.”

No dependencies.

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

Yes

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

All software developed under this proposal will be released under MIT License. This will allow anyone to do whatever they wish with the original code, as long as the original copyright and license notice is included either in the distributed source code or software.

[METADATA] Horizons

Governance

[SOLUTION] Please describe your proposed solution

Problem: We currently lack a Cardano governance explorer that provides visual charts to track voting, community participation, and other relevant metrics such as voting results, number of proposals over time, treasury changes, ADA disbursed, technical parameter changes, etc. These metrics often require users to perform a lot of manual and complex operations, making tracking Cardano governance inaccessible to non-technical users.

Solution: We will create an intuitive and easy-to-use Cardano governance explorer for users to track proposals, voting processes, and outcomes, thereby helping the Cardano community participate in governance more effectively. Additionally, by using charts and graphs that collect relevant metrics, we will make it easier for users to understand trends and the impact of governance decisions.

Features: This explorer provides the following:

• Dashboard: Provides the most comprehensive overview of Cardano's governance activities with relevant indicators statistically displayed in multiple charts such as the number of ADA in the treasury, the number of ADA disbursed, the number of Dreps, CC, SPO members, the number of ADA participating in voting, the change of each technical parameter, the number of governance action proposals ...
• Activity: Displays information on administrative action proposals with timelines and voting results categorized for easy filtering and searching
• Voting: Provides the entire voting history of Dreps, SPO, CC members for you to easily filter and search the voting history of members who vote on your behalf.
• Dreps: Provides information about Drep, voting activities, delegation
• More: Provides many other important data.

Data Flow Diagram (DFD):

Cardano Governance Explorer will appeal to a diverse community, including:

• Cardano Users: People who own ADA and are interested in participating in the network’s decision-making process. They will be looking for a tool to better understand proposals, delegates, voting processes, and assess the impact of decisions.
• Community: People interested in blockchain technology and want to learn about a transparent and decentralized ecosystem. The explorer will be a window for them to explore how Cardano works.

This unique solution provides:

• Intuitive interface: Complex information about proposals and votes will be presented in an intuitive, easy-to-understand way through charts, graphs and statistical tables. This helps users easily grasp information and make decisions.
• Increased trust: The explorer helps increase trust in the Cardano system thanks to transparency and openness.

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

Value for the Cardano community:

• Transparent and trustworthy information: All information about proposals, voting processes, and results are public and transparent, making it easy for users to track and verify.
• Increased community participation: Searching for information, tracking, and analyzing activities becomes simpler, encouraging more people to participate.
• Improved decision quality: Users have full information to make informed decisions, based on accurate data, and the decision-making process is shortened and more effective thanks to the support of technology.

The impact of the proposal will be measured using metrics such as:

• User count: Track the growth of the platform's user base.
• Engagement frequency: Measure the number of visits, average time on the platform, number of posts, comments.
• Surveys: Conduct surveys to collect feedback from users on the interface, features, and usefulness of the platform.

Sharing Results:

• Proposals: All results of the proposal implementation will be submitted to Project Catalyst's Milestone Module.
• Products: We will introduce them to the Cardano community groups, Intersect
• Open Access Tools: The platform will be accessible to all users in the Cardano community.

[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?

We have a team of experienced staff implementing technology solutions for government organizations, large enterprises and complex protocols on Blockchain.

• Work experience: A team of experienced programmers from Vtechcom Company, a company specializing in developing mobile application software and providing digital transformation solutions for businesses in Vietnam. They have more than 10 years of experience and more than 250 projects building technology solutions for businesses. Senior programmers with expertise in programming languages and Oracle databases. Holding advanced certifications such as Oracle Database 10g Administrator Certified Associate, Higher Diploma in Software Engineering, Python for Financial Analysis and Algorithmic Trading, Python for Computer Vision with OpenCV and Deep Learning… Experience in developing Oracle technology and data management solutions for government organizations such as the State Bank of Vietnam and the General Statistics Office. Providing a variety of infrastructure services for large enterprises, including SSL security certificates, cloud computing, digital signatures, eKYC and electronic contracts…
• Ability to implement proposals: We have a lot of experience accessing data on Cardano through the development of the Bamboo mobile application to help manage all Cardano assets. In addition, we also cooperate with the famous Metaverse project in Cardano, Pavia, to run their NFT data synchronization on Cardano.
• Budget management: The team's staff and advisors are people with many years of experience as project managers and CEOs, so we ensure proper management and reasonable use of this budget.
• Experience with Catalyst: Our members have years of experience in most Catalyst roles and are working on a proposal at fund 12 to create a wallet using Hydra technology https://projectcatalyst.io/funds/12/cardano-open-developers/open-source-for-hydra-wallet-integrated-into-telegram

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

Analysis and Design (1 month)

Milestone outputs:

• Detailed analysis of existing similar solutions.
• Identify core features required for the explorer.
• Select appropriate technology (Cardano blockchain, database, framework).
• Design user interface (UI/UX).
• Build system architecture diagram.

Evaluation criteria:

• Clearly identified priority features.
• Detailed system architecture diagram.
• Clear data model.
• User interface design that meets requirements for intuitiveness and ease of use.

Evidence of milestone completion:

• System Analysis File.
• Github Link.
• Figma link on UI/UX design.

Backend Development (1 month)

Milestone outputs:

• Develop APIs to interact with the Cardano blockchain.
• Build a database to store data.
• Implement core functions

Evaluation criteria:

• API is stable and efficient.
• Database is well designed and meets the needs.
• Core functions work properly.

Evidence of milestone completion:

• Github Link.
• Link to database and backend presentation video.

Frontend Development (1 month)

Milestone outputs:

• Develop the user interface based on the approved design.
• Integrate the frontend with the backend.

Evaluation criteria:

• Intuitive interface, easy to use.
• Compatible with many browsers.
• Fast page loading speed.

Evidence of milestone completion:

• Github Link.
• Link to Cardano Governance Explorer website.

Testing and Debugging (1 month)

Description:

• Perform unit, integration, and system testing.
• Fix bugs and improve performance.

Evaluation criteria:

• Detailed test report.
• System is stable and has no serious errors.

Evidence of milestone completion:

• Link to detailed test report document
• Link to the Cardano Governance Explorer web works fine

Public Release (1 month)

Milestone outputs

• Release source code to public repository and Intersects
• Introduce explorer
• Project Completion Report Documentation
• Project Completion Report Video

Acceptance Criteria:

• Source code is well organized and public
• Stable explorer
• Project completion report document
• Project completion report video

Evidence of milestone completion:

• Github Open Source Link.
• Evidence of product marketing efforts
• Link to project completion report document.
• Link to project completion report video.

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

1.Le Quoc Trung - Project Manager

Link: https://www.linkedin.com/in/trung-le-quoc-711b25288/

Description: An entrepreneur with 3 years of experience in the blockchain field, possessing good research and analysis skills along with extensive knowledge of blockchain. He is the ambassador of the CswapDEX project - the 2nd largest NFT exchange on Cardano.

2.Cong Nghia Khiem: Technical Lead

LinkedIn: https://www.linkedin.com/in/congnghiakhiem/

Description: IT professional with over 15 years of experience in roles such as Technical Manager, Project Manager and Technology Leader. He has participated in many IT infrastructure modernization and digital transformation projects for businesses. Currently, he is the Chief Technology Officer at FutureLang and has management experience in areas such as cloud solutions, software development and project management. He also holds multiple certifications in Kubernetes and advanced cloud technologies.

3.Bui The Do - Technical

Linkedin: https://www.linkedin.com/in/bui-the-do-142385ba/

Description: He has more than 10 years of experience as a programmer, including 5 years of experience and 5 years as a technical manager in Vietnam.

• Do's projects involve some prominent technologies such as Chrome (Browser - C++), Odoo (Erp - Python & PostgreSQL), Django (Web Application - Python & PostgreSQL, Mysql), WordPress (Web - PHP & Mysql).
• He used to work at BKAV Group as a project manager for developing the BOS operating system for Bphone phones.

4.Nguyen Viet Thanh - Project Advisor

Link: https://www.linkedin.com/in/nguyenvietthanh/

Description: He has 10 years of experience as Director of Vtechcom Company, a company specializing in developing application software and providing digital transformation solutions for businesses in Vietnam.

• He has experience implementing the proposal for Catalyst Fund 11 for Bamboo application and fund 12 for the proposal to create a wallet applying Hydra technology to Telegram platform.

Along with many other members participating in the role of project implementation.

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

Milestone 1: Analysis and Design (1 month)

3 people x 160 hours x 50 ADA/hour = 24,000 ADA

Milestone 2: Backend Development (1 month)

3 people x 160 hours x 50 ADA/hour = 24,000 ADA

Milestone 3: Frontend Development (1 month)

3 people x 160 hours x 50 ADA/hour = 24,000 ADA

Milestone 4: Testing and Debugging (1 month)

3 people x 160 hours x 50 ADA/hour = 24,000 ADA

Final Milestone: Public Launch (1 month)

3 people x 160 hours x 50 ADA/hour = 24,000 ADA

Total Budget: 120,000 ADA

Including Critical Work and Expenses Other:

• Project reporting management
• Human resources
• Data storage, API payments
• ADA price risk provision
• Income tax
• Additional expenses

(Exchange rate calculated at the time of proposal submission is $0.35/ADA)

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

Human resource costs: We have optimized costs by hiring application developers in Vietnam with competitive salaries. With an average salary of 17.5 USD/hour (equivalent to 50 ADA/hour), we have ensured reasonable human resource costs compared to the market, while attracting experienced programming talents. Refer to the detailed salary table here.

Funding us will help save costs:

• Find and recruit experienced blockchain developers.
• Rent office space and equipment.
• It doesn't take us much time to learn and research.

Providing value to the Cardano ecosystem:

By funding this proposal we will create a transparent space where everyone can easily follow and understand Cardano's decision-making process, contributing to building a truly democratic and open governance ecosystem that makes Cardano a truly decentralized community-run network.