Excel - PowerPivots

Category: Microsoft Office, Microsoft Excel

Introduction to PowerPivot

  • PowerPivot Overview of terms and concepts
  • What is Business Intelligence (BI)?
  • Excel limitations
  • Classic Excel PivotTables vs PivotTables in PowerPivot

Connecting to Single Table Data Sources

  • Connecting to Different Sources
  • Pasting Data into a PowerPivot
  • Overview of Results
  • Importing Data from Excel and SharePoint Lists to PowerPivot

Working with Multiple Table Data Sources

  • Importing Data from Data Feeds into PowerPivot
  • Managing Data in a PowerPivot Window
  • Excel (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 – comparisons between PowerPivot Slices and Excel Slicer
  • 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

About SquareOne

SquareOne is among the UK's leading providers of IT training & Consultancy to businesses of all shapes and sizes. Our passion is to deliver flexible, inspiring, motivational and cost effective training which brings about tangible improvements in productivity to unlock your hidden potential.

Course Objectives

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

Course Details

Duration: 1 Day
Timings: 09:30 - 16:30

Course Contents

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.

Booking

To discuss course contents and booking arrangements, please call SquareOne on:

T: +44 (0)151 650 6907

E: enquiries@squareonetraining.com

Download Course Outline Request More Information

For more information about any of our courses please call +44 (0)151 650 6907,
email enquiries@squareonetraining.com or complete an enquiry form.

Back to top