Sydney Live Training Sign Up - Excelerator BI

Sydney Live Training Sign Up

Power BI Training is a 2 day live training course by Matt Allington. This Power BI training course can be taken as a standalone 2-day course, or as two separate training courses.

  • 1 Day Data to Dashboard Using Power BI (6 CPD hours)
  • 1 Day Data Modelling with Power BI and Power Pivot (6 CPD hours)

1 Day Data to Dashboard Using Power BI

This one day course is the first day of the two day training and covers all you need to know to start using the Power BI suite of tools without expecting you to be a programmer. The topics include

  • How to use the new Power BI Desktop product.
  • In depth coverage of building Reports with various visualisations using Power BI Desktop.
  • Publishing Power BI Reports to Power BI.com for sharing.
  • Power BI.com features including Workspaces, Quick Insights, Q&A, etc.
  • Creating Dashboards in PowerBI.com.
  • Introduction to Power Query, and hands on learning of several reusable patterns that cover common use cases for loading ad hoc data.

1 Day Data Modelling with Power BI and Power Pivot

This one day course is the second day of the two day training and goes on to focus on teaching you how to model data.

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 – this is exactly what you will learn in this class.  The topics include

  • How to optimally load your data for use.
  • DAX (Data Analysis Expressions) language and Common DAX functions.
  • How to write DAX formulas using business logic that bring out data insights.
  • The CALCULATE function – the most important function in DAX.
  • Advanced concepts including table functions such as ALL, FILTER.
  • Time Intelligence.

At the end of the 2 days you will be well on you way to becoming a Power BI ninja.

All participants will receive the certificate of completion at the end of the course.

Participants registered for the 2nd day of training will receive a free copy of the book “Supercharge Power BI”. If instead you would prefer a copy of “Supercharge Excel”, please indicate this in the order instructions (see below). With these books you can continue your learning after the live training using the same familiar learning style covered in the course.

To register, please indicate the number of participants for the appropriate course below and then provide your payment details in the form provided.

Please Note:

New dates in 2020 will be announced shortly

Billing details

Additional information

Your order

Product
Quantity
Total
Cart Subtotal AUD $0.00
Order Total AUD $0.00
  • Pay with your credit card via Stripe.


Scroll to Top

Power Query can automate boring, repetitive tasks you do every day.  Watch free previews of my online training course to see how.