learn.sqlbi.comHow to learn DAX - SQLBI

Menu All Courses SQLBI.com Sign In Video Course by Marco Russo & Alberto Ferrari Watch Intro Video Free Preview Buy $349.00 136 Videos 13 Texts 3 PDFs 13 Disqus 12 Downloads 18.0 hrs Course Curriculum Presentation of 02:29 Presentation of FREE PREVIEW Hide Content Exercise, labs, slides, and demos How to download and complete exercises FREE PREVIEW Download demos - Exercise book (Power Pivot for Excel) - Exercise book (Power BI) Download exercises (Power Pivot for Excel) Download exercises (Power BI) Slides of the video course Discussion Hide Content Introduction to DAX 61:15 Introduction to DAX FREE PREVIEW What is DAX? FREE PREVIEW DAX data types FREE PREVIEW Calculated columns FREE PREVIEW Measures FREE PREVIEW Naming convention FREE PREVIEW Measures vs. calculated columns FREE PREVIEW Handling errors Aggregation functions Counting values Logical functions The SWITCH function Information functions MAX and MIN functions Mathematical functions DIVIDE function Using variables Rounding, text, and date functions Relational functions Lab number 1 Lab 01 First Steps with DAX Discussion Hide Content Table functions 32:24 Table functions FREE PREVIEW Introduction to table functions FREE PREVIEW FILTER function FREE PREVIEW ALL function FREE PREVIEW ALLEXCEPT function FREE PREVIEW Mixing filters DISTINCT function VALUES and ALLNOBLANKROW functions ISEMPTY function RELATEDTABLE function Tables and relationships Calculated tables Lab number 2 Lab 02 Table Functions Discussion Hide Content Evaluation contexts 42:54 Evaluation contexts FREE PREVIEW Introduction to evaluation contexts Filter context Row context There are always two contexts Context errors Working with evaluation contexts EARLIER in nested row contexts EARLIER and variables Discussion Hide Content CALCULATE function 33:12 CALCULATE function FREE PREVIEW Introduction to CALCULATE CALCULATE examples Filter are tables OR conditions in CALCULATE Clear filter on one column only CALCULATE tasks Example: ratios and percentages Variables and evaluation contexts Discussion Hide Content Evaluation contexts and relationships 69:06 Evaluation contexts and relationships FREE PREVIEW Introduction to evaluation contexts and relationships Row context and relationships Filter context and relationships CALCULATE examples Filtering many columns Filter arguments in CALCULATE FILTER and CROSSFILTER functions HASONEVALUE function ALLSELECTED function Context transition Automatic CALCULATE in measures Equivalent filter context Circular dependency Conclusions about relationships Lab number 3 Lab 03 Evaluation Contexts Discussion Hide Content Building a Date table 19:32 Building a Date table FREE PREVIEW Introduction CALENDAR function CALENDARAUTO function Mark as Date table Set sorting options Multiple dates Discussion Hide Content Working with iterators 36:41 Working with iterators FREE PREVIEW Introduction to iterators Example: daily average Useful iterators MIN-MAX sales per customer Statistical and financial functions RANKX function and examples RANKX recap and details Lab number 4 Lab 04 Iterators Discussion Hide Content Time intelligence in DAX 56:36 Time intelligence in DAX FREE PREVIEW Introduction to time intelligence FREE PREVIEW Aggregations over time FREE PREVIEW Year to date functions Previous year and DATEADD functions Example: previous year calculation PARALLELPERIOD function Running total Moving annual total Semi additive measures Calculations over weeks Time intelligence conclusions Lab number 5 Lab 05 Time Intelligence Discussion Hide Content Querying with DAX 69:53 Querying with DAX FREE PREVIEW Introduction DAX Studio EVALUATE syntax FILTER and CALCULATETABLE functions SUMMARIZE and SELECTCOLUMNS functions CROSSJOIN function GENERATE function Tables, relationships, and data lineage ROW, LOOKUPVALUE, and CONTAINS functions TOPN function UNION, INTERSECT, and EXCEPT functions SUMMARIZECOLUMN and GROUPBY functions Query measures Parameters in queries DAX measures in MDX queries Querying in DAX - conclusions Lab number 6 Lab 06 Querying DAX Discussion Hide Content Advanced filter context 83:01 Advanced filter context FREE PREVIEW Introduction to advanced filter context FREE PREVIEW Filter propagation and strange results FREE PREVIEW Key topics FREE PREVIEW Base tables and expanded tables FREE PREVIEW Context propagation Filter is on columns, not tables Example: compute a simple percentage First recap of filter context Definition of a filter context Filter context operators Example: filter context puzzle KEEPFILTER function Dangers of SUMMARIZE Recap of advanced filter context Inside ALLSELECTED Lab number 7 Lab 07 Advanced Filter Context Discussion Hide Content Hierarchies in DAX 28:16 Hierarchies in DAX FREE PREVIEW Introduction to hierarchies Parent-child hierarchies Hiding levels in parent-child hierarchies Parent-child hierarchies recap Lab number 8 Lab 08 Hierarchies Discussion Hide Content Advanced relationships 74:34 Advanced relationships FREE PREVIEW Introduction to advanced relationships Ambiguity in bidirectional filters USERELATIONSHIP function Multi-column relationships Static segmentation Dynamic segmentation Working at different granularity Many-to-many relationships New and returning customers Lab 09 Advanced Relationships Discussion Hide Content Course description This workshop is a complete course about the DAX language. DAX is the native language of Power Pivot for Excel, Power BI Desktop and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power Pivot for Excel, Power BI Desktop and at Analysis Services developers that want to learn and master the DAX language. The goal of the course is to teach all the features of DAX, providing the knowledge to write formulas for common and advanced business scenarios. Prerequisite : Attendees need to have a basic knowledge of the data modeling in Power Pivot for Excel, or Power BI Desktop, or Analysis Services Tabular modeling. Goals of the Training: Creating DAX expressions for measures and calculated columns Querying Tabular models and Power Pivot workbooks by using DAX Creating calculated tables in Power BI and Analysis Services Tabular models Creating advanced data models by leveraging on DAX features Practicing using exercises available in the workshop Read More Instructors Marco Russo & Alberto Ferrari Business Intelligence experts at SQLBI - SSAS Maestro & MVP Marco and Alberto are Business Intelligence consultants and mentors. They have been working with Analysis Services since 1999 and with Power Pivot since first beta versions in 2009. They split their time between consulting and teaching at SQLBI, delivering training all around the world, mostly in North America and Europe. They are speakers at international conferences such as Microsoft Ignite , Microsoft TechEd , PASS Summit , SQLRally , and SQLBits - see a complete list here . They are also book authors and wrote several books for Microsoft Press about Analysis Service, Power Pivot and DAX - including The Definitive Guide to DAX and Introducing Microsoft Power BI . Terms and conditions This course is hosted by Thinkific , so you can receive progress notification and other communications by noreply@thinkific.com on our behalf. Please, add this address to your contacts to avoid SPAM filtering. Don't worry, we will never give your data to third parties. This course will be accessible by desktop and mobile browsers for three years (36 months) after the purchase date . Reviews (17) practical course with technical problems by Marco Lurati Language: 4 out of 5 Clear and slow but with a very strong Italian accent; Content: 2 out of 5 The course goes directly into examples of functions but fails to introduce the basic principal of how DAX exactly computes. Coming from sql I would have appreciated more focus on the technical details and data modelling. Also, it seems like the course is out of date as it was published 3 years ago. An ...