You will be learning in-detail about all the techniques of Power Pivot of excel and what are its usages & benefits. This course will help you to know how Power Pivot  will help to analyze the comprehensive data to make timely business decisions. This class is ideal for Excel users that want to pull data into Excel using Power Query and summarize and analyze the data in Power Pivot. 

For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, and Excel Intermediate Part 2 classes.

• What is Power Pivot, Power Query, Power View and Power Map
• The Power Suite Workflow
• Power Query Examples
• Power Pivot Examples
• Power View Examples

• Introduction
• Understanding Excel’s Data Model
• Data View versus Diagram View
• Database Normalization
• Data Tables versus Lookup Tables
• Relationships versus Merged Tables
• Creating Table Relationships
• Updating Table Relationships
• Active versus Inactive Relationships
• Relationship Cardinality
• Connecting Multiple Data Tables
• Data Filter Direction
• Hiding Fields from Client Tools
• Defining Hierarchies

• Introduction
• Creating a Power Pivot Table
• Power Pivots versus Normal Pivots
• Data Analysis Expression (DAX) Overview
• Calculated Columns
• DAX Measures
• Creating Implicit Measures
• Creating Explicit Measures (AutoSum)
• Creating Explicit Measures (Power Pivot)
• Filter Context
• Measure Calculation Steps
• Dimensions vs Measures
• Best Practices