The processes of data preparation, blending, and joining are the most powerful capabilities of Alteryx. Data analysts have found themselves struggling to get the best results from their data using Microsoft Excel or other legacy tools. With Alteryx, you’ll embark on a journey of self-service data analytics, and build quick and reliable datasets for business decision-making. In this chapter, you will prep and cleanse data from spreadsheets, cloud applications, and other sources. This will be the foundation for an analytic dataset.
The journey will continue in this chapter; you'll tailor data to your needs by filtering and combining data with other sources and joining them together. This chapter will cover the following topics:
- Data preparation
- Data cleansing
- Join and union