|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-ssas-multidimensional-mdx-an-introduction/
课程评论：没有评论
**课程名称：SQL Server SSAS (多维 MDX) – 入门介绍** **课程概述：** 本课程旨在为初学者提供SQL Server Analysis Services (SSAS) 和 MDX 多维数据集的基础知识。与传统的OLTP（在线事务处理）数据库不同，OLTP数据库侧重于快速数据录入，而本课程将介绍如何构建OLAP（在线分析处理）系统。OLAP系统的核心是“立方体”，其中数据经过预聚合和预计算，使得用户能够快速查询和提取信息，而无需编写复杂的SQL语句。 本课程将指导学员如何从普通数据库和数据仓库中创建多维数据集（立方体），并演示如何将其导出到SQL Server Management Studio (SSMS) 和 SQL Server Reporting Services (SSRS)。此外，课程还将简要介绍更高级的查询语言 MDX。 **课程内容亮点：** * **由浅入深：** 即使是完全的初学者也能轻松入门，快速掌握创建立方体的概念和步骤。 * **实用性强：** 详细讲解如何设置数据源、源视图、维度和属性，帮助学员动手实践。 * **概念清晰：** 课程内容精炼，理论与实践相结合，使SSAS的学习过程更加简单易懂。 * **为进阶打下基础：** 学习者不仅能理解SSAS的基本原理，还能为后续更深入的学习和研究打下坚实基础。 **目标学员：** * 完全没有SSAS多维数据集经验的初学者。 * 希望巩固和复习SSAS基础知识的学习者。 **注意：** 本课程与Microsoft公司无关，也未获得其官方认可或赞助。
Reviews:"Good Stuff Overall!!! In my opinion, the instructor did great with the "How-tos" which helped for sure in grasping the whole concept of how to create cubes, set up data source and source views, dimensions, add attributes etc." - Lakeside David-Debo"A fantastic course which gets you rolling very quickly and comfortably, thanks for the short and condensed knowledge delivery. Thanks, Phillip you made SSAS very simple for me." - Anup Kale"This is really the perfect course for beginners! Easy to learn and very inspirational for further investigations in SSAS. Thank you very much, Phillip!" - Marina BarinovaWelcome to this course on SQL Server SSAS and MDX Cubes - an Introduction.Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.You may have become experienced with creating SQL statements in SQL Server Management Studio. Building databases is ideal when you want to quickly add data - that's why they are called OLTP - Online Transaction Processing - they are designed for speed for adding transactions. But what if you want to get information out quickly? OLTP databases are not based designed for this. What you need instead is a process whereby data is pre-aggregated - in other words, a lot of the calculations you may write have been calculated before you ask for them. It saves a lot of time. It would also be useful if the end user didn't have to bother with SQL queries, and could use something a bit more hands-on, although retaining something more advanced for advanced users. That's where cubes come in, full of pre-aggregated data, and SQL Server Analytical Services- or SSAS - (Online Analytical Processing) allows you to make these cubes. This course is designed for the complete beginner in Multidimensional cubes, or someone who wants to refresh their memory. We'll create a cube to start with from an ordinary database, and then I'll ask you to create one from a special database known as a Data Warehouse. We'll export our cube in SQL Server Management Studio, and into SSRS - and we'll even have a bit of a look at the more advanced way of querying that is MDX.
