-
1. Presentation of Optimizing DAX
1-
1.1 Presentation of Optimizing DAXLecture1.1
-
-
2. Exercises, slides, and demos
4-
2.1 How to download and complete exercisesLecture2.1
-
2.2 Exercises downloadLecture2.2
-
2.3 Demos downloadLecture2.3
-
2.4 Slides of the video courseLecture2.4
-
-
3. VertiPaq storage engine
15-
3.1 VertiPaq storage engineLecture3.1
-
3.2 VertiPaq in-memory columnar databaseLecture3.2
-
3.3 What is VertiPaq?Lecture3.3
-
3.4 Run Length Encoding (RLE)Lecture3.4
-
3.5 VertiPaq compressionLecture3.5
-
3.6 SegmentationLecture3.6
-
3.7 Data memory usageLecture3.7
-
3.8 Materialization in DAXLecture3.8
-
3.9 Storage internalsLecture3.9
-
3.10 RelationshipsLecture3.10
-
3.11 Reduce dictionary sizeLecture3.11
-
3.12 Hands-on labsLecture3.12
-
3.13 Lab 1 – Exercise 1 – Understanding information about a modelLecture3.13
-
3.14 Lab 1 – Exercise 1 – SolutionLecture3.14
-
3.15 DiscussionLecture3.15
-
-
4. Measuring performance
16-
4.1 Measuring performanceLecture4.1
-
4.2 Tabular query architectureLecture4.2
-
4.3 Two enginesLecture4.3
-
4.4 SQL Server ProfilerLecture4.4
-
4.5 DAX StudioLecture4.5
-
4.6 Gathering countersLecture4.6
-
4.7 Understanding data cachesLecture4.7
-
4.8 xmSQL syntaxLecture4.8
-
4.9 FilterLecture4.9
-
4.10 Lab 2 – Exercise 1 – Simple groupingLecture4.10
-
4.11 Lab 2 – Exercise 1 – SolutionLecture4.11
-
4.12 Lab 2 – Exercise 2 – Simple filtersLecture4.12
-
4.13 Lab 2 – Exercise 2 – SolutionLecture4.13
-
4.14 Lab 2 – Exercise 3 – Basic time intelligenceLecture4.14
-
4.15 Lab 2 – Exercise 3 – SolutionLecture4.15
-
4.16 DiscussionLecture4.16
-
-
5. Analyzing query plans
17-
5.1 Analyzing query plansLecture5.1
-
5.2 SUMMARIZELecture5.2
-
5.3 ADDCOLUMNSLecture5.3
-
5.4 Multiple measuresLecture5.4
-
5.5 CacheLecture5.5
-
5.6 Storage engine featuresLecture5.6
-
5.7 CallbackDataIDLecture5.7
-
5.8 Measuring MDXLecture5.8
-
5.9 Lab 3 – Exercise 1 – High value countriesLecture5.9
-
5.10 Lab 3 – Exercise 1 – SolutionLecture5.10
-
5.11 Lab 3 – Exercise 2 – Sum of similar measuresLecture5.11
-
5.12 Lab 3 – Exercise 2 – SolutionLecture5.12
-
5.13 Lab 3 – Exercise 3 – Context transitionLecture5.13
-
5.14 Lab 3 – Exercise 3 – SolutionLecture5.14
-
5.15 Lab 3 – Exercise 4 – Counting invoicesLecture5.15
-
5.16 Lab 3 – Exercise 4 – SolutionLecture5.16
-
5.17 DiscussionLecture5.17
-
-
6. Optimizing large models
6-
6.1 Optimizing large modelsLecture6.1
-
6.2 How many rows do you have?Lecture6.2
-
6.3 SUM or SUMX?Lecture6.3
-
6.4 Optimizing degenerate dimensionsLecture6.4
-
6.5 Dimension bottlenecksLecture6.5
-
6.6 DiscussionLecture6.6
-
-
7. Measuring performance
16-
7.1 Measuring performanceLecture7.1
-
7.2 Tabular query architectureLecture7.2
-
7.3 Two enginesLecture7.3
-
7.4 SQL Server ProfilerLecture7.4
-
7.5 DAX StudioLecture7.5
-
7.6 Gathering countersLecture7.6
-
7.7 Understanding data cachesLecture7.7
-
7.8 xmSQL syntaxLecture7.8
-
7.9 FilterLecture7.9
-
7.10 Lab 2 – Exercise 1 – Simple groupingLecture7.10
-
7.11 Lab 2 – Exercise 1 – SolutionLecture7.11
-
7.12 Lab 2 – Exercise 2 – Simple filtersLecture7.12
-
7.13 Lab 2 – Exercise 2 – SolutionLecture7.13
-
7.14 Lab 2 – Exercise 3 – Basic time intelligenceLecture7.14
-
7.15 Lab 2 – Exercise 3 – SolutionLecture7.15
-
7.16 DiscussionLecture7.16
-
-
8. Analyzing query plans
17-
8.1 Analyzing query plansLecture8.1
-
8.2 SUMMARIZELecture8.2
-
8.3 ADDCOLUMNSLecture8.3
-
8.4 Multiple measuresLecture8.4
-
8.5 CacheLecture8.5
-
8.6 Storage engine featuresLecture8.6
-
8.7 CallbackDataIDLecture8.7
-
8.8 Measuring MDXLecture8.8
-
8.9 Lab 3 – Exercise 1 – High value countriesLecture8.9
-
8.10 Lab 3 – Exercise 1 – SolutionLecture8.10
-
8.11 Lab 3 – Exercise 2 – Sum of similar measuresLecture8.11
-
8.12 Lab 3 – Exercise 2 – SolutionLecture8.12
-
8.13 Lab 3 – Exercise 3 – Context transitionLecture8.13
-
8.14 Lab 3 – Exercise 3 – SolutionLecture8.14
-
8.15 Lab 3 – Exercise 4 – Counting invoicesLecture8.15
-
8.16 Lab 3 – Exercise 4 – SolutionLecture8.16
-
8.17 DiscussionLecture8.17
-
-
9. Optimizing large models
6-
9.1 Optimizing large modelsLecture9.1
-
9.2 How many rows do you have?Lecture9.2
-
9.3 SUM or SUMX?Lecture9.3
-
9.4 Optimizing degenerate dimensionsLecture9.4
-
9.5 Dimension bottlenecksLecture9.5
-
9.6 DiscussionLecture9.6
-
-
10. Analyzing query plans'
17-
10.1 Analyzing query plansLecture10.1
-
10.2 SUMMARIZELecture10.2
-
10.3 ADDCOLUMNSLecture10.3
-
10.4 Multiple measuresLecture10.4
-
10.5 CacheLecture10.5
-
10.6 Storage engine featuresLecture10.6
-
10.7 CallbackDataIDLecture10.7
-
10.8 Measuring MDXLecture10.8
-
10.9 Lab 3 – Exercise 1 – High value countriesLecture10.9
-
10.10 Lab 3 – Exercise 1 – SolutionLecture10.10
-
10.11 Lab 3 – Exercise 2 – Sum of similar measuresLecture10.11
-
10.12 Lab 3 – Exercise 2 – SolutionLecture10.12
-
10.13 Lab 3 – Exercise 3 – Context transitionLecture10.13
-
10.14 Lab 3 – Exercise 3 – SolutionLecture10.14
-
10.15 Lab 3 – Exercise 4 – Counting invoicesLecture10.15
-
10.16 Lab 3 – Exercise 4 – SolutionLecture10.16
-
10.17 DiscussionLecture10.17
-
-
11. Optimizing large models
6-
11.1 Optimizing large modelsLecture11.1
-
11.2 How many rows do you have?Lecture11.2
-
11.3 SUM or SUMX?Lecture11.3
-
11.4 Optimizing degenerate dimensionsLecture11.4
-
11.5 Dimension bottlenecksLecture11.5
-
11.6 DiscussionLecture11.6
-
-
12. Advanced optimizations
16-
12.1 Advanced optimizationsLecture12.1
-
12.2 IntroductionLecture12.2
-
12.3 Division by zeroLecture12.3
-
12.4 Filter materializationLecture12.4
-
12.5 Optimizing IF statementsLecture12.5
-
12.6 Column filters vs table filtersLecture12.6
-
12.7 Currency conversionLecture12.7
-
12.8 Lab 4 – Exercise 1 – Open ordersLecture12.8
-
12.9 Lab 4 – Exercise 1 – SolutionLecture12.9
-
12.10 Lab 4 – Exercise 2 – Optimizing if-then-elseLecture12.10
-
12.11 Lab 4 – Exercise 2 – SolutionLecture12.11
-
12.12 Lab 4 – Exercise 3 – Currency conversionLecture12.12
-
12.13 Lab 4 – Exercise 3 – SolutionLecture12.13
-
12.14 Lab 4 – Exercise 4 – New customersLecture12.14
-
12.15 Lab 4 – Exercise 4 – SolutionLecture12.15
-
12.16 DiscussionLecture12.16
-
-
13. Optimization examples
5-
13.1 Optimization examplesLecture13.1
-
13.2 IntroductionLecture13.2
-
13.3 Events in progressLecture13.3
-
13.4 New and returning customersLecture13.4
-
13.5 DiscussionLecture13.5
-
-
14. Conclusion
1-
14.1 ConclusionLecture14.1
-
This content is protected, please login and enroll course to view this content!
Next
8.8 Measuring MDX