...
Uses formulas, filters, and other tools to do precalculations on that data–to speed up subsequent analysis and highlight the important data.
Optionally, creates relationships within the data and between different data sources. For example, defining a relationship between a field in one file with an associated field in another file.
Designs and builds processes semantic models for multidimensional analysis.
...