Chapter 7. Advanced Data Analysis

One of the key aspects of business intelligence is the ability to analyse and manipulate content for reporting or to gain insight into data. Many business users prefer to use Microsoft Excel to perform data analysis due to their comfort with the software. While Microsoft Excel provides many excellent tools for performing data analysis, Interactive Reporting provides very strong data analysis capabilities including the ability to filter, add computations, leverage data sets, build functions, leverage variables, and manipulate millions of records.

While many business intelligence products on the market today provide the ability to perform analysis, some of these tools are limited in their ability to handle the number of records that Interactive Reporting can handle, thanks to the browser-based Interactive Reporting Web Client. While the Web Client plug...