PowerPivot Workshop Full is a 3-day intensive course that enable Excel users to master PowerPivot.
Attending this course you will learn how to create a data model in PowerPivot, how to import data, create relationships, use PivotTable and Power View to navigate data, how to create both simple and more advanced calculations in DAX.
Our trainers will assist you during hands-on-labs, helping you creating your first PowerPivot models and reports.
Course outline:
- Introduction to PowerPivot 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 PowerPivot data models
- Calendar computation and data modeling best practices
- SharePoint integration
- Creating Power View reports
- Shaping Reports
- Evaluation Contexts and CALCULATE
- Using DAX as a Query Language
- Advanced DAX techniques
- DAX Patterns
FULL edition specific contents are in bold.
All other contents are in common with the BASIC edition.
Course time:
| Your Time | |
|---|---|
| UTC | 07:00pm-11:00pm |
| Eastern Time (US & Canada), Bogota, Lima | 02:00pm-06:00pm |
| Central Time (US & Canada), Mexico City | 01:00pm-05:00pm |
| Pacific Time (US & Canada) | 11:00am-03:00pm |
The workshop online will be delivered in a LiveMeeting session.
The number of attendees is limited in order to improve interaction.
The number of attendees is limited in order to improve interaction.
Additional info
Every day has 4 hours of lessons. You will practice with homework exercises.