Power Pivot for Microsoft Excel Course

Our Power Pivot for Microsoft Excel Course gives you the ability to unleash some of excel’s great business intelligence features. This course covers the following items:

• Import & query data with Power Pivot workbooks
• Generate PivotTable and PivotChart reports
• Create relationships between Power Pivot tables

Tell us about your project

Course Duration

One day or two half-days

\

Course Objectives

After completing this course you will be able to describe the main ways to import and query data using Power Pivots workbooks in Excel, to generate PivotTable and PivotChart reports and to create relationships between Power Pivot tables.

Who is this Course for

Professionals who want to use Power Pivot full capabilities in Excel 2010 and who recognise the need for Business Intelligence.

Course Prerequisites

Previous knowledge of Excel PivotTable features is useful but not essential. Basic understanding of relational data is useful but not essential.

i

Course Outline

Click on the headings below for more information on course topics:

Introduction

 

  • Why use PowerPivots
  • PowerPivot Workbooks
  • The PowerPivot tab
  • Data sources
  • Relationships
Importing Data

 

  • Using the Table Import Wizard
  • Import and Filter from Databases
  • Run SQL Query
  • Get Data from Files
  • Copy and Paste Data
  • Create Linked Tables
PowerPivot Tables

 

  • Formatting Numbers
  • Handling Technical and Useless Columns
  • Understanding Calculated Columns
  • Using Lookup Tables
  • Understanding Measures
  • Handling Many Tables
  • Refreshing Data
Creating Relationships

 

  • Understanding relationships
  • Review existing relationships
  • Create new relationships
Building DAX Formulas

 

  • Formula basics
  • DAX Data Types
  • DAX Operators
  • Calculated Columns Examples
  • DAX Measure Examples
  • RELATED, CALCULATE functions
PivotTables & PivotChart Reporting

 

  • Difference between Excel PivotTable and PowerPivot PivotTables
  • Updating the table
  • Changing the table structure
  • Formatting the PivotTable
  • Creating a PivotChart
  • PivotChart Layouts
  • Changing the Chart type
  • Formatting the Chart
Slicers

 

  • Adding slicers to PivotTables and Charts
  • Resizing Slicers
  • Slicer options

CONTACT FRANÇOIS TO FIND OUT MORE

CALL US NOW