-
1.Presentation of Mastering DAX 2nd Edition
1-
1.1Presentation of Mastering DAX 2nd Edition 06 minLecture1.1
-
-
2.Exercises, labs, slides, and demos
6-
2.1 Exercises, labs, slides, and demosLecture2.1
-
2.2 How to download and complete exercisesLecture2.2
-
2.3 Download exercisesLecture2.3
-
2.4 Download demosLecture2.4
-
2.5 Slides of the video courseLecture2.5
-
2.6 DiscussionLecture2.6
-
-
3.Introduction to DAX
19-
3.1 Introduction to DAX 05 minLecture3.1
-
3.2 What is DAX?Lecture3.2
-
3.3 DAX data types 12 minLecture3.3
-
3.4 Calculated columns 19 minLecture3.4
-
3.5 Measures 22 minLecture3.5
-
3.6 Aggregation functions 12 minLecture3.6
-
3.7 Counting values 04 minLecture3.7
-
3.8 Conditional functions 09 minLecture3.8
-
3.9 Handling errors 04 minLecture3.9
-
3.10 Using variables 08 minLecture3.10
-
3.11 Mathematical functions 04 minLecture3.11
-
3.12 Relational functions 13 minLecture3.12
-
3.13 ExercisesLecture3.13
-
3.13.1 Average sales per customerLecture3.14
-
3.13.2 Average delivery timeLecture3.15
-
3.13.3 Last update of customerLecture3.16
-
3.13.4 Working daysLecture3.17
-
3.13.5 Discount categoriesLecture3.18
-
3.14 DiscussionLecture3.19
-
-
4.Table functions
18-
4.1 Table functions 02 minLecture4.1
-
4.2 Introduction to table functionsLecture4.2
-
4.3 Filtering a table 06 minLecture4.3
-
4.4 Ignoring filters 11 minLecture4.4
-
4.5 Mixing filters 03 minLecture4.5
-
4.6 Distinct 05 minLecture4.6
-
4.7 How many values for a columnLecture4.7
-
4.8 ALLSELECTED 07 minLecture4.8
-
4.9 RELATEDTABLE 06 minLecture4.9
-
4.10 Tables and relationships 04 minLecture4.10
-
4.11 Tables with one row and one column 16 minLecture4.11
-
4.12 Table variables 02 minLecture4.12
-
4.13 ExercisesLecture4.13
-
4.13.1 Percentage of salesLecture4.14
-
4.13.2 Delivery working daysLecture4.15
-
4.13.3 Sales of products in the first weekLecture4.16
-
4.13.4 Customers with childrenLecture4.17
-
4.14 DiscussionLecture4.18
-
-
5.Evaluation contexts
15-
5.1 Evaluation contexts 01 minLecture5.1
-
5.2 Introduction to evaluation contextsLecture5.2
-
5.3 Filter contextLecture5.3
-
5.4 Row context 06 minLecture5.4
-
5.5 Context errors 04 minLecture5.5
-
5.6 Filtering a table 06 minLecture5.6
-
5.7 Using RELATED in a row context 04 minLecture5.7
-
5.8 Ranking by price 14 minLecture5.8
-
5.9 Evaluation contexts and relationships 07 minLecture5.9
-
5.10 Filters and relationships 08 minLecture5.10
-
5.11 ExercisesLecture5.11
-
5.11.1 Nested iteratorsLecture5.12
-
5.11.2 Customers in North AmericaLecture5.13
-
5.11.3 Create a parameter tableLecture5.14
-
5.12 DiscussionLecture5.15
-
-
6.The CALCULATE function
15-
6.1 The CALCULATE functionLecture6.1
-
6.2 CALCULATE 06 minLecture6.2
-
6.3 CALCULATE examples 27 minLecture6.3
-
6.4 CALCULATE recap 06 minLecture6.4
-
6.5 What is a filter context? 08 minLecture6.5
-
6.6 KEEPFILTERS 03 minLecture6.6
-
6.7 CALCULATE operators 02 minLecture6.7
-
6.8 Use one column only in compact syntax 16 minLecture6.8
-
6.9 Variables and evaluation contextsLecture6.9
-
6.10 ExercisesLecture6.10
-
6.10.1 Sales of red and blue productsLecture6.11
-
6.10.2 Understanding CALCULATELecture6.12
-
6.10.3 Sales of blue productsLecture6.13
-
6.10.4 Computing percentagesLecture6.14
-
6.11 DiscussionLecture6.15
-
-
7.Advanced evaluation contexts
19-
7.1 Advanced evaluation contexts 02 minLecture7.1
-
7.2 CALCULATE modifiersLecture7.2
-
7.3 USERELATIONSHIP 04 minLecture7.3
-
7.4 CROSSFILTER 03 minLecture7.4
-
7.5 ALL 03 minLecture7.5
-
7.6 ALLSELECTED 04 minLecture7.6
-
7.7 KEEPFILTERS 03 minLecture7.7
-
7.8 Context transition 12 minLecture7.8
-
7.9 Context transition /2 15 minLecture7.9
-
7.10 Circular dependency 09 minLecture7.10
-
7.11 CALCULATE execution order 07 minLecture7.11
-
7.12 ExercisesLecture7.12
-
7.12.1 Correct sales of grey productsLecture7.13
-
7.12.2 Best customersLecture7.14
-
7.12.3 Customers buying many productsLecture7.15
-
7.12.4 Large salesLecture7.16
-
7.12.5 Percentage of customersLecture7.17
-
7.12.6 Counting spikesLecture7.18
-
7.13 DiscussionLecture7.19
-
-
8.Iterators
12-
8.1 IteratorsLecture8.1
-
8.2 Working with iterators 12 minLecture8.2
-
8.3 MINX and MAXX 04 minLecture8.3
-
8.4 Useful iterators 10 minLecture8.4
-
8.5 RANKX 09 minLecture8.5
-
8.6 ISINSCOPE 08 minLecture8.6
-
8.7 ExercisesLecture8.7
-
8.7.1 Ranking customers (static)Lecture8.8
-
8.7.2 Ranking customers (dynamic)Lecture8.9
-
8.7.3 Date with the highest salesLecture8.10
-
8.7.4 Moving averageLecture8.11
-
8.8 DiscussionLecture8.12
-
-
9.Building a date table
7-
9.1 Building a date table 04 minLecture9.1
-
9.2 Introduction to date tableLecture9.2
-
9.3 Auto Date/Time 08 minLecture9.3
-
9.4 CALENDARAUTO 10 minLecture9.4
-
9.5 Mark as date table 06 minLecture9.5
-
9.6 Using multiple dates 12 minLecture9.6
-
9.7 DiscussionLecture9.7
-
-
10.Time intelligence in DAX
15-
10.1 Time intelligence in DAX 02 minLecture10.1
-
10.2 What is time intelligence?Lecture10.2
-
10.3 Time intelligence functionsLecture10.3
-
10.4 DATEADD 13 minLecture10.4
-
10.5 DATESINPERIODLecture10.5
-
10.6 Running total 04 minLecture10.6
-
10.7 Mixing time intelligence functions 07 minLecture10.7
-
10.8 Semi-additive measures 18 minLecture10.8
-
10.9 Calculations over weeks 18 minLecture10.9
-
10.10 ExercisesLecture10.10
-
10.10.1 Running totalLecture10.11
-
10.10.2 Comparison YOY%Lecture10.12
-
10.10.3 Sales in first three monthsLecture10.13
-
10.10.4 Semi-additive calculationsLecture10.14
-
10.11 DiscussionLecture10.15
-
-
11.Hierarchies in DAX
6-
11.1 Hierarchies in DAX 05 minLecture11.1
-
11.2 What are hierarchies?Lecture11.2
-
11.3 FILTER and CROSSFILTER 06 minLecture11.3
-
11.4 Percentages over hierarchies 09 minLecture11.4
-
11.5 Parent-child hierarchiesLecture11.5
-
11.6 DiscussionLecture11.6
-
-
12.Querying with DAX
21-
12.1 Querying with DAXLecture12.1
-
12.2 Working with tables and queries 11 minLecture12.2
-
12.3 EVALUATE 05 minLecture12.3
-
12.4 CALCULATETABLE 16 minLecture12.4
-
12.5 SELECTCOLUMNS 10 minLecture12.5
-
12.6 SUMMARIZE 07 minLecture12.6
-
12.7 SUMMARIZECOLUMNS 07 minLecture12.7
-
12.8 CROSSJOIN 07 minLecture12.8
-
12.9 TOPN and GENERATE 09 minLecture12.9
-
12.10 ROW and DATATABLE 08 minLecture12.10
-
12.11 Tables and relationships 07 minLecture12.11
-
12.12 UNION, INTERSECT, and EXCEPT 16 minLecture12.12
-
12.13 GROUPBY 08 minLecture12.13
-
12.14 Query measures 14 minLecture12.14
-
12.15 ExercisesLecture12.15
-
12.15.1 Sales by yearLecture12.16
-
12.15.2 Filtering and grouping salesLecture12.17
-
12.15.3 Using TOPN and GENERATELecture12.18
-
12.15.4 Sales to top customersLecture12.19
-
12.15.5 Sales of top three colorsLecture12.20
-
12.16 DiscussionLecture12.21
-
-
13.Data lineage and TREATAS
4-
13.1 Data lineage and TREATAS 08 minLecture13.1
-
13.2 What is data lineage?Lecture13.2
-
13.3 TREATAS 06 minLecture13.3
-
13.4 DiscussionLecture13.4
-
-
14.Expanded tables
8-
14.1 Expanded tables 06 minLecture14.1
-
14.2 Filters are tablesLecture14.2
-
14.3 Difference between base tables and expanded tablesLecture14.3
-
14.4 Filtering a columnLecture14.4
-
14.5 ExercisesLecture14.5
-
14.5.1 Distinct count of countriesLecture14.6
-
14.5.2 Sales quantity greater than twoLecture14.7
-
14.6 DiscussionLecture14.8
-
-
15.Arbitrarily shaped filters
4-
15.1 Arbitrarily shaped filters 05 minLecture15.1
-
15.2 What are arbitrarily shaped filters?Lecture15.2
-
15.3 Example of an arbitrarily shaped filterLecture15.3
-
15.4 DiscussionLecture15.4
-
-
16.ALLSELECTED and shadow filter contexts
4-
16.1 ALLSELECTED and shadow filter contexts 06 minLecture16.1
-
16.2 ALLSELECTEDLecture16.2
-
16.3 Shadow filter contexts 12 minLecture16.3
-
16.4 DiscussionLecture16.4
-
-
17.Segmentation
7-
17.1 SegmentationLecture17.1
-
17.2 Static segmentation 14 minLecture17.2
-
17.3 Circular dependency in calculated tablesLecture17.3
-
17.4 Dynamic segmentation 15 minLecture17.4
-
17.5 ExercisesLecture17.5
-
17.5.1 Static segmentationLecture17.6
-
17.6 DiscussionLecture17.7
-
-
18.Many-to-many relationships
8-
18.1 Many-to-many relationships 12 minLecture18.1
-
18.2 How to handle many-to-many relationshipsLecture18.2
-
18.3 Bidirectional filtering 12 minLecture18.3
-
18.4 Expanded table filtering 09 minLecture18.4
-
18.5 Comparison of the different techniques 04 minLecture18.5
-
18.6 ExercisesLecture18.6
-
18.6.1 Many-to-many relationshipsLecture18.7
-
18.7 DiscussionLecture18.8
-
-
19.Ambiguity and bidirectional filters
3-
19.1 Ambiguity and bidirectional filters 16 minLecture19.1
-
19.2 Understanding ambiguityLecture19.2
-
19.3 DiscussionLecture19.3
-
-
20.Relationships at different granularities
9-
20.1 Relationships at different granularitiesLecture20.1
-
20.2 Working at different granularity 07 minLecture20.2
-
20.3 Using TREATAS 12 minLecture20.3
-
20.4 Calculated tables to slice dimensions 19 minLecture20.4
-
20.5 Leveraging weak relationships 15 minLecture20.5
-
20.6 Scenario recap 07 minLecture20.6
-
20.7 Checking granularity in the report 14 minLecture20.7
-
20.8 Hiding or reallocating 10 minLecture20.8
-
20.9 DiscussionLecture20.9
-
-
21.Additional exercises
5-
21.1 ExercisesLecture21.1
-
21.1.1 Same product salesLecture21.2
-
21.1.2 Commentary on reportLecture21.3
-
21.1.3 New customersLecture21.4
-
21.2 DiscussionLecture21.5
-
-
22.Calculation groups
21-
22.1 Calculation groups 02 minLecture22.1
-
22.2 Introducing calculation groupsLecture22.2
-
22.3 Basic measures 06 minLecture22.3
-
22.4 Calculation items are patterns 06 minLecture22.4
-
22.5 Creating calculation groups 15 minLecture22.5
-
22.6 Changing the format string 11 minLecture22.6
-
22.7 Excluding specific measures 08 minLecture22.7
-
22.8 Using calculation items in DAX 05 minLecture22.8
-
22.9 Calculation item application 10 minLecture22.9
-
22.10 Calculation items on complex expressions 07 minLecture22.10
-
22.11 Multiple calculation groups in a report 08 minLecture22.11
-
22.12 Understanding precedence in calculation groups 07 minLecture22.12
-
22.13 Reusing calculation items 04 minLecture22.13
-
22.14 Recursion and best practices 05 minLecture22.14
-
22.15 ExercisesLecture22.15
-
22.15.1 Time calculationsLecture22.16
-
22.15.2 Multiple calculation groupsLecture22.17
-
22.15.3 Sold versus deliveredLecture22.18
-
22.15.4 Min, Max and Avg calculation groupLecture22.19
-
22.15.5 Top and bottom productsLecture22.20
-
22.16 DiscussionLecture22.21
-
This content is protected, please login and enroll course to view this content!
Next
3.13 Exercises