A good exploratory dashboard is designed to answer many questions through a high level of interaction, this might include filters, parameters, and actions. In this video, Matt demonstrates how to create a good exploratory dashboard using the same dataset.
- [Instructor] Let's look at our example dataset … and build an exploratory dashboard. … Now, the key things to remember … about an exploratory dashboard … is that they tend to include several sheets or views. … The idea is to explore the data, … so we want to present the data … in an easy to understand way, … so that people can find answers. … Exploratory dashboards are going to have … a high level of interaction, … because we need to enable our user … to drill down into the data. … Typically, that might involve things … like filters, actions, and highlights. … An exploratory dashboard is usually … one single dashboard that has many uses. … So, for our example dashboard, … this is the brief that we've been given. … We need to look at the last … three years worth of sales data, … we need to show regional variations, … we're going to be looking for peak sale periods, … and we need to identify any good or bad customers. … The ultimate goal of this dashboard … will be to look to see where we can improve our profits. …
Author
Matt Francis
Released
7/29/2019- Explain the core principles of dashboard design.
- Identify how to construct a dashboard using simple structural elements.
- Summarize how to extend dashboard functionality using dynamic components.
- Recall how to extend dashboard appeal using visual elements.
- Identify how to integrate interactive dashboard features.
- Summarize how to create a data narrative using stories.
- Recall how to create various dashboard types based on specific goals.
Skill Level Intermediate
Duration
Views
-
Introduction
-
What you should know1m 2s
-
1. Elements of a Good Dashboard
-
Who is the dashboard for?5m 38s
-
2. Dashboard Structure
-
Create a basic dashboard5m 39s
-
Size your dashboard3m 24s
-
Floating vs. tiles layout4m 51s
-
How to use layout containers8m 15s
-
Titles on your dashboard4m 8s
-
-
3. Dashboard Components
-
Apply filters across sheets4m 59s
-
-
4. Dashboard Design Elements
-
Dashboard colors5m 26s
-
Remove chart junk5m 22s
-
Solution: Dashboard design5m 35s
-
-
5. Interaction with Dashboard Actions
-
Add interaction with actions6m 36s
-
Filter actions5m 3s
-
Highlight actions5m 19s
-
URL actions6m 10s
-
Go to Sheet5m 8s
-
Solution: Dashboard actions5m 45s
-
-
6. Using Stories to Make Dashboards
-
Narrative structure3m 34s
-
Big stories4m 55s
-
Small stories4m 23s
-
Solution: Dashboard stories4m 30s
-
7. One Dataset: Five Dashboards
-
Build a data story5m 32s
-
Build a KPI dashboard6m 12s
-
Solution: Dashboard styles5m 27s
-
Conclusion
-
Next steps45s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Build an exploratory dashboard