… I know Join-FuĪfter connecting to the SQL database, I’ll drop the customer_info and spaceship_mfg_info tables onto my Flow Pane.
Next, I need to join this unioned data to the SQL tables containing customer information and spaceship specifications. Victory! I have now successfully combined the four standardized sales files into one set of data and any new connections to this Union step will treat it as such. Once I’ve added all four data sets to the union, the Profile Pane shows what I’ve included: To add the other data sources to the new union, drag them onto the Union step and drop them on the +Add as shown here: You can see data profiling is available on the Union step, which is tremendously helpful: To create the union, I’ll simply click on the + sign next to one of my data sources and select Add Union. Here are my four standardized sales files waiting in the Flow Pane – all of them have TransactionID, CustomerID, ShipCode, SalePrice and SaleDate: For my analysis, I don’t want these datasets to be separated since these four sources are identical in number of fields, field names and data types, I can union them into one set of data. I’m going to start by opening Tableau Prep and connecting to my. If you need a refresher on joining data, Zac Heacker wrote a great blog on Combining Data with Joins.
#Tableau prep logs how to#
Using Tableau Prep, I’ll show you how to combine all these disparate data sources into something easily digested by Tableau Desktop. Additionally, I have some data that lives in SQL Server containing customer information and demographics as well as various spaceship specifications. While my sales data is coming from different parts of the galaxy, it’s in a standardized format. I’ve been able to scrounge up planetary sales data from four different sources Earth, Mars, Earth’s Moon, Io and data from the Andromeda galaxy. They just don’t make spaceships like they used to. We’ve been struggling to keep up with other manufacturers as of late, and it’s time to reverse the trend. As the spaceship sales manager for Toyota, I’m gathering data from the marketplace to analyze it, identify trends and eventually make pricing decisions based on my findings.
As you may recall from my previous post, the year is 3015.
0 kommentar(er)
