#12 Building Dashboards That Tell Stories

Create stunning dashboards by implementing these design and annotation changes

In partnership with

How 60,000 marketers are increasing their IQ

Did you know that you need less than 7 minutes a day to get smarter than your peers and competitors?

Stacked Marketer is a daily newsletter that curates the most recent news, case studies, and trends from the digital marketing industry.

It’s free. And in a 7-minute read, you stay on top of the industry, and increase your marketing IQ every day.

Marketers at Tesla, Amazon, Shopify, and more get it daily.

📊 Building Dashboards that Tell Stories

One of My Favourite Topics in Data

Creating an effective dashboard is a foundational task for data people. This doesn't require a design background but one should have an understanding of how to make it impactful. Whether you're a novice or revisiting an existing dashboard, I hope these tips will hep you create the next best dashboard in your company.

What should a dashboard do?

Optimal dashboards are purpose-driven and resonate with the target audience. What message is the dashboard intended to convey? Does it highlight a final conclusion or posing an essential inquiry?

Understanding the message that is being conveyed is vital, but equally crucial is recognizing the audience. Is your audience aware of the topic you’re presenting, or is it a fresh subject for them? What expectations do they have ?

Pondering these considerations before delving into the design aids in crafting a more impactful dashboard. Here’s a few examples of dashboards that are crafted well with Metabase.

Effective Design Tips

1.Contextual Data: Target Numbers or Historical Growth

The presentation of raw numbers on a dashboard without context can lead to misinterpretation or oversight of key insights. Symbols like the "%" sign or target numbers play a crucial role in this context. For instance, displaying a figure as "50%" instead of just "0.5" immediately conveys a sense of proportion. Similarly, juxtaposing a current sales figure with a target number offers clarity on performance relative to set objectives.

2.Annotations for Major Peaks, Troughs and Outliers

In data visualization dashboards, the significance of peaks, troughs, and outliers cannot be overstated. These data points often represent anomalies or significant events that can offer deep insights into the metrics your audience is looking at.

Annotations are a bridge that connect data points with the context or reasons behind their occurrence. By annotating major peaks and troughs, one can provide a clear narrative to the audience and provide clarity on the outliers.

3.Consistency with Font, Color, Size, Graphs

A harmonious design can propagate quicker interpretation of data, and establish a professional look and feel. Maintaining consistency in design elements such as font, color, size, and graphs is crucial for creating an effective and user-friendly dashboard.

Consistency ensures that your viewer's attention is directed towards the data and its insights rather than getting distracted by varying design elements. It also aids in reducing cognitive load on the viewer, allowing them to process information efficiently without unnecessary distractions.

Here’s a few strategies for ensuring consistency across your dashboard:

  • Style Guide: Develop a style guide that defines the specific fonts, colors, and sizes to be used. Times New Roman and Arial being a few fonts, easy to configure across most industry software.

  • Unified Color Palette: Stick to a defined set of colors that align with your brand or purpose. Reserve colors like red, orange for alerts or emphasis.

  • Standardized Graph Types: If you're presenting similar kinds of data in multiple sections, use the same type of graph to represent them.

  • Font Hierarchies: Designate specific font sizes and weights for headings, subheadings, and body text.

 📰 Data Tools, Articles and Resources 

  1. Build a Customer Lifetime Value (LTV) Model with Machine Learning [Link]

  2. Thread on X: Confusion Matrix - Clearly explained [Link]

  3. Thread on X: PyTorch or TensorFlow? [Link]

  4. Tool: Codium AI, AI-powered Interactive Code Agent [Link]

  5. From Event Collection To Behavioral Data Modeling [Link]