This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     
decoration
decoration
decoration

Introduction to Power Pivot

25th March 2014 - 26th March 2014

Who is it for?

This course is aimed at business analysts and other professionals who use Excel 2010 or 2013, and who want to learn to develop models in Power Pivot. Some previous knowledge of Excel is required but no previous knowledge of Power Pivot is necessary.

What you will learn

The course agenda is as follows:

Day 1

  • What is Power Pivot and why should I use it?
  • Introducing the Power Pivot UI
  • Power Pivot basic concepts: tables, columns, relationships and measures
  • Loading data into Power Pivot
  • Interacting with Power Pivot from Excel using PivotTables
  • Basic DAX: creating simple calculated columns and measures
  • Modelling data for Power Pivot
  • Intermediate DAX: aggregating data with SUM(), SUMX() and other functions
  • Advanced DAX: evaluation contexts and an introduction to the CALCULATE() function

Day 2

  • More Advanced DAX: using the CALCULATE() function in measures
  • Mastering Excel: advanced PivotTables and other tools and techniques for analysing data in Power Pivot models
  • Using the Excel cube functions to query Power Pivot models
  • Writing time intelligence calculations in DAX
  • Visualisation techniques for data in Power Pivot
  • Power Pivot for Sharepoint, on-premises and in Office 365

Key benefits

This course will enable you to build your own PowerPivot models, create calculations using DAX and build a complete reporting solution using Excel 2010/2013 and Sharepoint 2010/2013.
 

Cost: £499 (until January 31 2014), 549 (from Feb 1st 2014) +VAT
decoration

Trainer

Chris Webb

Chris Webb is the owner of Crossjoin Consulting, and is a consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of "Expert Cube Development with SQL Server 2008 Analysis Services",  "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase" and "SQL Server Analysis Services 2012: The BISM Tabular Model" and blogs at http://cwebbbi.wordpress.com/

Bob Phillips

Bob Phillips is an Excel MVP and a well-known figure in the UK Excel community.

decoration

Location

Skills Matter
116-120 Goswell Road
decoration

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration
decoration decoration decoration decoration
decoration
decoration