Power Pivot Workshop Basic is a 2-day intensive course that introduce Power Pivot to Excel users.
Attending this course you will learn how to create a data model in Power Pivot, how to import data, create relationships, use PivotTable and Power View to navigate data, how to create some simple calculation.
Our trainers will assist you during hands-on-labs, helping you creating your first Power Pivot models and reports.
- Introduction to Power Pivot and Data Models in Excel 2013
- Data loading techniques with different sources: OLTP, DWH, Microsoft SQL Server, Microsoft Access and others
- Data Modeling basics for building Power Pivot data models
- Calendar computation and data modeling best practices
- SharePoint integration
- Creating Power View reports
- Shaping Reports
This course is intended for both Excel 2010 and Excel 2013 users.
PowerView is a feature available only in Excel 2013.
In order to run the hands-on-labs in an on-site course, we provide a setup guide in advance. Each attendee should have his notebook or a computer with Excel 2013 installed and space available for the demo. Access to a local instance of SQL Server is also suggested in order to make practice with data extraction, but in case this is not possible, we also provide starting example workbooks with data already loaded.
Course outline (PDF)
Due to the strong interaction between trainer and attendees, we set a limit of 15 people
in the classroom, in order to make the training more effective.
Training centers interested in offering the workshop as a public course can contact us.