Power BI for the Business Analyst

Best In Class Power BI, Power Pivot and Power Query Training

Power PivotPower BI Power Query Modern Excel

This live public training course is also available as private, onsite corporate training.  If you prefer to learn online, then take a look at my online training here.

Why this Course is Different/Better

Not all Power BI, Power Pivot and Power Query training is created equal.  This training course was developed and is taught by Matt Allington who is a career Excel Professional and Microsoft MVP specialising in the Microsoft Self Service BI Products.  The course focuses on teaching analysts how to model data using Power Pivot.  Power Pivot is the core technology that makes all the analytical power of Power BI possible.  Unlike some other learning resources, this course dives deep into the details of Power Pivot teaching you everything you really need to know to be good using all of these tools.

The term “Data Modelling” is not something that is familiar to most Excel Pros, and that is because data modelling has historically been done by IT on your behalf.  But if you want to be good with Self Service BI using the Microsoft tools, you must learn how to become a data modeller using Power Pivot – this is exactly what you will learn in this class.   Although the concepts are difficult to pick up via self learning, the expert approach from this live training course makes it accessible to any Excel Pro.  At the end of the 2 days you will be well on you way to becoming a Power BI, Power Pivot and Power Query ninja.

Course Overview

In this two-day training course, Matt Allington (author of the book “Learn to Write DAX“) teaches Excel professionals how to use Power Pivot, Power Query and Power BI from the point of view of a business analyst.  You don’t need to be a database expert to benefit from Power Pivot, but you do need to learn some new techniques to ensure you will succeed.   The course is for people that want to learn the skills to be able to build their own data models and analytics tools using their own data.  It is not designed for people that want to interact with Power BI reports that were created by someone else.

The course covers:

  1. Importing and creating relationships between your tables of data.
  2. Understanding the optimal data structure to use in Power Pivot.
  3. Writing basic Data Analysis eXpressions (DAX) formulas to extract business insights.
  4. Then writing more advanced DAX formulas that use the power of DAX to extract additional business insights from the data that are not immediately obvious (yet are inherently available).
  5. An introduction and overview of Power Query, how to use the tool and why it is so great.
  6. Helping Excel professionals move from being a Power Pivot for Excel user to being a Power BI user, covering the differences between the tools and how to start using Power BI effectively.

Download the Course Brochure: Power BI for the Business Analyst Course Outline

Course Locations and Dates

The 2017/18 Power Pivot Training dates for Australia can be seen in the table below. There is an early bird special if you book and pay 1 month in advance. Training will be located at a suitable central location in your capital city (depending on numbers).

Locations Dates Registration
  • Thurs 22nd & Fri 23rd Feb 2018
  • Thurs 5th & Fri 6th April 2018
  • Thurs 31st May & Fri 1st Jun 2018
  • Thurs 26th & Fri 27th Jul 2018
  • Thurs 20th & Fri 21st Sept 2018
  • Thurs 15th & Fri 16th Nov 2018
Click For More Information
  • Mon 5th & Tues 6th Feb 2018
  • Mon 19th & Tues 20th Mar 2018
  • Mon 21st & Tues 22nd May 2018
  • Mon 16th & Tues 17th Jul 2018
  • Mon 10th & Tues 11th Sept 2018
  • Mon 12th & Tues 13th Nov 2018
Click For More Information
  • Mon 20th & Tues 21st Nov 2017 – Sold Out
  • Mon 26th & Tues 27th Feb 2018
  • Mon 23rd & Tues 24th Apr 2018
  • Mon 4th & Tues 5th Jun 2018
  • Mon 30th & Tues 31st Jul 2018
  • Mon 24th & Tues 25th Sept 2018
  • Mon 26th & Tues 27th Nov 2018
Click For More Information
  • Thurs 23rd & Fri 24th Nov 2017 – Sold Out
  • Thurs 1st & Fri 2nd Feb 2018
  • Thurs 22nd & Fri 23rd Mar 2018
  • Thurs 17th & Fri 18th May 2018
  • Thurs 12th & Fri 13th Jul 2018
  • Thurs 6th & Fri 7th Sept 2018
  • Thurs 1st & Fri 2nd Nov 2018
  • Thurs 13th & Fri 14th Dec 2018
Click For More Information
Online There aren’t any Public Training events near you? You may be interested in an Online Training Course available in your time-zone:

  • AU & NZ
  • USA
  • Euro
Click for Online Options

Ten Things I Wish I Knew When I Started With Power Pivot.   Learn  Without The Pain!