Woodthorpe IT Solutions Ltd

powerpivot_01

How we deliver our Excel Power Pivot course

Contact us

  • We come to you
  • We bring all the equipment needed
  • The outline can be customised

From £700 per day
(additional expenses may be payable)

Open Course Dates

  • You come to our venue
  • Suitable for individuals

From £125 per day per person

Online Courses

  • Self paced
  • Budget Friendly
  • 24/7 Learning

From £29 per person


Identifying the Role of Power Pivot in Business Intelligence (BI)
  • Introducing Power Pivot
  • Accessing the Power Pivot add-in
  • Navigating the interface
  • Loading a single data source
  • Creating a dashboard
Employing Power Pivot in the BI process
  • Extracting information from data with Power Pivot
  • Uncovering data interpretation issues
Building the Data Model with Power Pivot
  • Defining a consolidated view of data
  • Generating a data mashup from structured and unstructured data sources into a data model
  • Deriving relationships from data sources with the Relationships tool and the Diagram View
Denormalising data to simplify usage within other BI reporting tools
  • Acquiring data from related tables
  • Defining calculated columns
  • Consolidating information available to BI tools
Querying SQL Server data
  • Designing queries to import data from SQL Server
  • Relating tables with outer joins
Fixing common data issues with Power Query
  • Extracting, Transforming and Loading (ETL) data
  • Converting data formats with Power Query steps
  • Parsing columns to aid analysis
  • Removing duplicates from a data set
  • Constructing a single data set from multiple sources with the same field headings
Manipulating and Analysing Data with the Data Analysis eXpressions (DAX) Language
  • Defining calculated fields for business performance
  • Distinguishing the role of calculated fields
  • Translating key business concepts into calculated fields
  • Providing context for calculated fields within a PivotTable
  • Determining between implicit and explicit calculated fields
 Implementing DAX functions in Power Pivot
  • Expressing information with calculated fields
  • Exposing hidden information from data
  • Troubleshooting and debugging DAX calculations
Exploiting data analytics with aggregation
  • Quantifying and mining information with DAX functions
  • Summarising and aggregating data from other tables with the X functions
  • Evaluating expressions with the CALCULATE() function and filter functions
  • Substituting values with the SWITCH() function
Mining for information with date and time analysis
  • Grouping dates for time analysis
  • Comparing and categorising time periods with Time Intelligence functions
Setting key business targets with KPIs
  • Analysing performance with calculated fields
  • Gauging performance against goals
Presenting Information with Dashboards
  • Articulating and analysing data
  • Drilling down into data using a hierarchy
  • Managing data with perspectives
  • Identifying patterns and trends in your Power Pivot data with Power View charts
  • Classifying data into different geographical regions
Designing effective dashboards
  • Contextualising calculated fields with PivotTable slicers and Power View filters
  • Documenting structures with Hierarchical Diagrams
  • Visualising and comparing performance matrices with Power View multipliers
  • Globalising location-based results to identify trends and patterns on a 3D scale with
Power Map
  • Creating Team BI Solutions
  • Defining the requirements for a team solution
  • Coordinating results with team members
  • Sharing a Power Pivot solution

 

This course is a two day course but can be condensed in to a 1 day session.


What our customers say

North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

×
IFA Practice Manager

No flash installed

×
Production Scheduling Tool

No flash installed

×
Format As Table Part 1

No flash installed

×
Format as a table part 2

No flash installed

×
Subtotalling a list

No flash installed

×
Sorting basics

No flash installed

×
Cell Styles

No flash installed

×
Remove Duplicates In List

No flash installed

×