Skip to content
Home » Excel Power Pivot Training in Surrey | Onsite Training in Surrey

Excel Power Pivot Training in Surrey | Onsite Training in Surrey

    Apologies - this course is not currently available.

    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 Surrey including Woking, Guildford, Walton-on-Thames, Esher, Camberley, Redhill, Leatherhead, Epsom, Weybridge, Ashford, Egham, Staines, Farnham & Horley.

    Introduction to Power Pivot - 1 Day Course

    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