Dune 101: Creating and Managing Dashboards

Summary

This video tutorial walks users through the process of creating, customizing, and managing dashboards on Dune. It covers how to create a new dashboard, customize its URL, and adjust privacy settings. The tutorial demonstrates how to add visualizations, use markdown for text widgets, and schedule automated query runs. Additional features like forking dashboards, linking GitHub repos for collaboration, taking screenshots, and starring dashboards are also explained. Users can learn more about these settings and tools by visiting Dune's documentation. The video provides a comprehensive guide to dashboard creation and management.

Takeaways

• 🛠️ Anyone can create a dashboard on Dune by clicking the 'Create' button and selecting 'New Dashboard'.
• 🔗 You can name and customize the URL of the dashboard, and also choose to make it private or public.
• 📊 Dashboards are composed of different charts or visualizations such as counters, time series, and tables.
• ⚙️ Users can click on parameters to change and rerun specific queries within the dashboard.
• 🚀 You can run all the queries on a dashboard at once or selectively run a single query.
• 🔍 Dashboards are clickable, allowing users to access the actual queries behind the charts.
• 📅 There is a scheduling feature that allows users to run queries daily, weekly, or at customized intervals.
• 📷 Users can take screenshots of the entire dashboard or fork their own versions for personal use.
• 🛠️ Markdown support allows adding text widgets, images, bullet points, and links to dashboards.
• 🗑️ Dashboards can be archived or unarchived later, which effectively hides them but doesn't permanently delete them.

Q & A

What steps are involved in creating a new dashboard on Dune?

To create a new dashboard on Dune, click the 'Create' button, choose 'New Dashboard,' name it, customize the URL, and set its privacy settings (public or private).

What does a gray parameter on a Dune dashboard indicate?

A gray parameter on a Dune dashboard indicates that you can click on it to change the parameter value. You can also use 'Control + Enter' to run all queries or just one query.

How can you run all the queries on a dashboard at once?

To run all the queries on a dashboard, there is an option to 'Run all' queries by clicking a specific button for that function.

What are some of the types of visualizations available on Dune dashboards?

On Dune dashboards, you can include charts, counters, time series, tables, and other types of visualizations.

Can you customize the URL of your dashboard? If so, what is important to remember?

Yes, you can customize the URL of your dashboard. However, if you change the URL after sharing it, the link will break, so users will no longer be able to access the dashboard through the old link.

What happens when you make a dashboard private?

When you make a dashboard private, it becomes hidden, and only you can access and view it.

How can you schedule queries on a dashboard to run automatically?

You can schedule all queries on a dashboard to run at specific intervals, such as daily, weekly, or even every minute. You can also choose a specific engine tier to run them on.

What is the 'Fork' option on a dashboard, and when can you use it?

The 'Fork' option allows you to create a copy of your dashboard. However, you can only fork your own dashboards and not those created by others.

How can you integrate GitHub with your Dune dashboard?

You can link a GitHub repository to your Dune dashboard, allowing other people to contribute to the dashboard's development if needed.

What does archiving a dashboard do, and can it be reversed?

Archiving a dashboard hides it from view and prevents anyone from editing it. However, you can still unarchive the dashboard later if you want to make it visible again.

Outlines

00:00

📊 Introduction to Dashboards on Dune

This paragraph introduces the concept of creating dashboards on Dune. Users can access the 'create' button to make a new dashboard, customize its URL, and set it as private if desired. The paragraph also showcases an example of a completed dashboard by Hild Toby, highlighting different types of visualizations like counters, time series, and tables. It explains that users can modify parameters and run queries from the dashboard.

📈 Navigating Charts and Queries on Dashboards

This section discusses how dashboards can contain multiple charts and visualizations, each clickable to reveal the underlying queries. Users have the option to run all queries or specific ones on the dashboard. The description highlights the flexibility of exploring data in a detailed manner by interacting with individual charts.

🛠 Creating and Customizing Your Own Dashboard

Here, the process of creating a new dashboard is described. Users can name the dashboard, customize the URL, and choose its privacy settings. There's also a note about breaking the shared URL link if the name is changed. Once created, users can add visualizations, such as a chart from a query, and customize text widgets using Markdown, allowing for the inclusion of images, bullet points, and links.

📅 Scheduling and Managing Dashboards

This part explains advanced options like scheduling queries to run at specific intervals (daily, weekly, or even every minute) and choosing the engine tier for execution. Users can take screenshots of their dashboards, fork their own versions for safekeeping, and link GitHub repositories for collaborative contributions. The paragraph also covers starring a dashboard, allowing users to mark or favorite specific ones.

🔒 Deleting or Archiving Dashboards

In this final paragraph, the process for deleting, archiving, or changing the privacy settings of a dashboard is detailed. Dashboards can be made public or private, and archiving them hides the dashboard from view while still allowing it to be restored later. It ends by encouraging users to explore more about dashboards in the Dune documentation for deeper insights into settings, widgets, and other features.

Keywords

💡Dashboard

A dashboard is a visual interface that displays data using charts, tables, and other elements to provide insights. In the video, users can create dashboards on Dune to organize and present different data visualizations about cryptocurrencies like Ethereum and Bitcoin. The dashboard can also be customized, made private, and organized into folders for easy access.

💡Visualization

Visualization refers to graphical representations of data, such as charts or graphs, that help users understand complex information more easily. In the video, charts and visualizations like counters, time series, and tables are used to present data on the dashboard. Users can add these visualizations from their queries to make the data more comprehensible.

💡Query

A query is a request for information from a database, used to extract specific data. In the video, users can create and run queries to generate visualizations on their dashboards. Queries can be executed individually or all at once, allowing users to efficiently generate multiple charts and visual insights from the dashboard.

💡Parameter

A parameter is a variable input that can modify the output of a query or visualization. In the video, gray parameters are mentioned, which can be adjusted by users to change the data being displayed on the dashboard. This allows users to customize the insights by selecting different parameters to view specific data.

💡Private Dashboard

A private dashboard is a dashboard that is only visible to the creator and cannot be accessed by others. In the video, the speaker makes a dashboard private so that no one else can view or interact with it. This is useful for keeping sensitive data secure or working on a project that is not yet ready for public release.

💡Markdown

Markdown is a lightweight markup language used to add formatting elements, like headings, links, and images, to text. In the video, the speaker mentions using markdown to add a text widget to the dashboard. This feature allows users to add descriptive text, bullet points, or images to enhance their dashboards and provide more context to the visual data.

💡Schedule Queries

Scheduling queries refers to automating the execution of queries at specific intervals, such as daily or weekly. In the video, users can set their dashboard queries to run automatically every day, week, or even every minute. This feature ensures that the data on the dashboard is always up-to-date without manual intervention.

💡Screenshot

A screenshot is a captured image of what is currently displayed on the screen. In the video, there is a feature to take a screenshot of the entire dashboard, which allows users to share a static representation of their data visualizations with others. This can be useful for creating reports or presentations.

💡Fork Dashboard

Forking a dashboard means creating a copy of an existing dashboard for personal use or further modification. In the video, the speaker mentions that users can fork their own dashboards but cannot fork others'. This allows users to save a version of their work and make changes without affecting the original dashboard.

💡GitHub Repository

A GitHub repository is an online storage space where users can collaborate on software development projects and share code. In the video, users have the option to link a GitHub repo to their dashboard, allowing others to contribute to the development of the dashboard. This feature facilitates collaborative work and version control for the dashboard's code.

Highlights

Anyone can create a dashboard on Dune by clicking the create button and choosing 'new dashboard'.

You can customize the dashboard URL and make it private if needed.

Completed dashboards can have charts, visualizations, counters, time series, or tables.

Dashboards often contain multiple charts, which can be clicked into for viewing the underlying queries.

Gray parameters indicate that different parameters can be selected or run using 'control + enter'.

To run all queries in a dashboard at once, you can select 'run all'.

Customizing a dashboard involves creating a new dashboard, naming it, and setting a unique URL.

Changing the dashboard URL will break any previous links shared to access the dashboard.

You can add visualizations to the dashboard from existing queries and customize labels.

Markdown is supported for adding text widgets, including bullet points, links, and images.

Dashboards can be scheduled to run queries at intervals, such as daily or weekly.

A screenshot button allows capturing the entire dashboard image.

Users can fork their own dashboards, but cannot fork other people's dashboards.

GitHub repositories can be linked to allow others to contribute to the dashboard.

Dashboards can be archived, which hides them from view but allows unarchiving later.

Transcripts

[Music]

all right let's talk about dashboards so

anyone can create a dashboard on Dune uh

you just go up to this crate button

you'll see a new dashboard drop down and

you'll be able to create a dashboard

name and customize this URL and make it

private um first let's start with a

completed dashboard uh this one is from

our friend hild Toby uh who's a bunch of

great dashboards across ethereum and

Bitcoin and you can see there are some

charts or visualizations here and they

can be uh counters or time series or

tables and there's a few other types as

well uh you'll see parameters on here

and normally when you see this kind of

gray parameter that means that you can

click a different parameter you can do

control enter and you can choose to run

either all the queries or just the one

query on the dashboard all right so a

lot of the times dashboards can be very

very long they're comprised of many

different charts and these charts are

all things you can click into to see the

actual queries uh and we'll talk about

the queries another

time so now let's say you want to run

all charts on a dashboard you can just

go here and run all of the queries on

the dashboard however you got a lot more

settings if you go and create your own

chart uh dashboard right so if I create

a new dashboard and I call it test dun

Dash and I can customize the URL to just

be something like Dune Dash if I want it

to be shorter this is the URL that's

actually shared Um this can be changed

this this one can be changed anytime if

you change this it's going to break the

link of how people arrive to the

dashboard so keep that in mind I'm going

to make it private for now so no one

else can see it all right so now I have

a few options here one is I can edit and

I can add a visualization so let's

say I have a chart on a query uh for

salana that I was working with earlier I

can add that in here and I can also say

this is

salana uh

Dex LTV or something like that right and

so this is a text widget that uses

markdown um you can see our markdown

Support over here for adding stuff like

images or basic like bullet points and

whatnot and links right so let's say I

have this I can just hit done um and

this is technically a sharable dashboard

it's private um dashboards can be put

into different folders you can just move

it up here and also you'll notice

there's a new button here schedule so I

can actually schedule all queries on a

dashboard to run every day every week

every minute um and choose a specific

engine tier to run it on as well right

if I hour to save this now this is going

to run

daily um other things to note there is a

screenshot button to take a screenshot

of the entire dashboard you can Fork

your own dashboards you can't Fork other

people's dashboards um in case you

wanted to have a version saved um and

you can also link a GitHub repo if you

wanted to let other people kind of

contribute to your

dashboard uh last thing is just stars

stars of self-explanatory anyone can add

a star or remove a star now let's say

that I wanted to delete the dashboard um

or change the privacy settings I can

always go to edit settings um I could

make it public or not and I can also

archive it archiving it means that it's

deleted you can still unarchive it if

you want um but now it's completely

hidden from View and no one can edit

it if you want to learn more

specifically about um working with

dashboards and dashboard settings go to

the dashboards page of our documentation

you can learn about different widgets

and Bings sharing your dashboard and

other cool dashboard features

[Music]