Excel Reporting, Data Modeling & Analytics with Power Pivot Training in Newyork

  • (121)

It is a 15 hours program focusing on how to work with huge 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.

Talk to the Trainer

Know your current Excel skills through a quick pre-assessment, discuss your requirements (if any) with the Trainer and, feel your comfort level before regestering for the program.

Course Fee

$499
  • Course Duration:
  • 15 Hours (5 Sessions, each of 3 Hours)
  • Pre-requisite:
  • Adequate knowledge on Pivots & Formulae
  • 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's included in your 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()
  7. Statistical Functions
  8. Text Functions
  9. Time Intelligence Functions
CREATING CUSTOM CALENDARS USING ADVANCED FILTER() ADVANCED CALCULATED COLUMNS CREATING ADVANCED DASHBOARDS WITH POWERPIVOT

Testimonials

"Informative workshop! It has substantially enriched my knowledge and added value to my Career Profile. I really appreciate the way Sami go out of the way to help us understand the topics.

I come from a non-programming background yet, the topics were taught in the most laymen language making it a child’s play. I feel so happy to write the coding all by self and automating my various day-to-day tasks.

The program was the right balance of relevant theoretical inputs and hands-on practical exercises. Well structured! My special thanks to Sami."

Michael Joshua

Operations Analyst,

Shell, TX

Training Schedule

OR

Contact Us

  • Mr. Perrie Smith, Business Associate
  • (315) 633-4414
  • inquiry_newyork@excelgoodies.com

Connect us on

@

Learner stories around the world!

Reviews

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

Jayden Noah

Financial Analyst

Programming is something I thought would never be able to get hang on. I really appreciate Mr. Sami for making the most complex concepts look so simple.

I wouldn’t be wrong and, shall not be the only one who would say...

Read More >>

Michael Joshua,

Operations Analyst

Informative workshop! It has substantially enriched my knowledge and added value to my Career Profile. I really appreciate the way Sami go out of the way to help us understand the topics.

I come from a non-programming background yet, the topics were taught in the most laymen...

Read More >>

Frank Young

Business Analyst

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...

Read More >>

Karen Smith

Quantitative Analyst

Good sessions. Highly passionate trainer. Sami was quick enough to identify the skill sets and the knowledge of the participants to pace his training accordingly.

His way of simplifying the coding concepts was just spell bounding. He knew his students...

Read More >>

Cody K

Risk Reporting Developer

A well-structured program. The flow of training was carried out pretty well by the tutor. Enjoyed working with case studies and the concepts were taught in the simplest way

It made me much more confident to assume...

Read More >>