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.