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

Open Course Dates

  • You come to our venue
  • Suitable for individuals

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

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