Microsoft SQL Data Models Development (70-768)

Focused View

6:17:10

131 View

1 - Microsoft SQL Data Modeling

1 - Welcome to 70-768 Developing SQL Data Models.mp4

01:54

2 - Introducing SSAS and Data Modeling.mp4

06:00

3 - Getting SSAS (SSDT).mp4

07:00

4 - Dimensions and Measures.mp4

04:20

5 - Multidimensional Data Sources and Views.mp4

12:46

6 - Designing Dimensions for Multidimensional Models.mp4

10:28

7 - Building a Cube.mp4

06:07

8 - Using Your Cube in Power BI.mp4

04:06

9 - Fact Dimensions.mp4

10:43

10 - Parent-Child Dimensions.mp4

05:02

11 - Referenced Dimensions.mp4

07:31

12 - Slowly Changing Dimensions.mp4

07:47

13 - Introducing Hierarchies (Attribute Relationships).mp4

07:38

14 - Implementing Attribute Relationships.mp4

08:51

15 - Multidimensional Dimension Types.mp4

09:32

16 - Multidimensional Measures and Measure Groups.mp4

07:58

17 - Multidimensional Calculations and Aggregations.mp4

07:02

18 - Introducing Tabular Modeling.mp4

09:25

19 - Introducing Tabular Measures and DAX.mp4

06:19

20 - Tabular Relationships.mp4

08:11

21 - Hierarchies.mp4

03:43

22 - Tabular Partitions.mp4

03:26

23 - Implementing Tabular Partitions.mp4

04:53

24 - Perspectives.mp4

04:42

25 - Calculated Columns.mp4

04:43

26 - Tabular DirectQuery vs. In-Memory.mp4

06:00

27 - Automating Scheduled Refreshes.mp4

08:43

28 - Managing Users and Permissions.mp4

04:37

29 - Row Level Security.mp4

03:20

2 - Microsoft SQL MDX and DAX

1 - Introducing Multidimensional Expressions (MDX).mp4

05:47

2 - MDX Rows, Columns, Members, and Sets.mp4

09:12

3 - Understanding Tuples.mp4

04:00

4 - Tuple Sets.mp4

04:48

5 - Introducing MDX Functions with MEMBER.mp4

05:08

6 - ORDER and HEAD Functions.mp4

05:47

7 - Handling Nulls in MDX.mp4

02:22

8 - MDX FILTER Function.mp4

03:07

9 - Navigation with DESCENDANTS.mp4

05:17

10 - Time Functions.mp4

03:33

11 - WITH Clause.mp4

04:31

12 - MDX AGGREGATE Function.mp4

03:07

13 - Logical Functions in MDX.mp4

03:35

14 - Introducing Data Analysis Expressions (DAX).mp4

03:12

15 - DAX Studio and EVALUATE.mp4

08:44

16 - Formatting Results with ORDER and FILTER.mp4

04:50

17 - Grouping Aggregations with SUMMARIZECOLUMNS.mp4

09:22

18 - Basic DAX Calculations.mp4

06:18

19 - Custom Measures, Variables, and Tables Using DEFINE.mp4

03:51

20 - Introducing Iterator (X) Calculations.mp4

04:14

21 - Implementing Iterator (X) Functions.mp4

02:48

22 - Basic Logical Functions in DAX.mp4

05:43

23 - SWITCH Logical Function.mp4

02:26

24 - Variables (VAR).mp4

02:39

25 - CALCULATE Function.mp4

04:19

26 - Date and Time Functions.mp4

04:06

27 - Ranking Data with RANKX.mp4

03:26

3 - Microsoft SQL SSAS Tuning

1 - File and Disk Layouts.mp4

04:33

2 - Multidimensional Memory Limits.mp4

04:40

3 - Configuring Multidimensional Memory Limits.mp4

02:51

4 - Tabular Memory Limits.mp4

04:26

5 - Understanding NUMA.mp4

04:07

6 - Configuring Affinity.mp4

03:19

7 - Understanding SSAS Clustering.mp4

04:24

8 - Multidimensional Query Plans.mp4

03:33

9 - Tracing a Multidimensional Query.mp4

05:44

10 - Tabular Query Plans.mp4

03:04

11 - Tracing a Tabular Query.mp4

05:32

12 - Performance Monitoring.mp4

07:24

13 - KPIs.mp4

04:34

More details

User Reviews

Rating

average 0

Total votes0

Focused display

CBT Nuggets is renowned for providing innovative training that's informative, meaningful, and engaging. We provide a variety of training, primarily in IT, project management, and office productivity topics. Our comprehensive library contains thousands of training videos ranging from Cisco networking to Microsoft Word. Whether you want to pass a certification exam, increase your skills, or simply learn new things, we've got you covered! All of our training is delivered through high-quality online streaming video. Subscribers can train 24 hours a day, seven days a week, from the convenience of a computer or mobile device. CBT Nuggets trainers are the rock stars of training, renowned for their expertise, industry-wide credibility, and engaging personalities. They enable CBT Nuggets to deliver accurate, up-to-date training, using a laid-back whiteboard presentation style. There are no scripts, EVER. Our trainers love to teach, and it shows! CEO and founder Dan Charbonneau was a Microsoft trainer when he began recording CBT Nuggets' very first training videos back in the 1990s. He wanted to help provide large organizations, small teams and individuals with comprehensive and budget-conscious training, and he realized it couldn't be done in a classroom. From the CBT Nuggets World Headquarters in Eugene, Oregon, Dan and his team promise each video will be informative, comprehensive, accurate, and fun to watch.