<aside> ⚠️ The DAO Dash project became inactive at the end of Season 6. It is no longer actively maintained/supported by Bankless DAO contributors

</aside>

Create by: @ItamarGo Last Update: 1/3/2022

DAOdash uses a standalone instance of Apache Superset as its primary querying, data visualization, and dashboarding interface available here: https://daodash.xyz/

✅  Obtain credentials to DAOdash’s Superset instance by DMing @McKethanor or @saulthorin on Discord and providing them with your email address.

Superset uses five primary objects:

  1. Databases - large aggregates of data
  2. Datasets - curated subsets of the database used for a specific purpose
  3. SQL queries - used to create custom datasets out of a database
  4. Charts - visualize a specific dataset
  5. Dashboards - to tell a data story using multiple charts (including some cross-chart capabilities)

✅  From the DAOdash main page, create a new SQL query and familiarize yourself with the SQL editor UI.

✅  Review the DAOdash data model to get a high-level overview of the database structure, and identify the table in which $BANK token transactions are stored

✅  Create a simple SQL query that returns the from/to addresses, amount, and date for all transactions between Dec 1 2021 and Dec 31 2021. If you need to brush up on your SQL, you can find some helpful tutorials here and here.

✅  Save your SQL query as “<Your Name>-First Quest” and click the “Explore” button to save your query as a dataset, using the same naming convention.

✅  In the new screen, click “table” under the “Chart type” section to select a different chart type. Which chart type would better allow us to visualize the flow of funds between different addresses?

✅  Each chart type requires different parameters in order to render correctly. Map the fields in the “Query” section to their respective columns/values in the dataset.