Chapter 9. Using hierarchies
In the previous chapters, you have learned both basic and advanced features of Microsoft PowerPivot for Excel, and, in the meantime, you have learned the basics of data modeling. Being a good data modeler is one of the attitudes that is required to become a real PowerPivot master. Before now, we have described the data model as the set of tables and relationships that you have loaded into PowerPivot. In reality, the term data model has a broader meaning: The data model contains tables and relationships, but it also contains calculated columns and calculated fields, which are entities that you create in Microsoft Excel and that enrich the data model, delivering a better user experience. Other entities belong to the ...
Get Microsoft Excel 2013: Building Data Models with PowerPivot now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
