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
How to deal with missing data points - Learn data with sqlbelle - 2024.03.23 edition
|
Hello Reader, Here are this week's tidbits. Tableau TipIf 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. There are 4 options:
Just be careful with your choice, as the resulting chart could be misleading. Connecting lines - whether at default value (B), or simply bypassing them (C) - will give the impression that data exists when it doesn't. Tableau provides us with many options, but it’s still up to us to make the choice. Just because we can does not mean we should. Data Viz TipWhile we are on the topic of line charts, when do/should we use them? Line charts are your best bet when you want to visualize trends over time or show related sequences of events. We should NOT use line charts for unrelated data points.
Don't let your charts mislead your audience. Book InspirationDo you have projects you’ve been meaning to work on, but delayed and put in your “someday” list? I have a lot of them. @drnicthomas recommended this book to me called “Start Finishing”. I am just a chapter in, and I think I got the boost of motivation I need to “stop thinking” about them and “start doing” them. Do you recommend any books for those who need a boost of inspiration? It's a wrap.That's it for now. Remember, your journey in data is unique. Let's learn together. 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
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...
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...
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...