Benjtalkshow
commented
3 weeks ago I am applying to this issue via OnlyDust platform.
My background and how it can be leveraged
Hi @Cheelax, I am Benjamin, and I have extensive knowledge and experience working with dashboards and analytics. I also have a strong background in full-stack development using JavaScript. I am skilled in dynamically manipulating and displaying data on dashboards and other user interfaces. I have also implemented blockchain transaction tables and blocks on op-scan during ODHack 5.0.
I hope this issue is assigned to me, and I look forward to showcasing my skills and performing my magic on this project.
Understanding the Issue
To better understand and analyze the usage of zkube, we aim to create a dashboard on Dune Analytics. This dashboard will visualize various metrics related to game activity on zkube, such as the total number of games played, the number of games played per user, and games played per day. The goal is to provide actionable insights and enhance data-driven decision-making.
How I plan on tackling this issue
- Platform: I will use Dune Analytics to create the dashboard. Dune allows for advanced querying and visualization of blockchain data, making it ideal for this task.
- Contract Address: I will utilize the zkube contract address on Sepolia:
0x491ad6881ccae1882d70b708e220f6d59e37589611bb8860906833ec67d099.
Data to Visualize
- Total Games Played: I will create a metric showing the total number of games played on zkube.
- Games Played Per User: I will include a breakdown of games played by each user to identify engagement patterns.
- Games Played Per Day: I will provide a time series analysis of games played per day to track trends and activity levels.
- Additional Insights: I will explore and include any other interesting data points or trends that could provide valuable insights into zkube’s usage and performance.
Implementation Details
- Data Extraction: I will write SQL queries on Dune to extract relevant data from the zkube contract.
- Visualization: I will create various visualizations such as charts, graphs, and tables to effectively communicate the data.
- Dashboard Design: The dashboard will be designed to be intuitive and easy to navigate, with clear labels and interactive elements.
Testing
- Data Accuracy: I will verify that the data displayed on the dashboard accurately reflects the information from the zkube contract.
- User Experience: I will ensure that the dashboard is user-friendly and provides a clear view of the metrics.
onlydustapp[bot]
LuisDi98
The goal is to create a first dashboard on Dune for zkube: https://dune.com/home Here is an address to a zkube contract on sepolia you can plug to to create the dashboard: 0x491ad6881ccae1882d70b708e220f6d59e37589611bb8860906833ec67d099
The idea is to show interesting data such as amount of games played, amount of games played per user, games played per day or any thing you find interesting to show