IT trainings > Technical

PowerPivot Advanced - Excel 2013

Excel - PowerPivot Advanced

Goals

Data analysis with PowerPivot.

Requirements

Very good knowledge of Excel.

Contents

Managing data sources
  • Various data types
  • Choosing a data source
  • Databases
  • Multi-dimensional databases
  • Data feeds
  • Principles and OData protocol
  • OData feeds
  • Azure Data Market
  • Restricting data feeds
  • Remarks on Open Data
  • Files
  • SharePoint
  • Clipboard
  • Excel table
  • How to prepare data
Linking data
  • Problem
  • Using relationships
  • Formatting Data
  • Initial formatting
  • Integrating data in PowerPivot
  • Creating the first PivotTable report
  • Creating a relationship
Calculation
  • Use of calculated elements, difference between “Calculated column” and “Measure”
  • Creating calculated columns (including the use of the “RELATED” function)
  • Creating hierarchies
  • Creating measures
  • Function categories
  • Contextual filter
  • Using DAX to adapt calculations
  • Using DAX to modify the context for filters
  • What is required to use the DAX ‘Time Intelligence’ functions
  • Managing sets
  • Totals (ALLSELECTED)
Reporting
  • Interactive Dashboard
  • Adding PivotChart
  • Linking slicers
  • Filtering and sorting labels
  • Formatting Contents
  • Adding a KPI (Key Performance Indicator)
  • Page Layout
  • Managing groups

Practical info

1 Day   |   €  N/A   |  # POWERPIVOTAV13

This training is only on request. Contact us for terms and conditions.


Download in pdf file
More information about this training?
All our courses are also available
intra-company

Training subsidies
See also

Let’s stay in touch

We'll never share your email address and you can opt out at any time, we promise.