Abstract
This chapter will cover the Excel Data Model also known as the PowerPivot Data Model. PowerPivot for Excel 2013 is based on the tabular engine of SQL Server Analysis Services 2012 running inside Excel. The Data Model allows relating of multiple tables. It runs completely in memory and compresses data so that it can process millions of rows.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Neil Dunlop
About this chapter
Cite this chapter
Dunlop, N. (2015). Building a Data Model. In: Beginning Big Data with Power BI and Excel 2013. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0529-7_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0529-7_4
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0530-3
Online ISBN: 978-1-4842-0529-7
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)