Table
DAO Dash Pipeline Table
Pipeline
Output
Tags
Pipeline_Link
Data Query
Data Table
Visualization
Insights
Notes
s3_data_activity (see raw data)
Rmarkdown:
space_rmarkdown_s3_edit.Rmd ggplot2: Stacked bar chart, line, 2-charts (line and bar chart),
Discord membership data: New members, total members, member activation, retention, communicators & visitors, message activity, voice activity
postgres:
bankless_poaps_w_countggplot2: Bar chart
BanklessDAO POAPs claimed per CC (total, avg)
DAODash:
Total Snapshot Votes S0-S2 postgres:
stg_bankless_snapshot_1, bankless_snapshot_header_1ggplot2: Bar chart
Member Participation in Snapshot Votes (total, avg)
DAODash:
Fund_Flow_Bankless_Vault, Fund_Flow_GC_2postgres:
stg_subgraph_bank_1, bankless_wallet_entity_2ggplot2 & network3D: bar chart, sankey diagram
Grants Committee (& Bankless Vault) funding to Projects/Guilds
Rmarkdown:
space_rmarkdown_s3_edit.Rmdggplot 2: bar chart
[Bounty Board] Number of Bounties Posted, Value Committed to Bounties
DAODash:
Seasonal Coordinape Distributionpostgres:
coordinape_rounds_3ggplot 2: bar chart
Coordinape Round: Tokens distributed (total), Number of Senders and Receivers
DAODash:
Seasonal Tip Distributionpostgres:
tippingggplot 2: bar chart
Tips (total) distributed in Discord
postgres:
stg_subgraph_bank_1, line chart
BanklessDAO Membership categories by $BANK held
Need to reconcile difference between same queries across DAODash, Dune Analytics, & Google Big Query
DAODash:
Contributor Dashboard (multiple queries)postgres:
stg_subgraph_bank_1, public.bankless_wallet_entity, coordinape_nodesDAODash: table, sankey, network graph
Contributor Dashboard (RTJ)
DAODash:
BanklessDAO Network Health (multiple queries)postgres:
public.tipping_discordDAODash: Filter, Chord diagram, line chart, point plotting, Network graph
BanklessDAO Network Health (Saulthorin)
DAODash:
Bankless DAO Multi-sig Transaction Analysis (multiple queries)postgres:
stg_subgraph_bank_1, public.bankless_wallet_entity, DAODash: Table, Sankey, bar chart with Filter
BanklessDAO Multi-sig Transaction Analysis (RTJ)
DAODash.xyz dashboard
DAODash:
User Analytics DashboardDAODash:
public.vw_user_analytics (view)line chart
User Analytics Dashboard
DAODash.xyz dashboard
DAODash:
DaoPunks Dashboard (multiple queries)postgres:
stg_subgraph_bank_1, daopunk-mints, `DAODash: Big Numbers, bar charts
DAO Punks Dashboard
DAODash:
Season 1 - Level 2 Compensation Study (multiple queries)postgres:
season1_l2_surveyDAODash: Table, donut charts, pie chart, word cloud, box plot, circle plots
Season 1 - Level 2 Compensation Study
postgres:
discord_user, discord_user_roles, discord_roles, discord_messages, tippingDAODash: Funnel, bar chart, tables
Engagement, Governance, & Rewards (First Quest funnel, Rank: Messages sent, Tips Received)
Some queries need updating