Power Pivot, Part 1 of 5: Data Models

with Doug Ortiz

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.

Course Outline