|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mdx-training/
课程评论：没有评论
**Coursera MDX Training Part 2 课程总结** 本课程是MDX（Multidimensional eXpressions）训练系列的第二部分，专注于MDX查询的高级概念。MDX是一种用于从多维OLAP（Online Analytical Processing）立方体中查询和检索数据的语言。本课程通过使用SSAS（SQL Server Analysis Services）立方体来演示MDX查询的编写。作为SSAS和MSBI（Microsoft Business Intelligence）培训的一部分，本课程对于深入理解MDX概念和成为MDX专家至关重要。 **课程涵盖的主要内容：** * **层级（Hierarchies）操作：** * Descendants, Ascendants, Parent, Ancestor, Siblings * FirstSibling, LastSibling, Firstchild, Lastchild * Item, PrevMember, NextMember * Lag, Lead, Hierarchize * CurrentMember, Ordinal * Order Function, Rank Function * **其他函数：** * IIF, Switch * Crossjoin, Union, Except, Intersect * DrilldownMember, DrilldownLevel, DrilldownLevelTop, DrilldownLevelBottom * DrilldownMemberTop, DrilldownMemberBottom * Generate Function * **时间相关操作（Time Intelligence）：** * 向维度添加时间智能 * YTD (Year-to-Date), QTD (Quarter-to-Date), MTD (Month-to-Date), WTD (Week-to-Date) * PeriodsToDate, OpeningPeriod, ClosingPeriod * Parallelperiod, LastPeriods * **业务场景应用：** * 计算每个产品对业务的销售贡献百分比。 * 计算产品对其子类别的销售贡献百分比，以及子类别对其类别的销售贡献百分比。 * 根据销售贡献将产品划分为不同等级（A、B、C类）。 * 计算月度销售额及日均销售额。 * 找出各国销售额排名前五的产品。 * 分析给定年份的前六个月销售额。 * 比较当前年份与上一年的销售额。 * 比较当前年份前六个月与上一年前六个月的销售额。 * 比较当前月份销售额与过去三个月平均销售额。 * 计算库存的期初或期末存货。 * 根据销售额对产品进行排名。 * 汇总除特定国家（如美国）之外所有国家的销售明细，包括各州销售情况。 通过完成本课程，学员将能够自信地编写复杂的MDX表达式，从而熟练运用MDX进行数据分析。
In MDX training Part2 video training course advanced concepts of MDX queries are discussed The basic concepts are already discussed in MDX training course Part 1 Multidimensional eXpressions are used to query and get the data from Multi Dimension OLAP cube. These video tutorials have used SSAS Cubes to write MDX Queries This advance online MDX training course is a part of SSAS Training (SQL Server Analysis Services). The SSAS comes under MSBI Training (Microsoft Business Intelligence) This course is very important to get familiar with all concept of MDX and expert knowledge of the same. Following are the course contents Playing with Hierarchies •Descendants Function •Ascendants Functions •Parent •Ancestor •Siblings FirstSibling LastSibling •Firstchild Lastchld •item •PrevMember NextMember •Lag Lead •Hierarchize Function •CurrentMember •Ordinal •More on Order Function •Rank Function More functions • iif Function • Switch function • Crossjoin Union Except Intersect • DrilldownMember and DrilldownLevel DrilldownLevelTop and DrilldownLevelBottom • DrilldownMemberTop • DrilldownMemberBottom • Generate Function Working with Time •How to add Time Intelligence to a Dimesion YTD QTD MTD WTD PeriodsToDate OpeningPeriod •ClosingPeriod •Parallelperiod •LastPeriods Business Scenarios •Percent Sales Contribution of every Product to the business •Percent Sales Contribution of every Product to its Subcategory and then Percent Sales Contribution of every Subcategory to its Category •Dividing Products into sections.For Example if the sale of the product has above 20% of contribution to the business then Product belongs to Class A •If the contribution of the product is between 10 to 20 % then class B else class C •To find monthly sales and for every month what is the average per day sales •For every country what are the top 5 best selling products •Sales of first 6 months of a given year •Comparing current year sales with previous year sales •Comparing sales of first 6 months of the current year with the previous year sales •Comparing current month sales with the average of last three months sales •You need to find out opening stock at the start of the month or Closing Stock at the end of the month for an inventory •Providing Ranking to the Products based on Sales •Summary Sales details of all the countries except one country. Eg USA , in this you want to see state wise sales as well After learning this online training course participant will be able to write complex MDX expressions and feel confident in writing the commands
