AAVE is a decentralized finance (DeFi) protocol that allows users to borrow, lend, and earn interest on cryptocurrency assets. AAVE is built on top of the Ethereum blockchain, which enables it to take advantage of the security, transparency, and decentralized nature of the blockchain.

One of the unique features of AAVE is the use of delegates, which are individuals or groups that are delegated the power to vote on behalf of the AAVE community. Delegates are responsible for proposing, voting on, and implementing changes to the AAVE protocol. They also help ensure the security and stability of the protocol by monitoring the health of the system and proposing changes when necessary.

Delegates are elected by AAVE token holders who stake their tokens in the protocol. The more tokens a user stakes, the more voting power they have. Delegates are incentivized to act in the best interest of the AAVE community as they can earn rewards for their work.

However, with the growing popularity of DeFi protocols like AAVE, there has been an increase in the demand for transactions on the Ethereum network. As a result, gas fees, which are the fees paid to miners for processing transactions on the network, have become a significant issue for users.

The purpose of this dashboard is to analyze the gas usage by delegates voting in AAVE. Specifically, we will examine how much gas has been used over the past 90 and 180 days, as well as how much gas, on average, is spent by voters in a single vote. By understanding the gas usage patterns of delegates, we hope to gain insight into the efficiency and cost-effectiveness of the AAVE governance system. This analysis could also potentially inform future decisions related to optimizing the gas usage of the protocol.

To do so, I have used on-chain Flispide Crypto data from Ethereum database. In concrete, I used the ethereum.aave.ez_votes tables to track the votes and the ethereum.core.fact_transactions to track the gas used.

The dashboard for analyzing the gas usage of delegates voting in AAVE consists of three main tabs. Each tab provides a different view of the gas usage over a specific time period.

The first tab shows the results of the gas usage over the past 90 days. Users can see the total gas used by delegates, the number of votes cast, and the average gas used per vote. Additionally, users can view a chart that shows the daily gas usage over the past 90 days.

The second tab is similar to the first tab, but it shows the results of the gas usage over the past 180 days. Users can again see the total gas used by delegates, the number of votes cast, and the average gas used per vote. They can also view a chart that shows the daily gas usage over the past 180 days.

The last tab is a personalized analysis in which the user can choose the timeframe in which the analysis will be done. To do this, the user can select the desired number of days in the parameter box located at the top of the dashboard. Once the number of days is entered, the user can click the "Apply All Parameters" button to execute the analysis. This will generate a report that shows the total gas used by delegates, the number of votes cast, and the average gas used per vote for the specified time period. The user can also view a chart that shows the daily gas usage over the selected timeframe.