Drastically cut down repetitive tasks, apply rigorous analysis on voluminous data and create professional and interactive Business Dashboards using Modern Excel and PowerBI

 

 

HOW WILL IT WORK ?

You and I will do the learning session over a webinar (on weekends) for a few hours. The webinar training will enable you to

  • Understand the concepts in a phased out manner
  • Revise from previous webinar recordings
  • I’ll give you assignments to practice at home

 

TRAINING SCHEDULE

  • Session 1 (3 Hours) – Sunday 12 Aug 2018  |  7:30 PM to 10:30 PM
  • Session 2 (3 Hours) – Saturday 18 Aug 2018  |  7:30 PM to 10:30 PM
  • Session 3 (3 Hours) – Sunday 19 Aug 2018  |  7:30 PM to 10:30 PM
  • Session 4 (If required, 3 Hours) – Sunday 26 Aug 2018  |  7:30 PM to 10:30 PM

 

 

 

BI Outline

 

WHAT WILL YOU LEARN (A Short Summary)

You’ll learn to work with 3 Business Intelligence Add-Ins from Microsoft

  1. Power Query – You’ll learn to automate repetitive data cleaning tasks (consolidating data, multiple lookups, grouping and a lot more data cleanups) a 100 x faster
  2. Power Pivot – We’ll be spending most of the time learning the DAX (Data Analysis Expressions) formula language which enables far more sophisticated and in-depth analysis compared to regular excel formulas and pivot tables
  3. Power View – You’ll then learn to visualize the analysis using modern visualizations of Power View / Power BI

 

I strongly recommend you to read the training outline thoroughly.

 

WHO IS IT FOR ?

  • “9-5” (or better said 9-9) Excel users – already good with Pivots, Lookup formulas, Sumifs, Countifs, etc. intensively working with data reporting and analysis. You surely need to be a part of this
  • Tired of working with conventional Excel – If you are tired of doing repetitive manual work in Excel and willing to learn sophisticated Data Analysis, it is a big qualifier for you to take the workshop
  • You need NOT have any coding / tech / computing background to learn these skills

 

WHAT IS INCLUDED ?

  • You’ll be given 2-3 pre training videos to brush up Pivot Table concepts
  • You’ll also be able to get video recordings of the webinar sessions
  • All participants will also get training exercises
  • Practice Assignments and Challenge questions
  • Since the training will be spread over 3 sessions, you’ll get plenty of time each week to practice and ask questions
  • Post Training Support

 

PREREQUISITES 

  1. You must have uninterrupted hi-speed internet during the course of webinar sessions
  2. You need to have the following excel add-ins installed. They are free!
  3. Or you can just Install Power BI Desktop, its free again

 

 

REGISTRATION LINKS 

I look forward to teach you some pretty solid data analysis skills !

For Indian Students – INR 12,000

For International Students – $199