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.