img

Need Help? Call: +44 (0)151 650 6907

img

Excel: Power Pivots

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.

Who should attend?

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.

Prerequisites

Delegates who are either experienced Excel/Power BI users and who use normal Pivot tables or people who have attended your Excel Level2 and 3 courses

Course Details

Duration: 1 Day Classroom Training or Online

Timings: 09:30 - 16:30

Introduction to Power Pivot

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

Connecting to Single Table Data Sources

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

Working with Multiple Table Data Sources

  • Importing Data from Data Feeds into Power Pivot
  • Managing Data in a Power Pivot 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 Power Pivot Environment
  • Creating Dashboards

Working with Slicers

  • Adding Slicers to the Power Pivot – comparisons between Power Pivot Slices and Excel Slicer
  • Adding a Timeline to a PivotTable/Chart

The Diagram View

  • The Diagram View in Power Pivot
  • 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

Booking

Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

Related Courses

For more information about any of our courses

please call +44 (0)151 650 6907, email enquiries@squareonetraining.com or complete an enquiry form.