Summary

In this chapter, you learned how to connect to various data sources. After connecting to the data, you learned how to analyze it using data profiling. Then, you learned to clean the data using various methods, such as filtering, creating calculations, groups, and splits. Cleaning data is a prerequisite for effective data analysis, and you will be using these methods throughout the remainder of this book.

Once you cleaned the data, you looked at ways to group data using aggregation, and then learned to transform it with pivots. You also combined multiple data sources using the join and union options. Finally, you learned about how to save, share, and export your workflow and the data.

The key takeaway from this chapter is how to transform data efficiently based on the project requirements so that it becomes fit for visualization. In the next chapter, you will use the skills you have learned in this chapter, such as aggregation, joins, and groups, to create charts in Tableau...