Data Modelling and Analysis with Excel Power Pivot

Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. 

Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Data Modelling and Analysis with Excel Power Pivot



 Welcome to Power Pivot


 Overview of the Power Pivot Course


 Activating Power Pivot in Excel


 Download the Training Data File


 Loading Data into Power Pivot


 Browse Filter and Sort Power Pivot Data


PowerPivot Menu Options


 Home Menu Options


 The AutoSum Function in Power Pivot


 Design Menu Options


 The Advanced Menu Option


 Power Pivot Menu in Excel


Creating Pivot Tables with PowerPivot Data


 Creating Pivot Tables


 Changing the Method of Aggregation


 Pivot Table Calculations


Filtering with Slicers


 Pivot Table Filters and Slicers


 Pivot Table and Pivot Chart


 Creating Hierarchies


Create Relationships with PowerPivot Data


 Download the Training Data File


 Create Relationships to Master Data


 Create Pivot Tables with Table Relationships


DAX Calculated Columns


 Download the Training Data Files


 Create Calculated Columns in DAX


 Date Functions in Power Pivot


 Using the Sort By Option


 Download the Date Master File


 Create a Date Table


 Text and Logical Calculated Fields


 Download the Price Increase File


 Creating Related Calculated Formulas


DAX Measures


 Review of Calculated Measures


 Power Pivot Calculated Fields


 The Calculate Formula


 Date Mesure Examples


Named Sets and KPIs


 Download the KPI Workbook


 Creating Named Sets


 Creating KPIs




More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us