Sunday, July 16, 2017

Power View and Power Pivot videos

Power View and Power Pivot videos

Here's a collection of videos about Power View and Power Pivot in Microsoft Excel 2013.

Get started with Power View

play icon

More about creating Power View sheets in Excel 2013.

Create visualizations

Bubble and scatter charts   

play icon

More about bubble and scatter charts.

Pie charts   

play icon

More about pie charts.

Multiples

play icon

More about multiples.

Cards

play icon

More about cards.

Tiles   

play icon

More about tiles.

Matrix   

play icon

More about matrices.

Maps

Create maps   

play icon

More about maps.

Fix ambiguous map data   

play icon

More about maps.

Explore data

Filters   

play icon

More about filters and highlighting.

Highlighting   

play icon

More about highlighting.

Slicers   

play icon

More about slicers.

Sort   

play icon

More about sorting.

Refresh data and the data model

play icon

More about refreshing the data or data model.

Hierarchies

Drill down in an ad-hoc hierarchy

play icon

More about drill-down.

Drill down with a hierarchy in the model   

play icon

More about drill-down.

Work with hierarchies   

play icon

More about hierarchies.

Power Pivot

Set default fields   

play icon

More about setting default fields for Power View reports

Hide columns and tables   

play icon

More about hiding tables, columns, and fields from PivotTables and Power View.

Add descriptions to columns and tables   

play icon

More about adding descriptions to Power Pivot tables, columns, and fields.

Relationships   

play icon

More about relationships in Power View.

Summarize by   

play icon

More about setting default aggregations.

See also

Power Pivot: Powerful data analysis and data modeling in Excel

Power View: Explore, visualize, and present your data

Tutorial: PivotTable data analysis using a Data Model in Excel 2013

Download the Excel workbook with the Olympics dataset

No comments:

Post a Comment