Home » Excel Power Pivot Training in Essex | Onsite Training in Essex

Excel Power Pivot Training in Essex | Onsite Training in Essex

Established in 2005, Blue Pecan delivers Excel Power Pivot training at customers' business premises or online. Our one day Excel Power Pivot training course gives delegates a good introduction to Power Pivot's advanced data modeling features in Microsoft Excel. 

We provide Excel Power Pivot training in Essex including Southend-on-Sea, Colchester, Chelmsford, Basildon, Rayleigh, South Benfleet, Thundersley, Harlow, Grays, Brentwood, Clacton-on-Sea, Braintree, Canvey Island, Billericay, Wickford & Loughton.

Introduction to Power Pivot - 1 Day Course

Please note this outline can be tailored - nothing is set in stone!  Most of our customers opt for a tailored course outline. PowerPivot is designed to provide self-service business intelligence, allowing end users to perform complex data analysis without the intervention of business intelligence technicians.  Delegates will gain a working knowledge of PowerPivot and an understanding of basic database theory.  Download the course outline in pdf format.

This is box title

  • When should I use PowerPivot vs PivotTables
  • Database theory
    • Normalisation
    • Primary & Foreign keys
    • Fact tables vs dimension tables
    • Star scheme vs Snowflake schema

Basic Operations

  • Activate the PowerPivot add-in
  • Open and close the PowerPivot add-in
  • Navigate the PowerPivot add-in
  • Format columns
  • Sort columns
  • Create relationships between tables
  • Create a Pivot report
  • Refresh data

Create Calculated Columns & DAX Formulas

  • Create calculated columns referring to fields in the current table
  • Create calculated columns referring to fields in related tables using the RELATE function

Create Measures Using DAX Functions

  • Theory – calculated columns vs measures
  • Use the CALCULATE function
  • Use the FILTER function
  • Use the ALL function
  • Use the SUMX function
  • Use the AVERAGEX function

Use Time Intelligence Functions

  • Create a data table
  • Use DAX time intelligence functions

More PowerPivot Functionality

  • Create named sets
  • Create hierarchies
  • Create KPIs