Business Intelligence

PowerPivot Workshop

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

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

For more info visit www.powerpivotworkshop.com