|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/msbi-ssis-ssas-ssrs/
课程评论：没有评论
Coursera 课程：一步步学习 MSBI, SSIS, SSRS 和 SSAS 本课程是掌握 Microsoft Business Intelligence (MSBI) 的终极教程，通过 43 个深入的实验，全面教授 MSBI 的三大核心组件：SSIS (SQL Server Integration Services)、SSAS (SQL Server Analysis Services) 和 SSRS (SQL Server Reporting Services)。 **课程内容涵盖 SSIS 的方方面面：** * **基础知识与 ETL：** MSBI 基础、数据流、控制流、ETL 流程、数据仓库概念。 * **数据转换与处理：** 条件拆分、数据转换、错误处理、排序、合并、Merge Joins、Pivot、UnPivot、聚合。 * **SSIS 编程与流程控制：** For Loop、变量、参数、调试、SSIS 包的打包与部署、文件组件、将 SSIS 包作为任务运行。 * **数据仓库组件：** Slowly Changing Dimensions (SCD) 类型 0, 1、OLEDB 命令、Unicode 转换、Lookup 组件、Lookup 缓存模式、Cache Transform。 * **高级 SSIS 功能：** 事务与检查点、数据剖析任务 (Data Profiling Task) 检查数据质量、Web 服务与 XML 任务、SQL 执行任务、脚本任务、发送邮件任务、脚本组件、更改数据捕获 (CDC)。 * **性能优化与多任务：** 数据转换优化、Buffer Size 调优、多线程实现、异步/同步/全/半/非阻塞组件、SSIS 的页面拆分与性能问题、使用 Data Taps 进行仪器检测。 * **数据质量服务：** 数据质量服务 (DQS)。 **课程内容深入 SSAS 的核心：** * **SSAS 基础与模型：** SSAS Cube 创建、时间序列、Excel 显示。 * **维度与度量：** 维度、度量、星型模式、雪花模式、共享连接管理器、多维表达式 (MDX) 查询。 * **高级 SSAS 功能：** 分层维度、SSAS KPI（关键绩效指标）、SSAS 计算、多对多关系、SSAS Cube 的后台处理、Addictive、Semi-additive 和 Non-additive 度量。 * **SSAS 存储与性能：** SSAS 分区、聚合、ROLAP、MOLAP 和 HOLAP。 * **SSAS 模型与查询：** Tabular 模型、Power Pivot、DAX、创建 Cube、度量、KPI、分区和翻译。 * **数据挖掘：** Data Mining 基础和时间序列算法。 * **SSAS 功能：** 视图 (Perspectives) 与翻译。 **课程内容涵盖 SSRS 的主要方面：** * **SSRS 基础报表：** 简单 SSRS 报表、实现 Matrix、Tabular、参数、排序、表达式。 * **高级报表功能：** DrillDown 和 Subreports。 * **SSRS 可视化：** 条形图、仪表和指示器。 * **SSRS 架构与部署：** SSRS 架构与部署。 本课程通过大量的实践操作，旨在帮助学员系统地掌握 MSBI 的核心技术，提升数据处理、分析和报表制作的能力。
If you are thinking about mastering MSBI then you have reached the ultimate tutorial. Yes , i mean by it:-).This course teaches MSBI using 43 extensive labs as listed below. It goes in depth in to all the three important pillars of MSBI i.e. SSIS , SSAS and SSRS.Lab 1:- MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house. (SSIS)Lab 2:- Conditional split, Data conversion and Error handling. (SSIS)Lab 3:- For Loop, Variables, Parameters and Debugging. (SSIS)Lab 4:- Packaging and Deployment, File component and running SSIS package as a task.(SSIS)Lab 5: - For dimension, measures, star schema, snow flake, shared connection managers & packages tasks.(SSIS)Lab 6:- SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(SSIS)Lab 7:- Lookup, Data conversion optimization and updating SSIS package.(SSIS)Lab 8:- Sort, Merge and Merge Joins.(SSIS)Lab 9:- Creating SSAS Cube. (SSAS)Lab 10:- SSAS Time series and Excel display.(SSAS)Lab11: - What are Transactions and CheckPoints in SSIS? (SSIS)Lab12: - Simple SSRS report & implementing Matrix, Tabular, Parameters, Sorting, Expressions. (SSRS)Lab 13:- Using Data Profiling task to check data quality. (SSIS)Lab 14:- Hierarchical Dimensions. (SSAS)Lab 15:- WebServices and XML Task. (SSIS)Lab16:- DrillDown and Subreports. (SSRS)Lab17:- SSAS KPI (Key Performance Indicators). (SSAS)Lab 18:- Pivot, UnPivot and Aggregation. (SSIS)Lab 19:- SSAS Calculation.(SSAS)Lab 20:- SQL Execute Task. (SSIS)Lab 21:- Reference and Many-to-Many Relationship. (SSAS)Lab 22:- Script Task and Send Mail Task. (SSIS)Lab 23:- Script component(SSIS)Lab 24:- Bar chart, Gauge and Indicators.(SSRS)Lab 25:- Partitions in SSAS. (SSAS)Lab 26:- CDC(Changed Data Capture) in SSIS. (SSIS)Lab 27:- Additive, Semiadditive and non-additive measures in SSAS.(SSAS)Lab 28:- Buffer Size Tuning (SSIS)Lab 29:- How to implement Multithreading in SSIS?(SSIS)Lab 30:- Processing SSAS cube in background.(SSAS)Lab 31:- Explain Asynchronous, Synchronous, Full, Semi and Non blocking Components. (SSIS)Lab 32:- SSRS Architecture and Deployment (SSRS)Lab 33:- DQS( Data Quality Services ) (SSIS)Lab 34:- Explain Tabular Model and Power Pivot (SSAS).Lab 35:- MDX (Multidimensional Expressions) Queries.(SSAS)Lab 36:- Data Mining (Fundamentals and Time Series Algorithm).(SSAS)Lab 37:- Page Split and Performance issues with SSIS.(SSIS)Lab 38:- Aggregations in SSAS.(SSAS)Lab 39:- ROLAP, MOLAP and HOLAP.(SSAS)Lab 40:- Instrumentation using Data Taps (SSIS).Lab 41:- Lookup caching modes and Cache Transform. (SSAS)Lab 42: - Perspectives & Translations. (SSAS)Lab 43:- Tabular Training 1:- Installation, Xvelocity, Vertipaq, DAX,Creating cubes,measures, KPI, Partition and Translation?
