profile

Hi! I'm sqlbelle!

What's your dashboard's purpose? - Learn data with sqlbelle 2024.03.30 edition

Published about 2 months ago • 1 min read

Hello Reader,

Hope you are having a wonderful day. Here are the data tidbits for this week.

Tableau Tip - Print to PDF

Ever needed to print your dashboards in PDF, only to find out they’re weirdly split into different pages?

Many of our dashboards don’t fit the usual “print” layout, but this shouldn’t stop us from printing them in PDF. This allows us to share with others who don’t necessarily have access to the workbooks.

Here’s the trick.

Go to File > Print to PDF. In this screen, choose “Unspecified” under Paper Size.

Be warned, though, that the size will still be off - it simply follows your view/dashboard dimensions. This trick simply gets you a single PDF. You may need to zoom in or out when you view in PDF.

Viz Tip - What is the purpose of your dashboard?

Explore, explain, educate - which of these is your dashboard's purpose?

The purpose of your dashboard dictates its design and functionality, much like how a museum is curated to serve different educational goals.

Explore: Like an interactive exhibit.

Visitors can engage with the displays in various ways—turning knobs, opening drawers, or pressing buttons—to discover more about the subject matter on their own terms.

In a dashboard, you can add more knobs (filters, actions, dynamic components) to allow your audience to explore different combinations, until they find the information or insight they’re looking for.

Explain: Like a guided tour.

Visitors are led through a curated path, highlighting key exhibits and providing detailed explanations to convey a specific narrative or insight.

In a dashboard, we can consider asking questions and directing our audience to certain parts, or other dashboards, depending on their answers. In Tableau, we can also consider Story points.

Using more text or image legends for explanations can go a long way.

Educate: Like a workshop.

Participants can learn through predefined readings or engage in hands-on activities under the guidance of an expert, designed to teach new skills or concepts.

In dashboards, it will be helpful to add a clear starting point, where we set the context, language, terminology, tone, and goal so everyone starts off on the same page.

We can use instructional text or imagery and complementary resources, such as external videos or articles, to complement the exercises or provide stretch goals.

It's a wrap.

That's it for now.

Remember, your journey in data is unique. Don’t compare yourself to others.

Embrace learning, be open to opportunities, and never stop exploring the opportunities that are uniquely yours.

Until next time,

Donabel

Hi! I'm sqlbelle!

Weekly bite-sized data tips, lessons and practical tutorials. 5 minutes to read.

Join 4.4K subscribers who receive weekly, bite-sized data lessons, and practical SQL and Tableau tutorials | Subscribe for additional resources, and start with free tutorials at youtube.com/sqlbelle

Read more from Hi! I'm sqlbelle!

Hello Reader, Greeting here Tableau Tip - working with untidy data Imagine you have to work with a lot of text, for example, needing to extract the hashtags or reformat phone numbers easily. Does Tableau have the functionality to help you? Sample untidy data The answer is yes - with regex. What is Regex? Regex, or Regular Expressions, is a powerful way to work with text. Think of it as a search tool that goes way beyond finding simple text matches. It finds patterns within text, which can be...

8 days ago • 2 min read

Hello Reader, I hope you had a great week this week. Here are the data tidbits for this week. Tableau Tip - Crosstab Here is a simple but overlooked Tableau Tip. Look at your data in crosstab. Benefits of Crosstab view: Provides a clear view of raw data numbers, which can help in your validation processes. Particularly useful for verifying complex calculations such as table calculations or LOD calculations. In Tableau, you can right-click on your view name (the tab at the bottom of the...

15 days ago • 2 min read

Hello Reader, Hope you are having a wonderful day. Here are the data tidbits for this week. Tableau Tip - Use your own color Do you know how you can use your own colors in Tableau? You can use a double-click trick: Double-click any entry in your color legend to bring out the “Edit Colors” window Double-click any entry under “Select Data Item” to bring out the “Select Color” window From the “Select Color” window, you can change color in the following ways Color slider Pick screen color RGB...

22 days ago • 1 min read
Share this post