|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-70-467-designing-business-intelligence-solution/
课程评论：没有评论
**课程名称：** Microsoft 70-467 使用 SQL Server 2012 设计智能解决方案 **课程概述：** 本课程旨在帮助学员掌握使用 Microsoft SQL Server 2012 设计商业智能解决方案所需的相关知识和技能，从而做出适合其职业角色的决策。本课程特别面向 BI 架构师，他们负责 BI 基础设施的整体设计，并需要考虑其与其他数据系统的关联。主要职责包括但不限于： * BI 解决方案架构与设计 * 软件和硬件的配置 * 数据仓库和数据集市设计 * 联机分析处理 (OLAP) 数据立方体设计 * 与 SharePoint 或业务线应用程序集成 本课程将为学员准备 Microsoft 70-467 考试。 **课程涵盖的核心技能与知识领域：** * **性能与可扩展性规划：** * 性能规划 * 可扩展性规划 * **系统管理与维护：** * 升级管理规划 * 服务器健康维护 * **安全策略设计：** * 安全策略设计 * **数据存储与管理：** * SQL 分区策略设计 * 备份策略设计 * 日志与审计策略设计 * **报告与数据分析：** * Reporting Services 数据集设计 * Excel Services/Reporting for SharePoint 管理 * **数据获取与管理：** * 数据获取策略设计 * Reporting Services 配置的规划与管理 * **BI 报告解决方案架构：** * BI 报告解决方案架构设计 * **数据仓库设计：** * 数据仓库设计 * Schema 设计 * **数据立方体设计：** * Cube 架构设计 * Fact 表设计 * **BI 语义模型设计：** * BI Semantic Model 设计 * MDX 计算的设计与创建 * **SSIS 包管理与部署：** * SSIS 包执行规划 * SSIS 解决方案部署规划 * SSIS 包配置设计 本课程致力于提供最高质量的课程内容，确保学员获得成功所需的培训和知识。
This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012. This course is designed for BI Architects, who focus on the overall design of the BI infrastructure, including how it relates to other data systems in use. Primary responsibilities may include but are not limited to: BI Solution architecture and designProvisioning of software and hardwareData warehouse and data mart designOnline Analytical Processing (OLAP) cube designIntegration with SharePoint or line of business applications This training course on designing business intelligence solutions with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-467.This course will provide all the skills and knowledge for the following areas: Performance planningScalability planningPlanning for managing upgradesMaintaining server healthDesigning a security strategySQL partitioning strategy designBackup strategy designDesigning a logging and auditing strategyReporting Services dataset designManaging Excel Services/Reporting for SharePointData acquisition strategy designPlanning and managing reporting services configurationBI reporting solution architecture designData warehouse designDesigning a schemaDesigning cube architectureDesigning fact tablesBI Semantic Model designDesigning and creating MDX calculationsDesigning SSIS package executionPlanning to deploy SSIS solutionsDesigning package configurations for SSIS packages We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
