Microsoft Office Tutorials and References
In Depth Information
In this chapter, you took a full tour of the various data loading capabilities of PowerPivot.
You can load data from many data sources, which lets you integrate data from the different
sources into a single, coherent, view of the information you need to analyze.
Bear in mind that the data loading process is just a technical step needed to provide
information to the PowerPivot database. To get the best from the analytical capabilities of PowerPivot,
you need to perform both the data loading procedures explained in this chapter and the data
modeling step, which we introduced in Chapter 4.