PowerPivot and Power View Hands-On Practice
With PowerPivot, Microsoft provides users with the ability to pull and explore data from a variety of data sources, all within a single PivotTable and Power View report. The information stored in PowerPivot is commonly referred to as a data model. By performing the following hands-on practice, you will explore adding tables from a SQL Server data source and an Excel file. You will also create relationships between tables in the PowerPivot data model and add a PivotTable based on your newly created data model. Finally, you will add a Power View report and create a table and bar chart in that report.
Due to heightened security restrictions in Excel, if you see a security warning with an Enable Content button, you must click this button before you can edit your Excel worksheets or save changes in PowerPivot.
I have seen intermittent problems where the POWERPIVOT ribbon disappears. In most instances, the only fix is to reboot the entire computer. There is a bug notice on Microsoft Connect for this, but unfortunately, it is impossible to reproduce. I have found no correlation to when or why it happens, although low system resources do seem to play a part in it.
Author: Ann Weber, one of Accelebrate’s instructors