Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
2 Days

* Price is exclusive of VAT.

Tell Me More






First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

Excel training testimonials from Peterborough

AEA

"I had previously finished a similar course and felt that I hadn't learnt enough from it, this course however was perfect and I now feel much more confident to work on Power BI. The course was run extremely well via Zoom with details being given if we asked for in depth on certain areas but usually the trainer explained everything so clearly there was little need for more questions. I am looking forward to the next level of training on it now as well."

Buster + Punch

"Simon makes the training an easier task by approaching his pupil first, in order to know their level of knowledge, and then he presents the BI functions in an understandable and patient way. Excellent introduction for beginners and an overview of the amazing tools Power BI provides for creating reports, data analysis and decision making."

Microsoft Excel 2013 PowerPivot Training Course - Intermediate Training in Peterborough

Peterborough Intermediate Microsoft Excel 2013 PowerPivot Course Overview

Microsoft Excel 2013 PowerPivot Training Course Intermediate training in Peterborough

Peterborough is a practical location for businesses that want focused, instructor-led Microsoft Excel 2013 PowerPivot Training Course training with straightforward access from across the surrounding area.

This setting works well for PowerPivot training, giving delegates space to build data models, explore relationships and work through structured reporting examples.

Stuart House - East Wing
St John's Street
Peterborough PE1 5DD
United Kingdom

The venue is close to transport links and central amenities, which makes it a convenient setting for training. It is especially helpful for teams who need to combine data from different sources and improve the way they analyse information.

If you are also looking at other options, take a look at our training courses in Peterborough.


Microsoft Excel 2013 PowerPivot training for Peterborough teams

We can deliver Microsoft Excel 2013 PowerPivot Intermediate training for organisations in Peterborough and nearby areas such as Stamford, Spalding, Huntingdon, Wisbech, March and Cambridgeshire. Sessions can be run live online, at your premises, or at a local training venue where that suits your team better.

Access and venue details

The Peterborough venue at Stuart House on St John's Street is close to central amenities and transport links, making it a convenient option for focused training days.

Local training use cases

Microsoft Excel 2013 PowerPivot training in Peterborough is useful for teams who want skills they can apply quickly in real work. This setting works well for PowerPivot training, giving delegates space to build data models, explore relationships and work through structured reporting examples. It is especially helpful for teams who need to combine data from different sources and improve the way they analyse information. It suits learners who want a more advanced Excel-based approach to reporting and business analysis.

If you need PowerPivot training in Peterborough at intermediate level, this page gives you a location-specific overview of the course. It is especially helpful for teams who need to combine data from different sources and improve the way they analyse information. It suits learners who want a more advanced Excel-based approach to reporting and business analysis.

You have already gotten your hands dirty with PowerPivot and seen how powerful it is. Now you are ready to take your skills to the next level by delving deeper and getting a deeper more thorough understanding of how PowerPivot handles data. This 2 day PowerPivot training course will allow you to see the various DAX functions and how to apply them to your data models.

Course Prerequisites

Use of Pivot Tables along with a basic understanding of how to use Excel formulas

Other Microsoft Excel Training Courses

Live Online Microsoft Excel Courses

Live Online Training All you need to know.

Course Duration: 2 Days

Course Prerequisites for your training in Peterborough

Previous knowledge and use of Excel, especially in regard to Pivot Tables, is necessary before undertaking these 2 days. Knowledge of the following would be extremely helpful.

  • Understanding of VLookup in Excel
  • Using Slicers in conjunction with Pivot Tables
  • Formatting data ranges as Tables

Complete Course Outline

Introduction to PowerPivot

  • Using a PivotTable on an Excel table
  • Using PowerPivot in Microsoft Office 2013
  • Adding information to the Excel table
  • Creating a data model with many tables
  • Understanding relationships
  • Understanding the data model
  • Querying the data model
  • The PowerPivot add-In
  • Using OLAP tools and converting to formulas
  • Understanding PowerPivot for Excel 2013
  • Creating a Power View report

Using the unique features of PowerPivot

  • Loading data from external sources
  • Creating a PowerPivot PivotTable
  • Using the DAX language
  • Creating a calculated column
  • Creating a calculated field
  • Computing complex aggregations like Distinct Count
  • Refreshing the PowerPivot data model

Introducing DAX

  • Understanding DAX calculations
  • DAX syntax
  • DAX data types
  • DAX operators
  • DAX values
  • Understanding calculated columns and fields
  • Calculated columns
  • Calculated fields
  • Choosing between calculated columns and measures
  • Handling errors in DAX expressions
  • Conversion errors
  • Arithmetical operations
  • Empty or missing values
  • Intercepting errors
  • Formatting DAX code
  • Common DAX functions
  • Aggregate functions
  • Logical functions
  • Information functions
  • Mathematical functions
  • Text functions
  • Conversion functions
  • Date and time functions
  • Relational functions
  • Using basic DAX functions

Understanding data models

  • Understanding the basics of data modeling
  • Producing a report without a data model
  • Building a data model
  • More about relationships
  • Understanding normalization and denormalization
  • Denormalizing within SQL queries
  • The PowerPivot query designer
  • When to denormalize tables
  • Understanding over-denormalization
  • Understanding OLTP and data marts
  • Querying the OLTP database
  • Data marts, facts, and dimensions
  • Star schemas
  • Which database is the best to query?
  • Using advanced relationships

Loading data

  • Understanding data sources
  • Loading from a database
  • Loading from a list of tables
  • Loading relationships
  • Selecting related tables
  • Loading from a SQL query
  • Loading from views
  • Opening existing connections
  • Loading from Access
  • Loading from SQL Server Analysis Services
  • Using the MDX editor
  • Handling of keys in the OLAP cube
  • Loading from a tabular database
  • Loading from SharePoint
  • Using linked tables
  • Loading from Excel files
  • Loading from text files
  • Loading from the Clipboard
  • Loading from a report
  • Loading from a data feed
  • Loading from Windows Azure Marketplace
  • Suggest related data

Understanding evaluation contexts

  • Introduction to evaluation contexts
  • Understanding the row context
  • Testing your evaluation context understanding
  • Using SUM in a calculated column
  • Using fields in a calculated field
  • Creating a row context with iterators
  • Understanding FILTER, ALL, and context interactions
  • Working with many tables
  • Row contexts and relationships
  • Filter context and relationships
  • Introducing VALUES
  • Introducing ISFILTERED and ISCROSSFILTERED
  • Evaluation contexts recap
  • Creating a parameter table

Understanding CALCULATE

  • Why is CALCULATE needed?
  • CALCULATE examples
  • Filtering a single column
  • Filtering with complex conditions
  • Using CALCULATE inside a row context
  • Understanding circular dependencies
  • CALCULATE rules
  • Understanding ALLSELECTED

Using hierarchies

  • Understanding hierarchies
  • When to build hierarchies
  • Building hierarchies
  • Creating hierarchies on multiple tables
  • Performing calculations using hierarchies
  • Using parent/child hierarchies

Using Power View

  • What is Power View?
  • Power View basics
  • Using the Filters pane
  • Decorating your report
  • Understanding table, matrix, and cards
  • Using the matrix visualization
  • Using the card visualization
  • Using a table as a slicer
  • Using charts
  • Using the line chart
  • Using the pie chart
  • Using the scatter chart
  • Using maps
  • Understanding drill-down
  • Using tiles
  • Understanding multipliers
  • Using Power View effectively

Shaping the reports

  • Key Performance Indicators (KPIs)
  • Creating data models for Power View
  • Understanding Power View metadata
  • Using Summarize By
  • Using the default field set
  • Using the Table Behavior dialog box
  • Defining sets
  • Creating dynamic sets with MDX
  • Using perspectives
  • Understanding drill-through

Performing date calculations in DAX

  • Building a calendar table
  • Working with multiple calendar tables
  • Calculating working days
  • Computing the difference in working days
  • Aggregating and comparing over time
  • Year-to-Date (YTD), Quarter-to-Date (QTD), and Month-to-Date (MTD)
  • Time intelligence with CALCULATE
  • Computing periods from the prior year (PY)
  • Computing the moving annual total
  • Using other aggregation functions
  • Computing difference over a previous year
  • Closing balance over time
  • Semiadditive measures
  • OPENINGBALANCE and CLOSINGBALANCE functions
  • Updating balances by using transactions
  • Computing moving averages

Using advanced DAX

  • Banding
  • Ranking
  • Using many-to-many relationships
  • Computing new and returning customers
  • Understanding KEEPFILTERS
  • Implementing basket analysis
  • Understanding the power of calculated columns: ABC analysis
  • Handling currency conversion

Using DAX as a query language

  • Understanding EVALUATE
  • Creating an Excel table with EVALUATE
  • Using common functions in queries
  • Using FILTER
  • Using CALCULATETABLE
  • Using ADDCOLUMNS
  • Using VALUES with ADDCOLUMNS
  • Using SUMMARIZE
  • Using the ROLLUP option
  • Linking back a DAX query
  • Computing ABC analysis with a linked-back table
  • Using CROSSJOIN
  • Using GENERATE

Have a look at our range of Excel Training Courses/p>

If this powerpivot training course is not the one you are looking for please take a look at other courses we offer:

Microsoft Excel 2016 training course beginners

Microsoft Excel 2016 training course intermediate

Microsoft Excel 2016 training course advanced

Microsoft Excel Pivot Tables training course beginners

Microsoft Excel PowerPivot training course intermediate

Microsoft Excel 2010 PowerPivot Training Course - Beginners

Microsoft Excel 2013 PowerPivot Training Course - Beginners

Microsoft Access 2013 Intermediate training course

SQL Querying fundamentals beginners training course

Microsoft Excel VBA training course

Location FAQs for Peterborough

Where can this training take place in Peterborough?

We can deliver this PowerPivot training at your premises in or around Peterborough, live online, or at a suitable local training venue if you would prefer an external location.

Can you come to our office in Peterborough?

Yes. We regularly deliver on-site training for teams in Peterborough and can usually tailor the session to your team, your documents and the way you work.

Excel training centres near Peterborough

If Peterborough is not the most convenient option, we can also arrange instructor-led Excel training at nearby Computer Tutoring training centres.

Cambridge Ipswich Leicester Milton Keynes Northampton Norwich Peterborough