This page has 0 threads | Add post

Finding our videos useful? Please consider helping us to share more!

Training videos for learning POWERPIVOT

We have 20 PowerPivot videos listed below.

An overview of the Excel Power BI Tools

Posted by Andy Brown on 15 April 2015

An overview of PowerPivot, Power Query, Power View and Power Map in Excel, showing what each of these Power Business Intelligence tools can do, and listing the main advantages and disadvantages of each.

Show this video

Getting started with Power Query

Posted by Andy Brown on 16 April 2015

How to extract, transform and load data using the Power Query add-in within Excel 2013

Show this video

A full Power Query case study

Posted by Andy Brown on 16 April 2015

A complete case study of loading data from an Excel workbook of course dates, including splitting columns by delimiter, merging columns and creating custom columns using the Power Query formula language known informally as "M".

Show this video

Getting started with PowerPivot

Posted by Andy Brown on 17 April 2015

How to create basic pivot tables in PowerPivot (including how to access the Wise Owl Make-a-Mammal database, and how to import data from SQL Server and/or Excel into PowerPivot)

Show this video

Creating data models in PowerPivot

Posted by Andy Brown on 17 April 2015

How to import tables into a PowerPivot data model, only choosing rows and columns of interest, and then hide tables and fields from client view to create a clean, simple data model

Show this video

Pivot tables based on PowerPivot data models

Posted by Andy Brown on 02 June 2015

Learn how to create and use Excel pivot tables based on PowerPivot data models, including creating slicers and timelines and using Quick Explore to drill down.

Show this video

Linking to and importing from other data sources

Posted by Andy Brown on 02 June 2015

This tutorial shows how to link to Excel tables, import from Excel workbooks, paste data in from Word tables, import from Access databases and how to import from SQL Server Analysis Services cubes.

Show this video

Creating calculated columns within PowerPivot

Posted by Andy Brown on 03 June 2015

How to create calculated columns within PowerPivot, including using functions like IF, SWITCH, RELATED and BLANK to create new aggregator columns in pivot tables.

Show this video

Calculated fields (measures) in PowerPivot

Posted by Andy Brown on 04 June 2015

How to create measures (now known as calculated fields) within PowerPivot in the DAX expression language, including a detailed explanation of query context and a guide to how to use the PowerPivot formula editor, and also thoughts on other editors available

Show this video

Using the CALCULATE function in PowerPivot

Posted by Andy Brown on 05 June 2015

How to use the all-important CALCULATE function in Excel pivot tables built on PowerPivot data models, including replacing, removing and editing the query context.

Show this video

The FILTER, RANKX and EARLIER functions in DAX

Posted by Andy Brown on 05 June 2015

Worked examples on some more advanced PowerPivot functions: filtering using FILTER, ordering using RANKX and the hard-to-understand EARLIER function.

Show this video

Using calendars and dates in PowerPivot

Posted by Andy Brown on 08 June 2015

How to create a calendar in SQL Server or Excel for use within a PowerPivot data model, together with ideas for using calendars and creating additional aggregator columns.

Show this video

Using the DAX date functions within PowerPivot

Posted by Andy Brown on 08 June 2015

The DAX expression language used for PowerPivot formulae has lots of useful date functions - this tutorial introduces the most common, with names like TOTALYTD and PARALLELPERIOD.

Show this video

Creating hierarchies within PowerPivot

Posted by Andy Brown on 09 June 2015

A short tutorial on how to create and use hierarchies within PowerPivot data models.

Show this video

Creating KPIs (key performance indicators) within PowerPivot

Posted by Andy Brown on 09 June 2015

An overview of how to create KPIs (or key performance indicators) within pivot tables based on PowerPivot data models, to highlight how well your organisation is doing against internal targets.

Show this video

An Introduction to Power View

Posted by Andy Brown on 15 June 2015

Getting started with Power View reports within Excel, including creating tables (visualisations)

Show this video

Filters in Power View

Posted by Andy Brown on 15 June 2015

A tutorial on how to filter Power View reports using either slicers, filtering or tiles.

Show this video

Creating charts in Power View

Posted by Andy Brown on 15 June 2015

How to create and format Power View charts. This tutorial includes how to create multiple charts, and also how to animate bubble charts over time.

Show this video

Creating maps in Power View

Posted by Andy Brown on 16 June 2015

This tutorial shows how to create maps within Power View views (a separate tutorial shows how to use the separate Power Map application to create maps).

Show this video

An overview of Power Map

Posted by Andy Brown on 16 June 2015

This tutorial gives an overview of how to use Power Map to create maps within Excel (it doesn't pretend to tell you everything about the software, but will show you enough to get you started, and help you decide whether this is the mapping software for you).

Show this video

You might also like to consider booking a place on one of our online or classroom Excel courses, where you could meet the owls behind the videos!

This page has 0 threads

Add a new post

VIDEOS BY CATEGORY

EXCEL CATEGORIES

POWERPIVOT VIDEOS

VIDEOS BY AUTHOR

Training videos for learning POWERPIVOT

An overview of the Excel Power BI Tools

Getting started with Power Query

A full Power Query case study

Getting started with PowerPivot

Creating data models in PowerPivot

Pivot tables based on PowerPivot data models

Linking to and importing from other data sources

Creating calculated columns within PowerPivot

Calculated fields (measures) in PowerPivot

Using the CALCULATE function in PowerPivot

The FILTER, RANKX and EARLIER functions in DAX

Using calendars and dates in PowerPivot

Using the DAX date functions within PowerPivot

Creating hierarchies within PowerPivot

Creating KPIs (key performance indicators) within PowerPivot

An Introduction to Power View

Filters in Power View

Creating charts in Power View

Creating maps in Power View

An overview of Power Map

Head office

London

Manchester