Performing Data Analysis Tasks
John Paul Mueller · 2012
This chapter focuses on how to work with a number of advanced database features that include stratification, summarization, random record sampling, and gap detection. It considers how to work with pivot tables to view data in new ways, join databases to get the complete data picture, and work with monetary unit samples. Stratification relies on the creation of value bands and placing the records from a database within these bands. The Summarization task does much as the name suggests: it provides a summarization of data within a database. Gap Detection can help the users quickly locate missing items within sequences of data. The chapter helps to understand the advanced IDEA features for working with databases. These analysis features might not be an everyday requirement for the users today, but they can become important tomorrow.