Excel Reporting, Data Modeling & Analytics with Power Pivot in Chicago, IL

  • (128)

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
  • (650) 491-3131
  • inquiry_chicago@excelgoodies.com

Connect us on

@

Learner stories around the world!

Reviews

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

Kevin Thomas

Sr Financial Analyst

Intensive course and an awesome trainer to deliver it beautifully. Case studies and the live project at the end of the course has given me the real hang on automation.

It has added a new dimension to my finance career profile. Thanks, Sami! for being such a...

Read More >>

Edward Brown,

Data Analyst

Comprehensive program with loads of case studies yet a very simple learning approach. Every automation I do, I learn new things.

It feels awesome to become the one point destination for all my teammates to automate stuff. All best wishes to Sami...

Read More >>

Linda Parker

Sr.Business Analyst

Structured Course. Well designed case studies and a good trainer. Coding was made really simple with easy to understand examples.

Object orientation session has made me strong in understanding the limbs of every scenario Overall, some good learning! Thanks, Sami....

Read More >>

Jacob Collins

Financial Analyst

Awesome Course! Concepts were made simple to understand. Automation is real fun now. Thanks to my tutor.

It would be great if you could send us few more case studies as we had a challenge taking up a project.

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