2, if it is in order to learn big data and data predictive analytics, DAX must be learned
DAX: Data Analytics Expressions is a library of functions and operators that can be combined to generate formulas and expressions in Microsoft SQL Server Analysis Services, Power Pivot in Excel, and the Power BI Designer to generate formulas and expressions.