Unleash the power of Power Pivots and Microsoft Excel

Who is this course for?

This one day course is ideal for you if you need to manipulate and analyse large amounts of data. You will need to have a good understanding of Excel and how functions are created.

What are the benefits

At the end of this course you will be able to manipulate large volumes of data imported from different data sources using PowerPivot. You will understand the importance of the Data Model, how the Data Model is used and create DAX functions to analysis data.

Enquire about this course

Course Enquiry

Please type your full name.
Invalid email address.
Invalid email address.
Invalid Input

Course Duration

1 Day

Course Content

What is PowerPivot

  • Understand PowerPivot components
  • Add the PowerPivot Ribbon
  • Work with the Data Model Window

Importing Your Data

  • Import data from different sources into the PowerPivot
  • Data Model

Creating Relationships

  • Create Relationships within the PowerPivot Data Model

PivotTables and PowerPivot

  • Pivot Tables v PowerPivot Tables
  • Create Pivot Tables with PowerPivot data
  • Work with the Field list from the Data Model

Date Tables

  • Discover why you need a Date Table
  • Prepare the Date Table

Drill-Down and Flattened Pivots

  • Use Drill-Down in PowerPivot
  • Create a Flattened Pivot Table

Slicers and Timelines

  • Filter data with Slicers and Timelines
  • Connect Slicers and Timelines

PowerPivot Charts

  • Create PowerPivot Charts
  • Slicers and PowerPivot Charts

Evaluation Context

  • What is Evaluation Context?

DAX functions

  • Introduction to DAX functions
  • Use the COUNTROWS function
  • Understand when to use the SUMX function
  • Extract data with the CALCULATE Function

Time Intelligence Functions

  • What are Time Intelligence Functions?
  • Find Month to Date, Year To Date, Previous Month and Same Period Last Year

Creating Key Performance Indicators

  • Understand how KPI’s can help analyse data in a PowerPivot Table

Using PowerPivot Sets

  • Understand the purpose of PowerPivot Sets
  • Create PowerPivot Sets to combine data

Pivot Charts and Dashboards

  • Utilise the full capability of PowerPivot Charts and Slicers
  • Connect Slicers to Pivot Charts
  • Create "Dashboards"

What our users say

 

  • A very good course, trainer had good knowledge and delivered well
  • I like the fact that you have selected topics/functions on the basis of their interest/possible use - course is much more than pertinent and a better use of time
  • Very friendly and helpful trainer
  • Ray is the only IT Trainer who has ever inspired me with enough confidence to learn effectively
  • It was very good, I really enjoyed it and learnt a lot
  • I will definitely use the Pivot Tables at work in the future! Thank you for such a great training day!
  • Will ensure my team all attend (they all work remotely)
  • Exactly what I was hoping to learn, thanks

  • Contact Us
  • 44 (0) 208 681 1485
  • 44 (0) 7794 0689 6985

E Mail Us