SPECIALISTS IN FINANCIAL MODELLING
36 item(s) $1,185.00 AUD + GST

Power Excel - Power BI, Power Pivot, Power Query - Chandoo Masterclass

Course info

Duration : 2 Days

Cost: $1,540.00 inc. GST.

Testimonials

"The workshop was a very good introduction to Power Pivot. What I learnt in two days would probably take me months to learn by myself. Very worth while workshop!The presenter provided clear explanations and has a very good knowledge on all Excel related topics.Data Analysis and Power Pivot, Melbourne, May 2015"

View testimonials for this course

Download the course outline

Upcoming workshops

Take this course in-house

Online Courses

Interested in taking this course online? Register your interest now!

This course is part of the 2018 Chandoo Masterclass Special Event.  There are two masterclasses being run ONLY during May and June 2018 in Australia:

The masterclasses are designed to be attended for four consecutive days but either two day session can be undertaken independently.  Chandoo is also available for a limited number of in-house sessions.  Please contact us to book Chandoo to come to your organisation during his trip to Australia for a private in-house session.

Benefits of Attending

  • Exposure to best-in-class dashboard techniques, design ideas & practical tips
  • Tips & ideas on using Excel better
  • USB stick with Example workbooks, PDF guides & videos
  • Access to selected videos & material on Chandoo.org
  • Networking opportunities with fellow professionals & Chandoo
  • Email support for your Excel questions for three months by Chandoo.org

Who Should Attend

This program is aimed at:

  • Managers
  • Systems & Reporting Analysts
  • Business & Data Analysts
  • MIS Reporting Analysts
  • Business Intelligence Professionals
  • Executives in Sales, Finance, Marketing or Customer Service

If you use Excel for more than 6 hours a week, you will benefit from this Masterclass.

Masterclass Agenda

DAY ONE

  • What is Power BI, Power Pivot and Power Query
  • Morning break
  • Data collection and clean up with Power Query
  • Lunch break
  • Cycle sharing in Melbourne - your first interactive viz with Power BI

DAY TWO

  • Analyzing data with Power Pivot - DAX, measures and relationships
  • Morning break
  • Financial Performance Dashboard - Advanced reporting with Power BI - interactive exercise
  • Lunch break
  • Interactive exercise contd.
  • Conclusions - Power BI best practices, resources and what lies ahead.

Chandoo, Your Masterclass Leader

Chandoo, known for his most popular Excel & Dashboard site, Chandoo.org is famous for his clear explanations, practical approach and Excel mastery. Chandoo has trained more than 5,000 professionals from all over the world in Excel, Advanced Excel, Dashboards, VBA & Project Management. For his contribution to MS Excel users, Microsoft has awarded him the prestigious MVP award for years 2009, 2010, 2011, 2012 & 2013.

Chandoo (otherwise known as Purna Duggirala) is an MBA with more than 8 years’ experience in Excel based dashboards, reporting & consulting, and regularly travels the world delivering his specialist workshops.

What Chandoo’s past students say:

  • Chandoo is full of new innovative ways to crunch and communicate data.
  • The course contained good examples; he is a very open and responsive teacher.
  • This course has taught me more than I learnt in three years of working on my own!
  • It really made me re-evaluate the way I worked Excel to deliver my results.
  • I’ve always loved working with Excel, but this course gave me the kick to take my existing skills to the next level.
  • I enjoyed learning about the new, innovative features of Excel. Watching them used in ways that differ from what I have become accustomed to was great. The most mind-expanding topic for me was SUMPRODUCT formula. Very clever!

What do you get?

By attending this workshop, you will receive:

  • Two full days of tuition by Dashboard expert, Chandoo
  • Use of workstations, lunch and refreshments
  • Access to selected videos & material on Chandoo.org
  • Exposure to best-in-class dashboard techniques, design ideas & practical tips
  • Tips & ideas on using Excel better
  • USB stick with Example workbooks, PDF guides & videos
  • Access to selected videos & material on Chandoo.org
  • Networking opportunities with fellow professionals & Chandoo
  • Email support for your Excel questions for three months by Chandoo.org

What should you have?

Suggested Skill Level

To benefit the most from this workshop, you need to have intermediate level working knowledge of MS Excel. 

Understanding of basic business terminology and reporting situations. 

Targeted at managers, analysts & reporting professionals with 3-7 years of experience

Software

This Masterclass is run in a specialist training venue with workstations provided. The course is demonstrated using Microsoft Excel 2016, but students can use older versions if they prefer. Delegates may also bring their own laptops.

Course fee of only $1,400 plus GST includes:

  • Two full days of tuition by Dashboard expert, Chandoo
  • Use of workstations, lunch and refreshments
  • USB stick with Example workbooks, PDF guides & videos
  • Access to selected videos & material on Chandoo.org
  • Email support for Excel questions for 3 months following the course by Chandoo.org
Attend all four days for $2,400 plus GST - Use Coupon Code:  CHANDOO_2018 at checkout.