|Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in|
|Written by Microsoft|
|Wednesday, 03 April 2013 17:46|
In Excel 2013, you can create data models containing millions of rows, and then perform powerful data analysis against these models. Data models can be created with or without the PowerPivot add-in to support any number of PivotTables, charts, and Power View visualizations in the same workbook.
Although you can easily build huge data models in Excel, there are several reasons not to. First, large models that contain multitudes of tables and columns are overkill for most analyses, and make for a cumbersome Field List. Second, large models use up valuable memory, negatively affecting other applications and reports that share the same system resources. Finally, in Office 365, both SharePoint Online and Excel Web App limit the size of an Excel file to 10 MB. For workbook data models that contain millions of rows, you'll run into the 10 MB limit pretty quickly.Read more...
Latest Author Articles
- PowerPivot for Excel 2013 errors after October update KB 2825655
- Script - Backup SQL Server Analysis Service database (PowerShell)
- Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services
- Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel
- Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in