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
Fix messy data: Practical Guide using Union in Tableau and Power Query
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 each step of the data cleaning and transformation processes.
Multiple Tools, One Goal: Learn to tackle the same problems using different tools—Tableau and Power Query — and decide which one best suits your needs.
Sneak Peek into Future Content: This video puts the spotlight on UNION operations, but stay tuned for more videos that'll dive into other data operators and scenarios.
Additional Tips and Tricks: Beyond the core content, there are a lot of tidbits and nuggets information about the different tools throughout the demos. You might discover one, or many, that can save you hours of work later on. For example:
- In Tableau Desktop, do you know how to combine multiple files AND multiple tabs?
- In Tableau Prep, do you know the difference between using a UNION at the connection level vs using the UNION operator?
- In Power Query, what ist the difference between loading to connection vs loading to table? How about different ways of adding conditional tasks?
​
đź”— Click here to watch the full video now!
​
If you want to follow along, the data set used for this tutorial is posted here:
​https://data.world/sqlbelle/dataprep-union​
​
Looking forward to hearing your thoughts on the tutorial! Remember, good data equals good decisions.
​
Best Wishes,
Donabel
​
P.S. If you find the tutorial helpful, feel free to share it with your network. The more, the merrier! 🌟
​
​
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...