PowerPivot and Power View for Excel 2013

Excel

If you are using PowerPivot for Excel 2010, then click here.

The following collections of links and resources will help you go from short video overviews of PowerPivot and Power View capability to being fairly proficient.

Video Overview of Excel 2013 PowerPivot and Power View

Here’s a collection of short videos from Microsoft on Excel 2013 PowerPivot and Power View.

collection of short videos that give a good overview of PowerPivot and Power View.

Microsoft has a collection of short videos that give a good overview of PowerPivot and Power View.

https://support.office.com/en-us/Article/Power-View-and-Power-Pivot-videos-4386de23-041a-4792-b6ec-c40f72ecf693

There are more links to videos later in the blog.

Starting the Add-in for PowerPivot in Microsoft Excel 2013

PowerPivot in Microsoft Excel 2013 does not have to be downloaded. It is already installed, you just have to enable it. While you are enabling PowerPivot you should enable Power View at the same time.

https://support.office.com/en-nz/article/Start-the-Power-Pivot-in-Microsoft-Excel-add-in-a891a66d-36e3-43fc-81e8-fc4798f39ea8?ui=en-US&rs=en-NZ&ad=NZ

PowerPivot and Power View for Excel 2013 Tutorial

The PowerPivot for Excel 2013 tutorial is a sequence that begins by importing data and teaching you about the data model behind the PowerPivot. It goes all the way through to creating some amazing charts in Power View.

It’s easy on Microsoft’s website to start a tutorial for the wrong version of Excel. Be careful. This series of tutorials takes you from creating a data model and importing data, to joining data, adding calculated fields, using a Pivot Table, and finally building awesome dashboards using Power View. Grab a snack, warm up the cup, and set your Microsoft Skype to “Do Not Interrupt” and learn some cool stuff.

Bubble charts are quick to create in PowerView.

Bubble charts are quick to create in PowerView.

1. Import Data into Excel 2013, and Create a Data Model

https://support.office.com/en-us/article/Tutorial-Import-Data-into-Excel-2013-and-Create-a-Data-Model-4b4e5ab4-60ee-465e-8195-09ebba060bf0?ui=en-US&rs=en-US&ad=US

2. Extend Data Model relationships using Excel 2013, PowerPivot, and DAX

https://support.office.com/en-us/article/Tutorial-Extend-Data-Model-relationships-using-Excel-2013-Power-Pivot-and-DAX-cf7197d3-1938-490e-93fb-20371e8dd67a?ui=en-US&rs=en-US&ad=US

PowerPivot enables you to connect multiple large data files.

PowerPivot enables you to connect multiple large data files.

3. Create Map-based Power View Reports

https://support.office.com/en-us/article/Tutorial-Create-Map-based-Power-View-Reports-62ecd29a-91b8-4e5c-b3b7-4aef9f7ef962?ui=en-US&rs=en-US&ad=US

PowerView makes it easy to create interactive maps that acts as filters.

PowerView makes it easy to create interactive maps that acts as filters.

4. Incorporate Internet Data, and Set Power View Report Defaults

https://support.office.com/en-us/article/Tutorial-Incorporate-Internet-Data-and-Set-Power-View-Report-Defaults-a0b627f4-edcb-42fa-9815-646077064a7a?ui=en-US&rs=en-US&ad=US

5. Create Amazing Power View Reports – Part 1

https://support.office.com/en-us/article/Tutorial-Create-Amazing-Power-View-Reports-Part-1-e2842c8f-585f-4a07-bcbd-5bf8ff2243a7?ui=en-US&rs=en-US&ad=US

Tiling data enables comparative layouts.

Tiling data enables comparative layouts.

6. Create Amazing Power View Reports – Part 2

https://support.office.com/en-us/article/Tutorial-Create-Amazing-Power-View-Reports-Part-2-361b1fca-4429-42a2-94a2-e4d5f3e7d170?ui=en-US&rs=en-US&ad=US

You can even bubble charts that animate over time.

You can even create bubble charts that animate over time.

Power View for Excel 2013

You’ve already seen earlier information about Power View for Excel 2013. The previous tutorial for PowerPivot also included multiple tutorials on how to create Power View dashboards.  The following tutorial is devoted exclusively to Power View.

https://support.office.com/en-US/article/Power-View-Explore-visualize-and-present-your-data-98268D31-97E2-42AA-A52B-A68CF460472E

For a longer video that shows a number of tips and tricks, checkout this presentation made at the Microsoft TechEd 2014 conference. It’s about an hour in length, but has some great stuff.

Interactive Data Visualization with Power View from Microsoft TechEd 2014

Data Analysis Expressions (DAX) in PowerPivot

Data Analysis Expressions (DAX) are the new database functions built into both versions of PowerPivot. PowerPivot for Excel 2013 has additional functions to those in Excel 2010. Adding calculated columns to the data model and using many of the DAX functions will be straightforward to any intermediate Excel users. However, some of these DAX functions are very powerful, but are real brain twisters.

Data Analysis Expressions (DAX) in PowerPivot

https://support.office.com/en-US/article/Data-Analysis-Expressions-DAX-in-Power-Pivot-BAB3FBE3-2385-485A-980B-5F64D3B0F730

I highly recommend getting a copy of Rob Collie’s book. Rob was an insider in the development of the Power tools. A number of his tips and tricks saved me frustration and time.

DAX Formulas for PowerPivot by Rob Collie

Rob has a website with PowerPivot blog and classes at

http://www.powerpivotpro.com/

Recommended Excel Power Pivot 2013 Videos and Books

As an introduction to PowerPivot for either Excel 2010 or Excel 2013 version take a look at

PowerPivot for the Data Analyst: Microsoft Excel 2010 by Bill Jelen

Bill’s book is published by Que, my old publisher.

Bill also has a series on playlist of 23 videos on Excel 2013’s PowerPivot, Power View, and Power Query (we didn’t talk about Power Query.)

To get the data files for all of the 2013 videos, download this file and scroll down to the PowerPivot for Excel 2013 section.

https://people.highline.edu/mgirvin/excelisfun.htm

The “Everything” Help Page for PowerPivot in Microsoft Excel 2013

This Microsoft page has a lot of resources and tutorials. If you can’t figure out how to do something, come here.

https://support.office.com/en-US/article/Get-started-with-Power-Pivot-in-Microsoft-Excel-2013-FDFCF944-7876-424A-8437-1A6C1043A80B

Share the power...

Leave a Comment:

Leave a Comment: