Excelgoodies-logo

Advanced Excel Reporting, Data Modeling & Analytics with Microsoft Excel Power Pivot

It is a 20 hours program focusing on how to work with massive data sets, extend your Pivot table summarization capabilities, advanced calculations, import data from various sources and, publish the workbooks as interactive web applications.

Before Power Pivot, this kind of analysis was limited to enterprise BI tools such as SAS and Business Objects

In short, this is the best thing to happen to Excel in last 20 years!

Join a Power Pivot Batch at $499

Course Fee

$699
  • Course Duration:
  • 20 Hours (6 Sessions, each of 3 Hours)
  • Pre-requisite:
  • Microsoft PowerPivot for Excel installed
  • Microsoft Excel 2010 installed
  • Mode of Training:
  • Virtual Classroom (Instructor-Led)

What is Power Pivot?

  1. It’s a free Add-in provided by Microsoft for Excel 2010 and above.
  2. A way to handle massive volumes of data in Excel
  3. A way to add any formulas to pivot, and it adjusts!
  4. A way to turn workbooks into self-maintaining web applications
  5. A much more agile and cost effective approach to Business Intelligence
  6. Something that turns workbooks into industrial strength Apps

What will you be able to post-training?

  1. Combine data from different sources
  2. Enjoy fast calculations and analysis
  3. Create visually appealing analytical models
  4. Use DAX to create calculated fields for slicing and dicing data
  5. Work seamlessly via Web browser
  6. Collaborate on analytics solutions

Course Content - Overview

INTRODUCTION TO POWERPIVOT POWERPIVOT ENVIRONMENT TAKING DATA INTO POWERPIVOT CALCULATED COLUMNS DAX MEASURES
  1. Table-Valued Functions
  2. Date and Time Functions
  3. Filter Functions
  4. Information Functions
  5. Logical Functions
  6. Mathematical and Trigonometric Functions
  7. Statistical Functions
  8. Text Functions
  9. Time Intelligence Functions
WORKING WITH MULTIPLE TABLES DISCONNECTED TABLES CREATING ADVANCED DAX MEASURES WITH ADVANCED DAX FUNCTIONS
  1. Calculate()
  2. All()
  3. Filter()
  4. IF()
  5. Switch()
  6. SumX()
CREATING CUSTOM CALENDARS USING ADVANCED FILTER() ADVANCED CALCULATED COLUMNS CREATING ADVANCED DASHBOARDS WITH POWERPIVOT

Testimonials

It was indeed some good learning! Sessions were highly informative with loaded tips here and there by Sami on remembering concepts and implementing it back at work. I really enjoyed Assignments session which truly boosted my confidence in Automation. I see myself approaching real-time Scenarios more confidently and, enjoy being appreciated by my team for some wonderful process automation. Thanks, Sami!

Not to forget, I am happy with the way the entire Team of Excelgoodies interacted throughout the learning process. Cheers!

Frank Young

Business Analyst,

Boston, MA

Course Fee

For One-to-One
personalized training
$699
Join a (Group)
Batch at

$499

Contact Us

  • Mr. Perrie Smith, Business Associate
  • (650) 491-3131
  • inquiry_marketing@excelgoodies.com

Connect us on

@

Learner stories around the world!

Reviews

  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Quality of Assignments
  • Certification Process

Dorothy Green

Analytic Consultant

Sami is truly a passionate trainer, who is more interested in learning of his students. The examples taken are in line with the profile of the group.

Coding was made really simple and fun to work with. Assignments post the session did its...

Read More >>

Derrick Walker,

Senior Data Analyst

The course is structured and delivered really well. The majority of our group was from the non-programming domain and hence, relating to new concepts was challenging..

But, Sami made coding look so homespun. Case studies were good, exposing us to the...

Read More >>

Barbara Wright

Research Associate

Every good course structure requires an expertise trainer to suffice the beauty of the subject and Sami, is just apt for this VBA course.

His equal knowledge on Macros and the industry exposure at different levels made his teaching a child's play...

Read More >>

Mary Scott

Senior Planner

Good course. Case studies and assignments were quite interesting.


Tutor was really patient and highly knowledgeable about every aspect of VBA. It was good learning experience...

Read More >>

Natalie Hall

SEM Analyst

It was an excellent experience to learn a vast amount of information in a relative short time period.

It made me much more confident to assume an analyst position with the company. It was a very good and complete course for the topics...

Read More >>

Other Excel Courses offered

Advanced Excel Training

View Details

Excel VBA Macro Training

View Details

Excel Training For HR

View Details

MIS Reporting with Excel

View Details