Creating a flow for transaction analytics
In this recipe, we'll create a data pipeline, or flow, for analytics. In this scenario, we'll assume that we are an analyst for a fictive department store with multiple physical stores, as well as an online store front. We will be presented with multiple data sources that need to be combined, cleaned, and transformed so that we can output a clean and reliable dataset of all transactions that occurred in the first six months of 2020. This is a common scenario in most industries and is the perfect use case for Tableau Prep.
Getting ready
To follow along with this recipe, download the Sample Files 9.1 folder from this book's GitHub repository. In here you'll find various data files. Several of these files originate from disparate systems and we'll need to employ Tableau Prep to provide a single, holistic output of all transactions.
The contents of the files are as follows:
- Files starting with OnlineSales...
