Tutorial: Optimize a Sample PowerPivot Model for Power View Reports

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) .