|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mdx-training-ssas/
课程评论：没有评论
**课程名称：MDX 基础训练（第一部分）** **课程概述：** 本课程旨在教授 MDX（Multi Dimensional eXpression）语言，用于查询 OLAP（在线分析处理）多维数据集。通过本课程，您将学会如何使用 MDX 语言从 OLAP 数据立方体中检索数据。课程以 SQL Server Analysis Services 为技术基础，通过实际操作帮助您理解 MDX 查询的原理，类比于使用 SQL 语句从数据库中提取数据。 **课程内容亮点：** * **多维数据集结构详解：** 深入理解多维数据集的内部构造。 * **MDX 查询数据机制：** 掌握 MDX 如何从数据立方体中获取数据。 * **基础数据立方体创建：** 学习如何构建一个基本的数据立方体。 * **层级（Hierarchy）概念与应用：** 理解层级的意义、作用以及如何创建和修改层级。 * **多维数据集的修改：** 学习如何对现有的数据立方体进行调整。 * **核心术语解析：** 讲解 Children, Member, Level 等关键术语。 * **集合（Set）与元组（Tuple）：** 掌握集合 `{}` 和元组 `()` 的概念及用法。 * **度量（Default Measure）与筛选（Filter Condition, Having Condition, Where Condition）：** 学习如何设置默认度量，以及 WHERE, HAVING, FILTER 条件的区别和应用。 * **计算成员（Calculated Member）与命名集（Named Set）：** 学习如何创建计算成员和命名集（包括 Order Set 的示例），并理解两者使用的场景。 * **作用域（Scope）：** 区分查询范围（Query Scoped）和会话范围（Session Scoped）的计算成员和命名集。 * **静态与动态命名集：** 了解静态和动态命名集的差异。 **学习方式：** 课程包含视频教程、测验、实验练习和演示操作，旨在帮助学员建立信心，独立编写基础 MDX 脚本。即使您在工作中遇到预先编写好的 MDX 脚本，也能通过本课程对其进行理解。 **课程展望：** 本课程为 MDX 训练系列的第一部分，后续还将推出“MDX 基础训练（第二部分）”，将深入讲解更高级的 MDX 查询和函数，使您能够编写更复杂的 MDX 命令。
The full form of MDX is Multi Dimensional eXpression. This is used to query OLAP cube. It means you can select or retrieve the data from OLAP cube using MDX. In this course i have used SQL Server Analysis Services technology to fetch the data using MDX queries.To make it more clear i can say , we write SQL commands to select the data from the database. In the same way we write MDX queries to select the data from OLAP cube. In this online MDX Training video Course, following are the course contents which are covered•Structure of the cube •How MDX Queries Fetch the data from the cube •How to create a basic cube •What is the purpose of Hierarchy •How to create hierarchies •How to modify the existing cube •Terminologies - Children,Member and Level •Set - { } •Tuple - ( ) •Default measure •Filter condition •Having condition •Where condition •Difference between where and having condition in MDX •Calculated Member •Named set Orderset - One example of named set The result of a Tuple will return a Set Decide when to create named set and calculated member •Query scoped and Session scoped Calculated Member •Query scoped and Session scoped Namedset Allmembers Static and Dynamic Named SetIn this MDX video tutorial ,quiz, lab exercises and demonstration exercises are also included. With all these practice activities participant will feel more confident and will be able to write basic MDX scripts by himself or herself. If participant is working in a company where MDX scripts are prewritten then participants will be able to understand those scripts after learning this course.But i will not stop only to this course , very soon i will release MDX Part 2 which will have advanced MDX queries and functions. After that course participant will be able to write complex MDX commands and feel more confident in writing MDX commands.
