One of our best seller courses is about PowerPivot technology. Aimed to advanced Excel users, this course will teach you everything you need to be up and running with Microsoft PowerPivot for Excel.
The workshop has two versions: BASIC (2 days) and FULL (3 days).
- 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 (FULL version only)
- Using DAX as a Query Language (FULL version only)
- Advanced DAX techniques (FULL version only)
- DAX Patterns (FULL version only)
Download full course outline (PDF) »
Choose PowerPivot Workshop On-The-Job if you want to follow the same great training course where the trainer will work on your data, on your reports, with your users, developing practical reports that can be used immediately. You don’t only learn the theory, you learn how to put it in practice and you end up having working reports and data models that will help you as soon as the course is finished.
This course can take place
In your country
We'll bring the workshop all around the world!
Check our authorized Training Centers to follow the next course!
See all classrooms »
Follow the courses in LiveMeeting sessions!
We'll arrange it in different Time Zones.
Attend the workshop directly at your company!
Attend at your company and solve your pratical problems!
For more info visit www.powerpivotworkshop.com