Please ensure Javascript is enabled for purposes of website accessibility

Microsoft Excel Power Pivot

Square One

This course is delivered by Square One
Online with Tutor

About this course

This course is suitable for all Power Users and BI Consultants/Developer who wish to use Spreadsheets to become proficient with PowerPivot and have the necessary skills to implement PowerPivot applications and perform data analysis using real scenarios.

Topics covered:

  • Introduction to PowerPivot: PowerPivot Overview of terms and concepts; What is Business Intelligence (BI); Spreadsheet
    limitations
  • Connecting to Data Sources: Connecting to Single Table Data Sources; Connecting to Different Sources; Pasting Data into a PowerPivot; Overview of Results; Importing Data from SharePoint Lists to PowerPivot Working with Multiple Table Data Sources; Importing Data from Data Feeds into PowerPivot; Managing Data in a PowerPivot window; (Linked Tables) as a Data Source
  • Key Performance Indicators (KPIs): Create a Calculated Column to Measure Results; AutoSum Measures; User Created Measures; Working with Dates in a PowerPivot Environment; Creating Dashboards
  • Working with Slicers; Adding Slicers to the PowerPivot; Adding a Timeline to a PivotTable/Chart
  • The Diagram View: The Diagram View in PowerPivot; Managing Relationships and Tables in the Diagram View; Working with
    Hierarchies
  • Working with DAX (Data Analysis Expressions): Sample DAX Functions; Writing DAX Functions; Time Intelligent Functions

Prerequisites

Delegates who are either experienced Spreadsheets and users and who use normal Pivot tables or have attended our level 2 spreadsheet courses.

Course length:

1 day

Course cost is £234 per delegate
Course cost with Accelerate grant is £104.40 per delegate

Register interest for this course today

Chat Bot Logo
Cheshire and Warrington