Module 1: Introduction to PowerPivot 2013
This module explains how to enable PowerPivot in Excel 2013. It also reviews the PowerPivot workspace and gives a brief explanation of the various actions available in the workspace.
- Enable PowerPivot within Microsoft Excel 2013
Module 2: Building Data Models
This module begins with defining a data model and how it is used to create PivotTables and PivotCharts. The Manage Data Model window is discussed in detail in this module. In addition, the various methods for adding data to the model are covered.
- Review Data Models
- Create Data Models
Mobile 3: Create a PivotTable and PivotChart
This module covers the difference between tables and charts and the various options that are available. In addition, this module will walk the user through creating a basic PivotTable and PivotChart. PivotTable Tools and PivotChart Tools contextual tabs are covered in this module. These tabs allow further customization to the basic PivotChart and PivotTable.
- Determine chart or table
- Create a PivotTable
- Create a PivotChart
Module 4: Use DAX in PowerPivot
- Review and define DAX
- Discuss context used in DAX
- Define calculated columns
- Define calculated fields
Module 5: Enhance PivotTables and PivotCharts
This module covers using KPIs (Key Performance Indicators), slicers and hierarchies to further enhance your PivotCharts and PivotTables. In addition the slicer tools options contextual tab is covered. This tab allows customization to the display of the slicers.
- Define key performance indicators (KPIs)
- Define slicers
- Define hierarchies
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama u toku trajanja kursa
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
Poželjno predznanje:
Some experience using Excel, including creating and using formulas and some exposure to PivotTables.
Dalje usavršavanje:
Analyzing Data with Excel (MS20779)
PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts (MS55049)