Microsoft Office Tutorials and References
In Depth Information
Clearly, because you want to build the complete solution by yourself, you need to learn some
basics of data modeling. And, sometimes, you need to ask for help in building some queries
to the database, when simply importing them in PowerPivot is not the best way to analyze
data. Moreover, because you have just scratched the surface of the real power of PowerPivot,
you will soon discover some useful tools that are available to build complex and meaningful
reports from the basic data provided by the database.
This chapter introduced you to PowerPivot so that you can begin to understand the difference
between a standard pivot table and PowerPivot. It is now time to summarize what you learned.
■ Standard Excel pivot tables can work on a single table; PowerPivot, on the other hand,
lets you work on many tables, tied together through relationships.
■ PowerPivot is a database, so it can store huge amounts of data; Excel is a spreadsheet,
and its reason for being is to make computations, not to store data.
■ When PowerPivot detects the need for relationships, it uses a relationship-detection
algorithm that finds them automatically. It is not magic—sometimes you must define
relationships manually—nevertheless, this tool is a big help.