profile

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

PostsLinks
Featured Post

Exploring the data reality gap - Learn data with sqlbelle 2024.05.04 edition

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...

2 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...

9 days ago • 1 min read

Hello Reader, Hope you are having a wonderful day. Here are the data tidbits for this week. Tableau Tip - Pasting Parameter Values Did you know that if you have a string parameter that accepts a list, you can copy values into your parameter? That’s right, you don’t have to type the values in one by one. You can copy the values: from an existing field’s values from clipboard You can copy and paste from a text editor or spreadsheet Copy = Ctrl + C in PC, or Cmd + C in Mac Paste = Ctrl + V in...

16 days ago • 1 min read

Hello Reader, Here are the data tidbits for this week. Tableau Tip - Calculated Field Editor Did you know that the Tableau Calculated field editor is modeless? A modal dialog box is when you cannot interact with other areas until you close the open window or dialog box. A modeless (or non-modal) window is when you can interact with other areas WITHOUT having to close the open window. Tableau’s calculated field editor can remain open while you make edits. Click on “Apply” to see the change...

23 days ago • 1 min read

Hello Reader, Happy April! I hope you had a good start to the month. Here are the data tidbits for this week. Tableau Tip - LOD Cheat Sheet When working with LODs, consider creating simple worksheets to serve as a simple cheat sheet for constructing your expression. For example, if you want to have the number of orders per customer, create a simple worksheet with this. Sample worksheet to be used as LOD cheat sheet Once you have verified these are the numbers you need, you can compose your...

30 days ago • 2 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...

about 1 month ago • 1 min read

Hello Reader, Here are this week's tidbits. Tableau Tip If you have a line chart with missing points, you can choose to display it in different ways. When you right-click on your measure axis (for example, Sales) and choose Format, you can see the options for Special Values. Line chart with missing information for some months There are 4 options: Show at Indicator Show at Default Value Hide (Connect Lines) Hide (Break Lines) Just be careful with your choice, as the resulting chart could be...

about 1 month ago • 1 min read

Hello Reader, Happy March, and belated Happy Pi Day! Here are the data tidbits for this week. Gotcha 2024.1! If you upgraded to the most recent Tableau Desktop version (2024.1), you would have noticed the change in behavior in the Marks card. The Detail and Tooltip in the Marks card now moves to the right when you select the following marks: Line, Shape, Pie, and Polygon. It seems a small change but it is a big change if you rely on muscle memory when you drop your fields on the Marks card....

about 2 months ago • 1 min read

Hello, I hope this message finds you well. Thank you for your support these past few years. It's been great receiving your kind words of support and encouragement. I've been recently asked to get the percentage of something that accounts for something else ... like is it true that 80% of sales come from 20% of customers? While working through this, I realized I didn't have the steps documented yet in any of my YouTube tutorials. So this is for you - if ever you need to answer this same...

5 months ago • 1 min read

Hello, If you've ever struggled with data cleaning or transformation, the latest video tutorial is just for you. Here we dive into the incredible worlds of Tableau Desktop, Tableau Prep Builder, and Microsoft Power Query! 🌟 Why Should You Watch? 🌟 Real-World Applications: If you learn by doing, you can follow along. You can download the data set, which is based on actual real world data set, and filled with actual real world data nuances. Step-by-Step Guidance: The video walks you through...

7 months ago • 1 min read
Share this page