About this Masterclass:
The classic Excel PivotTable did a great job of letting us quickly pivot and slice data for years. There was a ton of logic built into the tool in order to make it easy for end users, but that ease of use had a cost: it didn’t scale to multiple data source tables. And worse, it actually kept you from learning the terms to scale your own knowledge.
At the core of every good Power Pivot or Power BI solution is the Data Model. But do you really know how to work with it properly? What shape your tables should have? When you should split tables up, when you should flatten them, and how to manipulate the data on the fly to do so?
This is an exciting course, as it pairs two of Excel’s most powerful features (Power Query and Power Pivot) together in one place, using each for what they were designed to do. You’ll leave armed with not only the experience, but handy reference cards to apply these techniques to your own data, and to determine “Is this a Power Query job, or a DAX job?”
About your Instructor:
Ken Puls, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Ken is a blogger, software developer, author and trainer with over 20 years of corporate accounting and IT experience. He is one of the world’s leading experts in Microsoft Excel, Power Query and Power BI, and provides live and online training to clients around the world. In recognition of his contributions, Ken has held the prestigious Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories. Full profile >>
This is a hybrid instructor-led/online Masterclass. In order to practice the material, participants should have a computer running one of the following:
➤ Excel 2013 Professional Plus or Excel 2013 ProPlus with the free Power Query add-in installed
➤ Excel 2016 or higher
➤ Excel 365
At a minimum, participants must have experience using PivotTables. Exposure to Power Pivot is an asset, but not required.
➤ Payment options: You can pay be debit/credit card by simply adding this Masterclass to your cart. Alternatively, payment by invoice, purchase order or bank transfer is also available. Contact us for further details.
➤ Available discounts: DATEL Productions subscribers get 10% OFF. Please contact us if you are a student, senior over 60, charity/NHS worker or if you come from an emerging market. We will send a discount code directly to your inbox. T&Cs apply.