Power Pivot and DAX – Advanced Microsoft Excel

Data modelling and reporting at its best

While you can create data models and groups of tables that are related to one another, Power Pivot gives you more options to analyze and create data models and presentations that are more sophisticated. Power Pivot enables you to take massive volumes of data from different sources, analyze the information quickly, and then process it and offer insights. it is a powerful data analysis tool that does not have a number of the restrictions that Excel does and eliminates the need to use complicated formulas like VLookUp and HLookUp. It can store millions of records of data, easily create relationships between different tables of data and introduces the DAX formula language, which is broadly based on the Excel formulas you already know. Once data is loaded into Power Pivot, you can use Pivot Tables and Charts to analyze the data, just as you would using standard Excel. When you start using DAX (Data Analysis Expressions) in PowerPivot, you will quickly see the similarities it shares with standard Excel formulas.

What you’ll learn

  • How to import large data sets from almost any source..
  • Create data relationships to get rid of LOOKUPs and MATCH and INDEX..
  • Create calculated columns and measures..
  • Use Time Intelligence functions to create complex analysis in minutes..
  • Build fully interactive and bespoke report and dashboards..

Course Content

  • Introduction –> 3 lectures • 34min.
  • Calculated Columns vs DAX Measures –> 3 lectures • 31min.
  • Time Intelligence in PowerPivot –> 8 lectures • 2hr 46min.
  • Conditional Measures –> 1 lecture • 15min.
  • Iterator Functions –> 1 lecture • 29min.
  • Multiple Data Tables –> 1 lecture • 19min.

Auto Draft

Requirements

  • Working knowledge of Microsoft Excel..

While you can create data models and groups of tables that are related to one another, Power Pivot gives you more options to analyze and create data models and presentations that are more sophisticated. Power Pivot enables you to take massive volumes of data from different sources, analyze the information quickly, and then process it and offer insights. it is a powerful data analysis tool that does not have a number of the restrictions that Excel does and eliminates the need to use complicated formulas like VLookUp and HLookUp. It can store millions of records of data, easily create relationships between different tables of data and introduces the DAX formula language, which is broadly based on the Excel formulas you already know. Once data is loaded into Power Pivot, you can use Pivot Tables and Charts to analyze the data, just as you would using standard Excel. When you start using DAX (Data Analysis Expressions) in PowerPivot, you will quickly see the similarities it shares with standard Excel formulas.

What makes learning DAX so worth, it is partially due to the use of the DAX language across a few of the programs by Microsoft. DAX is commonly used by users in Power BI, Analysis Services and Power Pivot in Excel.

DAX comprises of functions, operators, and constants that can be put into the form of formulae to calculate values with the help of data already present in your model.

Get Tutorial