Business Intelligence Tools in Excel Master Class

A master class from the Financial Analysis Certificate Master Class series

An extension program for Australia’s premier Excel modelling and analysis course for finance professionals

This two-day master class focuses on advanced data analysis using the fast-evolving Business Intelligence (BI) tools in the most recent versions of Excel. Selecting between the available tools and using them appropriately, is a key need for staff faced with analysis complex or large data sets, this master class aims to assist in understanding this evolving area and demonstrate . It is open to past participants of the Financial Analysis Certificate that are looking for a forum in which to extend and practise the skills gained in their earlier training.

Course Content

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Modes of Study

  • In class mode: 16 hours over two days.
  • Public offerings starting in Sydney in 2016.
  • Private offerings also available.

Key Outcomes

  • Gain advanced skills in key subject areas, such as the use of Power Query, PowerPivot and Power View / 3D Maps;
  • Understanding the powerful features in Power Query for data acquisition and transformation;;
  • Introduction to the Power Query language (informally known as "M");
  • Understanding and working with the Data Model;
  • Using DAX to transform and summarise data;
  • Presenting results in Power View (2013) and 3D maps (2016); and
  • Up to 16 hours of continuing professional education.

Each Master Class Delivers

  • Core knowledge for the specialised subject area;
  • Re-usable examples demonstrating proven methodologies;
  • Guidance on how to avoid real-world issues and problems; and
  • Advanced techniques to extend the power of formulas without needless complexity.

Who Benefits

  • Those who have previously completed the Financial Analysis Certificate looking for support & guidance to extend their knowledge in building robust analytical processes that significantly reduce effort at key points in the reporting cycle and enable new insights into your data sets.

Benefits for the Employer

  • A reduction in the effort required by staff to expand into key advanced topics;
  • Access to proven and effective strategies for advanced model building; and
  • A development path for key staff involved in creation of key reports to management & the board.

Detailed Course Outline & Other Information

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Downloadable course brochure with detailed course outline in PDF format (97kb).

Find a suitable course by reviewing the article Which Course Would Best Suit me?

Find an offering in the Course Calendar.