|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-70-466implementing-data-models-reports/
课程评论：没有评论
课程名称：Microsoft 70-466：实施数据模型与报告 课程概述：本课程旨在帮助参与者掌握在Microsoft SQL Server 2012中实施数据模型和报告所需的知识与技能，特别适合于BI开发人员。课程内容涵盖创建和维护多维数据模型、OLAP立方体以及用于商业决策的信息展示等实操工作。学员的主要职责可能包括处理多个数据库系统的大型数据集，理解立方体/数据仓库/视图的基本原理，评估统一维度模型（UDM）与商业智能语义模型（BISM）的数据模型选择，开发支持分析的立方体及多维表达式（MDX）查询，构建数据透视表以及PowerPivot解决方案，设计与测试报告模型、布局和模板，管理报告系统配置与订阅，使用报告生成器创建报告，开发复杂的SQL查询以及使用Crescent构建报告。 本课程为参与者准备了Microsoft 70-466考试所需的全面技能与知识，主要学习领域包括： - 设计维度和度量 - 在立方体中实施和配置维度 - 设计支持立方体架构的模式 - 创建度量 - 实施立方体 - 创建多维表达式（MDX）查询 - 在数据模型中实施自定义逻辑 - 在多维模型中实施存储设计 - 为数据分析选择适当的模型 - 分析数据模型性能 - 处理数据模型 - 解决数据分析问题 - 部署SSAS数据库 - 安装与维护SSAS实例 - 在商业智能语义模型（BISM）中配置权限和角色 - 实施表格数据模型 - 在表格数据模型中实施业务逻辑 - 为表格数据模型实施数据访问 - 设计报告 - 实施报告布局 - 配置报告解决方案的身份验证与授权 - 在报告中实现交互性 - 解决报告服务问题 - 管理报告环境 - 配置报告数据源和数据集 我们致力于创造最高质量的课程内容，确保学员获得成功所需的培训和知识。
This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012. This course is designed for BI Developers who most-likely focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making. Primary responsibilities may include but are not limited to: Working with large data sets across multiple database systemsCube/warehouse/views fundamentalsData model decisions: Unified Dimension Model (UDM) versus Business Intelligence Semantic Model (BISM)Develop Cubes and Multidimensional Expressions (MDX) queries to support analystsOnline Analytical Processing (OLAP) cube performanceBuilding pivot tables from cubesBuilding PowerPivot solutionsDesign and test report models, layouts and templatesManage reporting system: configuration and subscriptionsUsing report builder to create reportsDevelop complex SQL queries for reportsBuilding reports Using Crescent This training course on implementing data models and reports with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-466.This course will provide all the skills and knowledge for the following areas: Designing dimensions and measuresImplementing and configuring dimensions in a cubeDesigning a schema to support a cube architectureCreating measuresImplementing a cubeCreating Multidimensional Expressions (MDX) queriesImplementing custom logic in a data modelImplementing storage design in a multidimensional modelSelecting an appropriate model for data analysisAnalyzing data model performanceProcessing data modelsTroubleshooting data analysis issuesDeploying SSAS databasesInstalling and maintaining an SSAS instanceConfiguring permissions and roles in a Business Intelligence Semantic Model (BISM)Implementing a tabular data modelImplementing business logic in a tabular data modelImplementing data access for a tabular data modelDesigning a reportImplementing a report layoutConfiguring authentication and authorization for a reporting solutionImplementing interactivity in a reportTroubleshooting reporting service issuesManaging a report environmentConfiguring report data sources and datasets We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
