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

  • (102)

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. Foster Matthew, Business Associate
  • (650) 491-3131
  • inquiry_sanfrancisco@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...

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

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

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

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