Training agenda
  1. Introduction
    • What is Power Pivot
    • The main benefits of using PowerPivot to analyse data in Excel
    • PowerPivot and multidimensional analysis terminology
    • What is Power View?
    • What is Power Query ?
  2. Creating data models
    • Importing data to the model (from many sources)
      • From the active workbook
      • From other workbooks
      • From txt, csv files
      • From databases
    • Adding sources obtained with the help of Power Query
      • Import and transformation of file sources
      • Import and transformation of Internet sources
    • Creating relationships
  3. Improving models using DAX (Data Analysis eXpressions language)<
    • Creating calculated columns
      • Necessary model adjustments using the RELATED function
      • Creating calculated measures
      • Creating calculated dimension elements and hierarchies
    • Creating calculated fields
      • Classified
      • Transparent
    • &Creating key performance indicators (KPIs)
  4. Reporting from PowerPivot models
    • Tables and pivot charts
      • The rules for proper use of the pivot table
      • Differences in functionality of the PivotTable based on PowerPivot compared to the standard PivotTable
      • Slicers
      • Timeline
  5. Downloading tables from the PowerPivot model
  6. Power View sheets
    • Tables:
      • Sorting
      • Filtering
      • Charts
      • Maps