Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 7/21/2014 | |
| Level | Intermediate | |
| Runtime | 1h 9m | |
| Closed captioning | Included | |
| Transcript | Included | |
| eBooks / courseware | Included | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
In this course we'll start looking at the visual differences between Power Pivot 2010 and 2013.Then move into creating our first Power Pivot Workbook and Pivot Table. Next we will look at how to format Pivot Tables, explain the differences between Calculated Fields and Columns and then how to hide and refresh our data. Then we will look at basics such as: filtering, exploring, relationships, perspectives, slicers and drill through.
Prerequisites
This course assumes that the users have an understanding of Microsoft Excel and how databases function. The user should have already viewed the Power Pivot: Data Models course before viewing this course.
Learning Paths
This course is part of the following LearnNowOnline SuccessPaths™:
SharePoint 2013 Business User
Meet the expert
Doug Ortiz is an independent consultant whose skillset encompasses multiple platforms including .NET, SharePoint, Office, SQL Server, and Business Intelligence. Doug has a master’s degree in relational databases and over 20 years of experience in IT, over half of which have been within .NET and SharePoint. His roles both in and outside of SharePoint have ranged from architecture, implementation, administration, disaster recovery, migrations, development, and automation of information systems.
Course outline
Basic Concepts
Creating a PowerPivot (10:32)
- Introduction (00:16)
- Visual Differences (00:53)
- Power Pivot Ribbon Tabs (00:17)
- Home Ribbon Tab (00:27)
- Design Ribbon Tab (00:15)
- Advanced Ribbon Tab (00:28)
- Creating our first Workbook (00:23)
- Creating a Data Connection (00:25)
- Demo: Creating a Workbook (01:35)
- Creating a Table (00:35)
- Demo: Creating a Table (04:37)
- Summary (00:15)
Formatting (25:29)
- Introduction (00:23)
- Formatting (01:06)
- Demo: Formatting (04:23)
- Demo: Formatting (cont.) (02:03)
- Calculated Fields (02:29)
- Demo: Calculated Fields (01:56)
- Calculated Columns (01:42)
- Demo: Calculated Column (03:49)
- Hiding and Refreshing Data (00:47)
- Demo: Power Pivot Hide Data (02:29)
- Demo: Power Pivot Refresh Data (04:04)
- Summary (00:12)
DataSet (33:44)
- Introduction (00:15)
- Filters (01:45)
- Filters (Cont) (00:55)
- Demo: Filters (02:39)
- Quick Explore (00:54)
- Demo: Quick Explore (01:47)
- Relationships (01:17)
- Demo: Relationships (03:51)
- Perspectives (00:30)
- Demo: Perspectives (03:35)
- Slicers (02:29)
- Demo: Slicers (03:30)
- Demo: Slicers – Timelines (05:30)
- Drill Through (01:01)
- Demo: Drill Through (03:23)
- Summary (00:14)