Tableau Prep is a powerful tool but it can’t help solve every data preparation scenario. We focus a lot of our time and effort on what it can do, but we thought it would be worthwhile to cover what it can’t do (yet).
Joins can be a sticky business, especially if…
● You haven’t used them much before.
● You are working with data that is new to you.
● You don’t trust your data cleanliness.
Remember the Attribute function? It returns a value if there is only a single value for a result set, otherwise it returns an asterisk.
As you likely know from using Table Calculations in Tableau, they only compute against the marks displayed in a worksheet. Check out this webinar in you need a refresher.
That means when a filter is applied to the worksheet, a table calculation will update to reflect only the data present in the worksheet.
If you're like most people in the world of analytics you spend 90% of time cleaning and preparing data and the last 10% recovering from the effort. Not anymore!
Join us for 30 minutes to look at how you can use Tableau Prep to clean dirty data and save hours each week.
Interested in the workshop mentioned in the video? Register for the Tableau Prep Foundations workshop here!
Need help on a personal project? Register for an office hour and we'll get you sorted!
Tableau Prep is a great tool for dealing with messy or unorganized data. After understanding the basics, one of the first things I found myself wondering was “does Tableau Prep have the ability to unpivot data?”. It has a pivot feature but does not have an unpivot or transpose feature at this point. However, there is a workaround.
You might have heard a lot of noise about the new Tableau Prep product that just released.
Newsflash: You automatically get it with your Tableau Desktop license
Wondering what all the hoopla is about? Watch the webinar below to learn the 3 key things you need to know about the product and how it can save you weeks in your data communication efforts.
Spend your time focusing on high-priority tasks, not getting frustrated trying to get Tableau to work. Sign up for a workshop below to learn the skills you need to accomplish your tasks more quickly!
Have you received the error “Cannot mix aggregate and non-aggregate arguments with this function.” in Tableau before?