2013
Pluralsight
Stacia Misner
3h 37m
English
This course provides an introduction to MDX by explaining key concepts, introducing commonly used functions, and demonstrating working examples of MDX queries.
This course explains how to use MDX to query an Analysis Services multidimensional database.
It begins with an introduction to the language, showing how it can be used beyond developing a cube, as well as an introduction to important concepts such as tuples and sets.
The course then focuses on how to structure queries and how to create sets to use on a query axis.
The course then continues with an exploration of the multiple navigation functions used to traverse hierarchical data.
Last, it explains how to build more complex queries by adding calculations in the form of calculated measures, calculated members, and named sets.
This course was written for SQL Server 2012 Analysis Services, but most principles apply to SQL Server 2005 and later.
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 926 KB 0:00:40 128kbps 872.00 1024x768 15 frames/second 01.Introduction to MDX
02.Introduction to MDX 1.57 MB 0:01:06 128kbps 997.00 1024x768 15 frames/second 01.Introduction to MDX
03.Demo - Comparing MDX to SQL Part 1 10.8 MB 0:06:11 128kbps 237.00 1024x768 15 frames/second 01.Introduction to MDX
04.Demo - Comparing MDX to SQL Part 2 12.3 MB 0:06:18 128kbps 260.00 1024x768 15 frames/second 01.Introduction to MDX
05.Demo - Comparing MDX to SQL Part 3 10.5 MB 0:05:26 128kbps 275.00 1024x768 15 frames/second 01.Introduction to MDX
06.MDX Usage 6.24 MB 0:04:15 128kbps 1452.00 1024x768 15 frames/second 01.Introduction to MDX
07.Multidimensional Model Terms and Concepts 4.43 MB 0:03:14 128kbps 1103.00 1024x768 15 frames/second 01.Introduction to MDX
08.Tuples and Sets 9.17 MB 0:06:22 128kbps 1581.00 1024x768 15 frames/second 01.Introduction to MDX
09.Summary 2.05 MB 0:01:30 128kbps 883.00 1024x768 15 frames/second 01.Introduction to MDX
01.Introduction 1.80 MB 0:01:22 128kbps 843.00 1024x768 15 frames/second 02.Basic MDX Queries
02.Identifiers 6.27 MB 0:04:21 128kbps 1211.00 1024x768 15 frames/second 02.Basic MDX Queries
03.Tuple Request 3.89 MB 0:02:23 128kbps 109.00 1024x768 15 frames/second 02.Basic MDX Queries
04.Axes 1.93 MB 0:01:22 128kbps 785.00 1024x768 15 frames/second 02.Basic MDX Queries
05.Sets 1.40 MB 0:01:01 128kbps 750.00 1024x768 15 frames/second 02.Basic MDX Queries
06.Demo - Axes 10.2 MB 0:06:14 128kbps 1995.00 1024x768 15 frames/second 02.Basic MDX Queries
07.Demo - Sets on Axes 5.54 MB 0:02:59 128kbps 2014.00 1024x768 15 frames/second 02.Basic MDX Queries
08.Empty Rows or Columns 1.05 MB 0:00:41 128kbps 99.00 1024x768 15 frames/second 02.Basic MDX Queries
09.Demo - NON EMPTY keyword 3.56 MB 0:02:05 128kbps 1990.00 1024x768 15 frames/second 02.Basic MDX Queries
10.Query Resolution 3.85 MB 0:02:43 128kbps 1371.00 1024x768 15 frames/second 02.Basic MDX Queries
11.Cell Properties 1.12 MB 0:00:43 128kbps 1248.00 1024x768 15 frames/second 02.Basic MDX Queries
12.Demo - Cell Properties 8.26 MB 0:04:07 128kbps 2254.00 1024x768 15 frames/second 02.Basic MDX Queries
13.Dimension Properties 1.48 MB 0:00:58 128kbps 1364.00 1024x768 15 frames/second 02.Basic MDX Queries
14.Demo - Dimension Properties 7.19 MB 0:03:27 128kbps 375.00 1024x768 15 frames/second 02.Basic MDX Queries
15.Summary 3.83 MB 0:02:41 128kbps 155.00 1024x768 15 frames/second 02.Basic MDX Queries
01.Introduction 1.55 MB 0:01:12 128kbps 702.00 1024x768 15 frames/second 03.Sets
02.Introduction to Set Functions 2.97 MB 0:02:03 128kbps 1290.00 1024x768 15 frames/second 03.Sets
03.Set Usage in A Query 1.48 MB 0:01:03 128kbps 998.00 1024x768 15 frames/second 03.Sets
04.Demo - Set Functions-Members and AllMembers 19.3 MB 0:10:49 128kbps 2599.00 1024x768 15 frames/second 03.Sets
05.Set Order 1.98 MB 0:01:25 128kbps 1182.00 1024x768 15 frames/second 03.Sets
06.Demo - Order Function 12.0 MB 0:07:06 128kbps 2110.00 1024x768 15 frames/second 03.Sets
07.Subsets 1.09 MB 0:00:41 128kbps 1119.00 1024x768 15 frames/second 03.Sets
08.Demo - Head and Tail Functions 6.63 MB 0:03:53 128kbps 2187.00 1024x768 15 frames/second 03.Sets
09.Sort and Create A Subset in One Step 1.75 MB 0:01:05 128kbps 1518.00 1024x768 15 frames/second 03.Sets
10.Demo - TopCount Function and Variations 12.0 MB 0:06:47 128kbps 2303.00 1024x768 15 frames/second 03.Sets
11.Filtered Set 1.28 MB 0:00:58 128kbps 565.00 1024x768 15 frames/second 03.Sets
12.Demo - Filter Function 7.33 MB 0:04:32 128kbps 2321.00 1024x768 15 frames/second 03.Sets
13.Multidimensional Set 1.26 MB 0:00:52 128kbps 955.00 1024x768 15 frames/second 03.Sets
14.Demo - CrossJoin function 6.12 MB 0:03:36 128kbps 2310.00 1024x768 15 frames/second 03.Sets
15.Polymorphic Operators 1.81 MB 0:01:09 128kbps 1056.00 1024x768 15 frames/second 03.Sets
16.Demo - (asterisk), +, and - Operators 5.16 MB 0:03:00 128kbps 2195.00 1024x768 15 frames/second 03.Sets
17.Set Creation Through Iteration 1.70 MB 0:01:11 128kbps 1215.00 1024x768 15 frames/second 03.Sets
18.Demo - Generate Function 5.03 MB 0:02:59 128kbps 2070.00 1024x768 15 frames/second 03.Sets
19.Tuple Elimination 1.47 MB 0:01:04 128kbps 880.00 1024x768 15 frames/second 03.Sets
20.Demo - Nonempty Function 6.94 MB 0:03:55 128kbps 2199.00 1024x768 15 frames/second 03.Sets
21.Tuple Extraction 1.34 MB 0:00:57 128kbps 996.00 1024x768 15 frames/second 03.Sets
22.Demo - Extract Function 7.48 MB 0:04:01 128kbps 2606.00 1024x768 15 frames/second 03.Sets
23.Asymmetrical Set 1.21 MB 0:00:47 128kbps 1323.00 1024x768 15 frames/second 03.Sets
24.Demo - Asymmetrical Set 3.94 MB 0:02:08 128kbps 2075.00 1024x768 15 frames/second 03.Sets
25.Demo - Summary 4.86 MB 0:03:33 128kbps 128.00 1024x768 15 frames/second 03.Sets
01.Introduction 1.02 MB 0:00:44 128kbps 878.00 1024x768 15 frames/second 04.Hierarchies in MDX
02.Hierarchy Navigation 2.36 MB 0:01:39 128kbps 117.00 1024x768 15 frames/second 04.Hierarchies in MDX
03.Upward Navigation 4.51 MB 0:02:49 128kbps 198.00 1024x768 15 frames/second 04.Hierarchies in MDX
04.Demo - Parent, Ancestor, and Ascendants Functions 6.76 MB 0:03:53 128kbps 1911.00 1024x768 15 frames/second 04.Hierarchies in MDX
05.Downward Navigation 3.93 MB 0:02:05 128kbps 435.00 1024x768 15 frames/second 04.Hierarchies in MDX
06.Demo - Children, Descendants, FirstChild, LastChild Functions 9.11 MB 0:05:15 128kbps 2172.00 1024x768 15 frames/second 04.Hierarchies in MDX
07.Horizontal Navigation 8.99 MB 0:05:07 128kbps 217.00 1024x768 15 frames/second 04.Hierarchies in MDX
08.Demo - Horizontal Navigation Functions 4.96 MB 0:03:00 128kbps 1950.00 1024x768 15 frames/second 04.Hierarchies in MDX
09.Summary 2.15 MB 0:01:35 128kbps 843.00 1024x768 15 frames/second 04.Hierarchies in MDX
01.Introduction 2.41 MB 0:01:56 128kbps 824.00 1024x768 15 frames/second 05.Calculations
02.Introduction to Calculations 2.98 MB 0:02:19 128kbps 884.00 1024x768 15 frames/second 05.Calculations
03.Tuple-Based Calculations 6.57 MB 0:04:07 128kbps 283.00 1024x768 15 frames/second 05.Calculations
04.Demo - Tuple-Based Calculations 13.0 MB 0:07:16 128kbps 2224.00 1024x768 15 frames/second 05.Calculations
05.Set-Based Calculations 3.65 MB 0:02:16 128kbps 130.00 1024x768 15 frames/second 05.Calculations
06.Demo - Set-Based Calculations 22.2 MB 0:12:01 128kbps 2701.00 1024x768 15 frames/second 05.Calculations
07.Time-Series Calculations 3.22 MB 0:02:15 128kbps 202.00 1024x768 15 frames/second 05.Calculations
08.Demo - Time-Series Calculations 14.4 MB 0:07:50 128kbps 371.00 1024x768 15 frames/second 05.Calculations
09.Miscellaneous Functions 1.58 MB 0:01:13 128kbps 79.00 1024x768 15 frames/second 05.Calculations
10.Demo - Miscellaneous Functions 8.67 MB 0:03:44 128kbps 359.00 1024x768 15 frames/second 05.Calculations
11.Summary 3.41 MB 0:02:38 128kbps 151.00 1024x768 15 frames/second 05.Calculations
http://pluralsight.com/training
Download File Size:317.27 MB
|
