|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-server-analysis-services-ssas-tabular-dax/
课程评论：没有评论
课程名称：微软SQL Server分析服务 - SSAS（Tabular DAX） 课程概述： 本课程涵盖了SQL Server分析服务中的表格模型（Tabular model）。请注意，本课程与微软没有任何关联、支持或赞助。我们将为您的计算机安装SQL Server开发者版本，该版本以前需支付100美元费用，并安装SSAS扩展。接着，我们将在短短几分钟内使用SQL Server创建我们的第一个分析。 在此基础介绍之后，我们将详细探讨如何在Excel中创建分析，包括许多人并不知道但非常有用的高级数据透视表选项。这些选项包括切片器（slicers）、时间线（timelines）和非可视化总计（non-Visual Totals）。然后，我们将开发DAX公式，以进一步扩展模型。许多公式基于Excel公式，但也有一些额外的内容。我们将创建计算列，这些列会在每行中复现，以及度量值，这些是汇总计算。 我们将学习逻辑、聚合、统计、数学、文本、信息、过滤和价值、时间智能函数。最后，我将向您展示如何在Microsoft Excel中进行类似的操作。 通过本课程结束时，您将能够在Visual Studio中创建可靠的分析，将其部署到SQL Server分析服务中，并快速在Excel中深入挖掘结果，同时您也能够帮助他人进行数据分析。
This course covers the Tabular model in SQL Server Analytical Services.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.We'll install SQL Server Developer onto your computer, which previously used to cost $100, together with the SSAS extension.We'll then create our first analysis using SQL Server in just a matter of minutes.After this introduction, we'll go into some detail into how to create your analyses in Excel, including advanced Pivot Table options that most people don't even know about, but which are very useful. This includes slicers, timelines, and non-Visual Totals.Then we'll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too. We'll create calculated columns, which are replicated in each row, and measures, which are summary calculations. We'll have a look at logical, aggregations, statistical, mathematical, text, information, filter and value, and time intelligence functions.Finally, I'll show you how you can do similar things in Microsoft Excel.By the end of this course, you will be able to create reliable analyses in Visual Studio, deploy them into SQL Server Analytical Services, drilled down the results quickly in Excel, and you'll be able to help others with their data analysis.
