WebNLearn: From Raw Data to Actionable Insights. Intro to Power Pivot & DAXs (3 of 3)
What You'll Learn
Key takeaways from this session
Introduction to DAX (the Power Pivot formula language)
Performing a Lookup with DAX
DAX Calculated Columns v Query Editor Calculated Columns
Introduction to Measures
The all-important Calculate function
CUBE functions – letting the worksheet talk to The Data Model
Earn PDU Credits
PMI Professional Development Units
About the Presenter
TheExcelTrainer
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.



