Certificate In Data Modelling and Analysis with Excel Power Pivot Online Course

Create relationships between tables & use DAX calculations


NOW ONLY

US$99

Save US$500 (83%)
OFF RRP US$599
Get Info Pack

Create relationships between tables & use DAX calculations

Power Pivot has been described as the most important new feature in Excel in 20 years. Power Pivot has been developed by Microsoft to help companies analyze and understand the growing quantities of data that are created on a daily basis.

Power Pivot will improve your time to create reports, develop data analysis and gain insight into your your data by at least 80%.

  • Create relationships between tables of data without Vlookups
  • Create powerful Key Metric and Key Performance Indicator calculations
  • Manage and work with data models of millions of records of data
  • Create powerful new dashboards and reports

Power Pivot is a free Add-in for Excel 2010 and is called the Data Model in Excel 2013 that provides capabilities to handle large quantities of data. PowerPivot is a columnar database that is capable of storing and manipulating hundreds of millions rows of data. PowerPivot brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. PowerPivot has been referred to as the most important feature for Excel in 20 years.

Power Pivot makes it easy to setup relationships between tables of data in the same way as databases and therefore does not require the use of Excel functions such as Vlookup. PowerPivot therefore decreases the time substantially to analyse and gain new insight from business and marketing data.

Power Pivot allows the rapid development of powerful PivotTables and PivotCharts in Excel utilising the latest Slicer technology to easily analyse and view data from multiple different perspectives. PowerPivot also adds a new Data Analysis Expressions (DAX) formula language that provides new and powerful calculations and insight to the business user.

Course Fast Facts:

  1. Learn the fundamentals of Data Modelling and Analysis with Excel Power Pivot
  2. Comprehensive 9 module Accredited Certificate In Data Modelling and Analysis with Excel Power Pivot Online Course
  3. Study along with simple instructions & demonstrations
  4. Written and developed by leading Data Modelling and Analysis with Excel Power Pivot experts
  5. Receive one-on-one online help & support
  6. Unlimited, lifetime access to online course
  7. Certificate of completion
  8. Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device

Course Delivery

Courses For Success classes are accessed online  by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. 

Recognition & Accreditation

All students who complete our courses, including the hugely popular data visualization course receive a certificate of completion and will be issued a certificate via email.

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

  • Conclusion

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

About this Course

Create relationships between tables & use DAX calculations

Power Pivot has been described as the most important new feature in Excel in 20 years. Power Pivot has been developed by Microsoft to help companies analyze and understand the growing quantities of data that are created on a daily basis.

Power Pivot will improve your time to create reports, develop data analysis and gain insight into your your data by at least 80%.

  • Create relationships between tables of data without Vlookups
  • Create powerful Key Metric and Key Performance Indicator calculations
  • Manage and work with data models of millions of records of data
  • Create powerful new dashboards and reports

Power Pivot is a free Add-in for Excel 2010 and is called the Data Model in Excel 2013 that provides capabilities to handle large quantities of data. PowerPivot is a columnar database that is capable of storing and manipulating hundreds of millions rows of data. PowerPivot brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. PowerPivot has been referred to as the most important feature for Excel in 20 years.

Power Pivot makes it easy to setup relationships between tables of data in the same way as databases and therefore does not require the use of Excel functions such as Vlookup. PowerPivot therefore decreases the time substantially to analyse and gain new insight from business and marketing data.

Power Pivot allows the rapid development of powerful PivotTables and PivotCharts in Excel utilising the latest Slicer technology to easily analyse and view data from multiple different perspectives. PowerPivot also adds a new Data Analysis Expressions (DAX) formula language that provides new and powerful calculations and insight to the business user.

Course Fast Facts:

  1. Learn the fundamentals of Data Modelling and Analysis with Excel Power Pivot
  2. Comprehensive 9 module Accredited Certificate In Data Modelling and Analysis with Excel Power Pivot Online Course
  3. Study along with simple instructions & demonstrations
  4. Written and developed by leading Data Modelling and Analysis with Excel Power Pivot experts
  5. Receive one-on-one online help & support
  6. Unlimited, lifetime access to online course
  7. Certificate of completion
  8. Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device

Course Delivery

Courses For Success classes are accessed online  by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device. 

Recognition & Accreditation

All students who complete our courses, including the hugely popular data visualization course receive a certificate of completion and will be issued a certificate via email.

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

  • Conclusion

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet. 

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

We provide a 7 Day Money Back Refund on all Courses

Now Only US$99 Save US$500 (83%)
OFF RRP US$599
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 009SRDMAEP
Delivery Mode: Online
Course Access: Unlimited Lifetime
Tutor Support: Yes
Time required: Study at your own pace
Course Duration: Hours
Assessments: Yes
Qualification: Certificate

Popular Courses and Bundles