This exercise gets you thinking about the various dashboard components that can make or break a dashboard. You need to create global filters and add them to the dashboard, but without taking up valuable space using collapsible layout containers.
(upbeat music) … - [Instructor] Here's an exercise … to practice dashboard components. … Firstly, we need to resize the dashboard … to fit a wider screen. … Try 1100 by 800 wide. … Next, we're going to create a filter for the months … and apply it to the dashboard. … We want to make sure that this filter … applies across all sheets using that dataset. … Next, we want to change the filter container … into a collapsible container. … We want to reclaim that valuable space. … Lastly, create some annotations … to highlight sales people of interest. … This should take you around 10 minutes. … …
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: Challenge: Modifying dashboards