Data Modelling and Analysis with Excel Power Pivot

  • Duration – 15 hour

 

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.

All MS EXCEL Courses bundle

$40

Data Modelling and Analysis with Excel Power Pivot

Introduction

 

 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

 

 Conclusion

 

Complete End to End Job Oriented Courses.

Best self paced courses created by industry experts & 24/7 support.

Knowasap Features 

300+ Courses

After your course completion, we provide course completion certificate as well.

Lifetime Access

All courses are for lifetime access.

l

Priority Support

All queries are answered 24/7.

What People Are Saying

Abhilash -

A very good match. i am enjoying every bit.

Sonal-

Experience was quite good and it was very useful and well elaborated course.

Karan-

I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-

I find that the explanation is good and also understandable.

Seyed-

Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-

I really like this course, it was a good match for me :))

Mahesh-

Standard process and hands on covered nicely.

 

Emily-

Perfect, with complete hands on. Well structured and nicely covered.

Kevin-

Great Content, nice and up to the mark course.

Mayuresh-

 

Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-

A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-

 

Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-

Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-

This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -

A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-

Yes lessons are very good. Not so fast, well explained

Kishore-

Worth course for the beginner to invest their time to learn this demanding skills.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us