Excel PowerPivot | Woodthorpe IT Solutions Ltd

How we deliver our Excel Power Pivot course

meeting_1

Buy online

Contact us

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

meeting_2

Dates

Open Course Dates

You come to our venue
Suitable for individuals

meeting_3

Buy now

Online Courses

Self paced
Budget Friendly
24/7 Learning

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

Chris Bond
March 06,2015 / 0 Comments
We all picked up some new core skills as well as having the the opportunity to ask specific questions relevant to our daily jobs. This has led to some of the team finding more efficient ways to get through their daily workload.
Tony Miles
March 06,2015 / 0 Comments
The main impact of this is that income has been dragged forward some 4 months increasing profits in the first year of purchase many times covering the cost of the software.
Marie Lewis
March 06,2015 / 0 Comments
Ben’s commitment to their learning meant he stayed around to answerquestions and give additional training where it was needed
Layla Young
March 06,2015 / 0 Comments
Never before have I received such consistently positive and up-beat feedback questionnaires, than from the Excel training delivered by Woodthorpe IT; positive comments not only about the content and the format, but the friendly, supportive and tolerant manner in which is was delivered.
Joseph Orwin
March 06,2015 / 0 Comments
Ed went that extra mile and even stayed behind at the end of the course to cover additional items which weren’t included on the original agenda. Highly recommended and a pleasure to work with.
Cheryl Smart
March 06,2015 / 0 Comments
I would recommend Ben to anyone wanting to develop their own customer led software and requiring staff IT training.
Emma Meadowcroft
March 06,2015 / 0 Comments
Ben was very patient and even stayed behind for certain items that weren't on our original tailored agenda.
Lauren Mann
March 06,2015 / 0 Comments
Everyone loved the little tips you included within the training, your friendly manner and the attention you gave each of our group.
David Garnsworthy
March 06,2015 / 0 Comments
Ben also had numerous time saving tips and advice about potential pitfalls. Ben was very conscientious in his approach and at all times was willing and open to provide help with anything the course attendees did not understand.
De Beers
March 06,2015 / 0 Comments
The feedback from the delegates was very positive, they felt the training was relevant, easy to pick up and understand.
Julie Shipley
March 06,2015 / 0 Comments
From the time i emailed you with an enquiry the service has been 'second to none'. I particularly like the way you tailored the training for our individual needs
March 06,2015 / 0 Comments
The feedback from all our employees has been complimentary and I would certainly not hesitate to recommend that any company looking to improve their IT skills employ Woodthorpe IT Solutions.