| Tutorial: Optimize a Sample PowerPivot Model for Power View Reports |
| Written by Microsoft |
| Thursday, 15 December 2011 20:53 |
|
In this tutorial, you modify an Excel workbook in PowerPivot for Excel to make a small but functional model that you can use as a basis for sample Power View reports. Everything you do in this tutorial in PowerPivot, you can also do in tabular models that you create in SQL Server Data Tools (SSDT). In fact you can do much more in SQL Server Data Tools (SSDT). For more information, see Tabular Modeling (SSAS) . Read more... |
Author articles
- 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
- PowerPivot Table Import Wizard cannot find provider
- Analytics for Twitter 2013
- Refreshing Excel workbooks with embedded PowerPivot models from SharePoint Online
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
