Best In Class Power BI, Power Pivot and Power Query Training
This live public training course is also available as private, onsite corporate training.
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 you the foundation of Power Pivot as Power Pivot is the core product that makes all the difference. 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.
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 covers:
- Importing and creating relationships between your tables of data.
- Understanding the optimal data structure to use in Power Pivot.
- Writing basic Data Analysis eXpressions (DAX) formulas to extract business insights.
- 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).
- An introduction and overview of Power Query, how to use the tool and why it is so great.
- 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 Pivot Australia Course Outline