Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 7/14/2014 | |
| Level | Intermediate | |
| Runtime | 0h 59m | |
| Closed captioning | Included | |
| Transcript | Included | |
| eBooks / courseware | Included | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
In the course will be introduced to Power Pivot 2013, what it is, what is new to Power Pivot 2013 and its place in Business Intelligence arena. Leading us into what is a Pivot Table, configuring and enabling Power Pivot 2013 and finalizing with platforms that support Power Pivot. Then we will take a look at Data Models and how they fit within Power Pivot 2013.We’ll then see types of Data Models and how they relate to Data Connections and how SQL Query Designer can be used as a Data Modeling Tool. Then we will look at importing data from other Data Connections and combining them together within a Power Pivot Workbook.
Prerequisites
This course assumes that the users have an understanding of Microsoft Excel and how databases function.
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
Data Models
Introduction (12:38)
- Introduction (00:29)
- Introduction (01:47)
- What is Power Pivot? (02:07)
- New to Power Pivot 2013 (01:22)
- Power Pivot 2013 Place in BI (01:39)
- What is PivotTable? (01:12)
- Configuration (01:34)
- Enabling Power Pivot 2013 (00:43)
- Demo: Enabling in Excel 2013 (01:32)
- Summary (00:08)
Data Models (21:03)
- Introduction (00:23)
- Data Models (02:03)
- Physical Data Models (00:28)
- Physical Models Example (00:58)
- Logical Data Models (00:24)
- Logical Data Models Example (01:09)
- Understanding Data Connections (00:55)
- SQL Query Designer (01:47)
- Demo: T-SQL & Power Pivot (03:44)
- SQL Server (01:57)
- Demo: SQL Server & Power Pivot (03:15)
- Access (01:23)
- Demo: Access & Power Pivot (02:08)
- Summary (00:23)
Data Models Continued (26:06)
- Introduction (00:12)
- Excel Workbooks (00:59)
- Demo: Excel & Power Pivot (03:14)
- Text Files (00:47)
- Demo: CSV Files & Power Pivot (03:22)
- Data Feeds (01:16)
- Demo: OData & Power Pivot (03:28)
- SharePoint (01:08)
- Demo: SharePoint & Power Pivot (03:30)
- Analysis Services (00:52)
- Demo: Analysis & Pivot (03:01)
- Combining Data Connections (01:21)
- Demo: Combining Data Sources (02:29)
- Summary (00:21)