Creation and maintenance of Dune Analytics Dashboards.
About yourself - please share a little about yourself and your relevant experience. Links to past work and experience is particularly helpful!
I am currently pursuing a masters degree in Business Information Systems and lockdown has enabled me to dive deep into the abyss of Defi. My focus has been on the investment side of things till now, but since finding PICKLE I have chosen to contribute and try to progress this project with my skills and knowledge.
My previous work experiences are related to data analysis and project management in an international software development project for the treasury of a $100+ billion revenue company. To be transparent, my official position there was “Intern”, but I was basically the only one in the project who had the knowledge to tie all of the strings together and was frequently in contact with all kinds of stakeholders in the project. Due to severe restrictions in choice of databases and methods that I could use (Company IT guidelines -I am sure some of you can relate) many of the systems were quite old and outdated, but most of them ran on some format of SQL Databases, perfectly preparing me for the job of querying data on Dune now.
I can gladly confirm my work experience with someone in particular, I do not feel comfortable in sharing this publicly.
Anyways, the Dashboard I have already built should be proof enough already that I can do what I describe in the following.
Solution & motivation
I built a staking dashboard on Dune.Analytics to track the allocation of Pickles in the Uniswap $ETH/$PICKLE Pool, staked $PICKLE in the staking contract and $PICKLE which are not staked in either of them (“freesupply”).
I am already working on creating a dashboard that surfaces the data relating to the PJars and total value locked with historical data and denomination in USD. Over time this will most likely incorporate more things, but that’s my main focus for now.
Making data publicly available is hugely important for any defi project as it creates transparency and creates an opportunity for stakeholders to analyse projects more in depth. Dune.Analytics is shaping up to become the go-to data source as it is the most open and customizable source of data for Ethereum projects available right now. Having this dashboard(and future dashboards) allows us to surface the data needed to progress our protocol and reevaluate our decisions.
It also allows investors to take a deeper look into the Pickle Ecosystem and base their decisions on these.
You might have also seen this google sheet and the graphs which stem from there at some point. I also intend to keep this up-to-date and eventually incorporate more data into to make calculations of P/E, reasonable valuation and so forth possible.
Further thoughts on this proposal
Dune isn’t exactly the best platform for surfacing data yet and I am sure that people like @jintao or Zippo (that guy from sushiswap who built all the dashboards) are probably going to come up with more elegant and visually more appealing versions of dashboards, but I think having a unbiased dashboard on Dune that is able to be verified by any third party due to the open nature of dune is an important and a worthwhile pursuit.
Deliverables & timeline
Staking Dashboard - already delivered
Total Value Locked Dashboards Completion- up to 1 Weeks from time of proposal (23.10.2020)
Since there is no frame of reference this is quite hard for me to judge.
As I see it, with the amount of work I have put in and will be putting in the future I am contributing valuable work for the protocol that is in the hands of the community with its inception(dune queries are always public). I will also include proper documentation once this proposal passes as to allow others in the future to be able to work with my queries.
I am requesting 8 ETH for my continued work on Dune Analytics Dashboards.
I worked quite a lot of Hours on these topics in the last 2 weeks and will probably do so for the next 2 weeks.
I have no Idea if this a fair or justified amount, I am basing this on my monthly salary if I would have chosen to work instead of continuing my studies. I gotta pay taxes on these and intend to do so, so I’ll be left with about 5 ETH in the end.
If anyone thinks this is to high or to low I am happy to hear feedback on this and reiterate on this.
On this amount I will work until I have finished what I intend to do as described above and request further funding if I see fit or anyone else in the community sees fit.
I am truly a believer in this Team and most of all this community and would be excited to be a “Pickle Private first class” (private first class is the next military rank, would be funny and fitting if we use this).
I excel at giving others the data they need to make the right decisions and aim to fulfill this role in this project.
It would be an honor to be the first pickle private first class.
Best 0xboxer / Florian
- Approve Proposal
- Reject Proposal