View Basket “Power BI for the Business Analyst – Sydney Nov 2017” has been added to your basket.
Bris_Nov_17

Power BI for the Business Analyst – Brisbane Nov 2017

AUD $1,644.50 Inc. GST

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.

The course will be held on 20th & 21st Nov 2017.  The training course will be delivered by Matt Allington who is a Microsoft MVP and author of the book “Learn to Write DAX”.

Early Bird Special

Save 10% when you register and pay before 20th Oct .

Training Course Location

Training will be located in the CBD. Exact location will be confirmed with participants the week prior to the course and will depend on the number of participants.

Things you need to know

DOWNLOAD COURSE BROCHURE:  Power BI Course Outline

The training will commence at 9am and finish at 5pm each day.  You will bring your own* laptop with Excel, Power Pivot and Power Query installed – this will be confirmed in a logistics email the week prior to the course training date.  *If you do not have a laptop, please contact Matt – there is a small number of free loan equipment available if you are not able to bring a laptop with you.   The course is normally taught on Excel 2013 however the learning is applicable for Excel 2010, Excel 2016 and Power BI.

Cancellations will be accepted 7 business days prior to the course start date.  After that time no refunds will be issued.  If you are unable to attend for any reason at short notice (ie with less than 7 day’s notice), you can send a proxy to attend the course in your place with prior agreement. The training course may be rescheduled or cancelled if insufficient registrations are received up until 7 days prior to the course date.  In this event a suitable arrangement will be made to either refund the course fee in full, or reschedule to another session at the choice of the student.  The objective is always to make you happy.

Bulk Discounts

Bulk discounts are available when you register and pay for 3 or more people at the same time.

  • Register and pay for 3 people, get 10% discount on total amount
  • Register and pay for 6 people, get 20% discount on total amount

For custom on-site training, please contact Matt directly to discuss your needs.

Product Description

Course Overview

Power BI

Microsoft is investing multiple millions of dollars developing products like Power BI, Power Pivot for Excel and Power Query for Excel.  This is driving high interest in the Excel Power User community because real business data experts can now deliver enterprise quality reporting and analytics from their own PC.   The good news is that the most useful capabilities in Power BI, Power Pivot and Power Query are conveniently the most learnable, but you will indeed need to learn them. In this two-day training, Matt Allington (Microsoft MVP and author of the book “Learn to Write DAX”) delivers a targeted training course that teaches you exactly what you need to know to get you on your personal BI journey.  Matt brings his 25 years of Commercial, Sales and IT experience plus his deep knowledge of these technologies to make this training tangible, practical and usable. This learning in this course will cover:

  • Accessing your data from wherever it is stored, and efficiently load it to your new BI tools
  • The basics of data modelling and how it is different to Excel.
  • Deep coverage of the fundamentals of the DAX language (Data Analysis Expressions).  You need to learn this if you want to get anywhere, but you can do it.
  • An introduction to some of the more powerful DAX functions, with explanations of how they work – you really need someone to explain these clearly, and that is what you get.
  • Introduction to Power Query, and hands on learning of several reusable patterns that cover common use cases for loading ad hoc data.
  • Introduction to Power BI, including how to leverage all the skills covered above from within Power BI, plus coverage of what is different from Excel so that you can get started immediately.

All participants will receive a free copy of the book “Learn to Write DAX”.  With this book you can continue your learning after the live training using the same familiar learning style covered in the course.

learn to write DAX large

Reviews

There are no reviews yet.

Be the first to review “Power BI for the Business Analyst – Brisbane Nov 2017”

Your email address will not be published. Required fields are marked *