Excel BI Tools: DAX Formulas for Dynamic Tables - Locus IT Services

Excel BI Tools: DAX Formulas for Dynamic Tables

Locus IT ServicesExcel BI Tools: DAX Formulas for Dynamic Tables
0 student

Overview
This course is for individuals responsible for taking data and turning it into powerful reports. With DAX you can create reusable formulas the allow you to rapidly iterate and answer questions across multiple data tables and across different sources for complex reporting requirement.

This course covers essential information needed for DAX-related reporting requirements. Specifically, it leverages the DAX language, teaching how to build models that extend the capabilities Power BI, Excel, or SQL Server Analysis Services. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with time intelligence calculations.

Audience
This course is aimed at Excel power-users, Power BI users who have a need to create dynamic reports that are based on the Excel / Power BI Data Model. Our Essential Data Preparation Skills for Data Mining course is a great complement to this class and is also designed for users of Excel, Power BI or SQL Server. For details on this companion course, go to
Essential Data Preparation Skills for Data Mining Using Power Query and M

Prerequisites
While attendees do not need extensive prior experience with DAX formulas, it is recommended that they have taken either our “Analyzing Data with Power BI” or “Excel BI Tools” class or have similar experience.

Instructor

Pavana

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
Free
Locus IT Project Management Office
What’s it?