VIDEOS BY CATEGORY▼
EXCEL CATEGORIES▼
POWERPIVOT VIDEOS▼
- 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
VIDEOS BY AUTHOR▼
Training videos for learning POWERPIVOT
We have 20 PowerPivot videos listed below. You might also like to consider booking a place on one of our online or classroom Excel courses, where you will meet the owls behind the videos!
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.
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
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".
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)
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
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
Posted by Andy Brown on 15 June 2015
Getting started with Power View reports within Excel, including creating tables (visualisations)
Posted by Andy Brown on 15 June 2015
A tutorial on how to filter Power View reports using either slicers, filtering or tiles.
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.
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).
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).