Maxtrain.com - [email protected] - 513-322-8888 - 866-595-6863
This 2-day course Power BI for Excel 2019/2016 Part 3 DAX Functions is the third course in our Power BI using Excel series and is for Excel Designers who will be responsible for taking basic PowerPivot data models and turning them into power business intelligence solutions.
This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations, creating advanced DAX dashboards and report elements using Slicers.
DAX stands for Data Analysis Expressions, and is the formula language used throughout Power BI (it’s also used by Power BI behind the scenes). DAX is also found in other offerings from Microsoft, such as Power Pivot and SSAS Tabular.
DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in your model.
It’s easy to create a new Power BI Desktop file and import some data into it. You can even create reports that show valuable insights without using any DAX formulas at all. But, what if you need to analyze growth percentage across product categories and for different date ranges? Or, you need to calculate year-over-year growth compared to market trends? DAX formulas provide this capability and many other important capabilities as well. Learning how to create effective DAX formulas will help you get the most out of your data. When you get the information you need, you can begin to solve real business problems that affect your bottom line. This is the power of Power BI, and DAX will help you get there.
Excel Levels 1, 2 and 3 including PivotTable and Pivot Chart skills plus a basic understanding of database concepts. Power BI for Excel Part 2 Data Model Designer or equivalent skillset is also recommended.
2 Days Course