Sorry, registration has ended.

Faculty: Mike Thomas ‎ ‎‎ ‎ ‎ |‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ Code: IT3026


  • Date:6/8/2023 11:00 - 6/8/2023 12:30
  • Location Online Event

Description

This webinar introduces you to the DAX formula and function language that is part of Power Pivot in Excel. You will learn how to access DAX, understand its syntax and create calculated columns and Measures (a special type of DAX formula)

We hear a lot about the benefits of storing your list-based data in Excel's Data Model instead of in worksheet cells. Most of those benefits revolve around how much data you can store, how much space you can save and how much easier it is to create Pivot Tables from multiple data sources.

But dive a little deeper and you'll find a whole magical world of DAX, Measures and CUBE functions which will help you to take your reporting and data analysis skills to the next level. This really is where the Power of Power Pivot comes in. Think of DAX as Excel formulas on steroids. Without it, you are using a fraction of the capabilities of Power Pivot.

OBJECTIVES:

In this training, you will learn, using practical examples, how Power Pivot provides Business Intelligence and reporting functionality within the familiar environment of Excel to provide you with better business insights and enable you to make more informed business decisions.

Who Should Attend:

If you want to take your reporting capabilities to the next level by learning how to leverage the functionality of DAX formulas, this is a must-attend training session!

Areas Covered in the Session:

  • Introduction to DAX (the Power Pivot formula language)
  • Manipulating text with a Calculated Column
  • Performing a Lookup with DAX
  • Working with dates in 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


IMPORTANT NOTE: Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department or see this link: https://support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b

Who Should Attend:

This training is aimed at users who are familiar with the basics of Power Pivot and The Data Model and who wish to take their knowledge and learning to the next stage.



Speaker Bio: Mike Thomas  

Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac.

In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials.

He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds 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.