Wise Owl - Excel 2013 Power BI Tools training videos

Showing videos 1-20 (out of 20)

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

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".

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.

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)

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.

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).

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).

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 to decide whether this is the mapping software for you).

This page has 0 threads Add post