Microsoft Excel PowerPivot (1 day – £595, plus VAT)

    This course is designed to show experienced Excel users how to expand Excel’s traditional PivotTable table functionality by activating the PowerPivot add-in. Delegates will learn how to use this powerful Business Intelligence tool to gain useful new insights into their business data.

    PowerPivot Basics

    What is PowerPivot for Excel
    Importing Your Data
    Creating PivotTables with PowerPivot
    Creating a Date Table
    Using Slicers to Filter Data
    Connecting Slicers to more than one PivotTable
    Using Charts and Slicers to create interactive Dashboards

    The PowerPivot Data Model

    Creating a PowerPivot Data Model
    Adding data sources
    Establishing table relationships
    Adding hierarchies
    Understanding perspectives
    Using key performance indicators

    Using DAX

    Creating Calculated Fields
    Implicit and Explicit Calculated Fields
    Using DAX aggregate functions in a PowerPivot PivotTable
    Using CountRows and DistinctCount Functions
    The difference between evaluations using Row Context and evaluations using Filter Context
    Advanced DAX functions: SUMX and CALCULATE
    Time Intelligence Functions
    Using PowerPivot Sets