Preparing Data
Being able to prep data fast and accurately will take us on a successful data analysis journey. And considering that the decisions made by business units are as good as the data that supports them, this phase is crucial to providing useful and complete insights to business leaders.
Looking at data preparation as the preprocessing phase of analytics, where we clean, validate, and enrich our raw data, is essential to driving better insights for decision-making and makes us trustworthy analysts.
This tends to be a very demanding and under-appreciated process, and most analysts spend much of their time performing these tasks. This chapter will help you prepare your data into a workable dataset with simple, automatable, and powerful methods.
We’ll be exploring the following topics:
- Saving field configurations with the Select tool
- Working with ranges
- Applying data transformations to more than one field at a time (Multi-Field Formula)
- Using...
