Setting-up Power Pivots

• Installing and Running PowerPivots
• Defining Data Relationships
• Creating One Pivot Table from Four Multiple Tables

Creating and Managing Relationships

• Applying the Autodetect Tools
• Manually Defining Relationships without VLOOKUP
• Importing Excel Data into PowerPivots
• Importing Data from SQL, Access and Atom Feeds
• Converting your Data into a Table and Establishing Linking Relationships
• Using the Slicer Autolayout

Managing the Data Sheet View

• Applying Numeric Formatting
• Sorting and Filtering Data in PowerPivots
• Adding New Columns using Data Analysis Expression Formulas ? DAX
• Working with Text, Logical, Date, Information, and Time Functions

New Tools with PowerPivot

• Building Report with Two Pivot Charts
• Working with Slicer and Auto Layout
• Slicer Management and Techniques

Data Analysis Expression - DAX

• Designing Customized Formulas
• Cross-Referencing DAX Measures
• Creating Time Intelligence Functions
• On-Demand DAX Measures

Working with GetPivotData and Cube Formulas

• Defining Territories with Named Sets
• Asymmetric Reporting with PowerPivot
• Producing Perfectly Formatted Shell Report
• Converting PivotTable to Cube Formulas
• Customizing the Formatted Reports

Report Formatting Tools and Techniques

• Charts Formatting Using Descriptive Titles
• Using Slicer in Charts instead of on-Chart Controls
• Replace Chart Legends with Labels
• Removing Excel Interface Elements

Dashboarding with PowerPivot

• Designing Business, Accounting and Financial Dashboards
• Adding Dynamic Modeling Buttons
• Refreshing and Updating your Dashboard