本站提供 8500 多本免费的 IT 技术电子书在线下载。
  1. 文章总数:8391
  2. 浏览总数:629,011
  3. 评论:0
  4. 分类目录:125 个
  5. 注册用户数:31
  6. 最后更新:2019年11月22日
过往记忆博客公共帐号iteblog_hadoop
欢迎关注微信公共帐号:
iteblog_hadoop

Expert Cube Development with SSAS Multidimensional Models

SQL iteblog 149℃ 0评论

关注 过往记忆大数据 微信公众号,回复 3727 获取本书下载地址。

子标题:Expert tips and tricks for designing Analysis Services Multidimensional Models

Expert Cube Development with SSAS Multidimensional Models
作者:
Alberto Ferrari, Chris Webb, Marco Russo
ISBN-10:
1849689903
出版年份:
2014-02-24
页数:
402
语言:
English
文件大小:
7.27 MB
文件格式:
PDF

图书描述

Microsoft’s SQL Server Analysis Services 2012 Multidimensional is an OLAP server that allows end users to analyze large amounts of business data quickly and easily, using a variety of tools including Excel, and to create their own reports without IT involvement. It is part of the Microsoft SQL Server suite of tools and has been used widely on Business Intelligence projects for the last 15 years; it is now the most commonly used OLAP server in the world.

Expert Cube Development with SSAS Multidimensional Models will teach you tips and tricks for cube design from some of the most experienced Analysis Services experts in the world. Topics covered include designing dimensions and cubes, implementing common MDX calculations, security and performance tuning.

The book takes you through the whole lifecycle of Analysis Services cube development, from how data warehouse design affects your cube, through cube and dimension design to performance tuning and monitoring. Some previous experience of Analysis Services is assumed – the focus is on best practices and design patterns.

The book starts off with a discussion of data warehouse design and how it relates to Analysis Services. Following on from that, best practices relating to Analysis Services cube and dimension design are covered, including topics such as optimizing dimension attribute relationships and handling fact tables that contain data at different granularities.

Next, the book looks at using MDX to implement common business calculations, and then moves on to more advanced problems like currency conversion calculations and creating a date tool dimensions.

Finally security, performance tuning, automation of administrative tasks and monitoring usage and performance each get their own chapter and subject such as dynamic security roles, using Profiler to diagnose query performance problems and automating partition creation are also dealt with.

下载地址

关注 过往记忆大数据 微信公众号,回复 3727 获取本书下载地址。

如图书无法下载,请加微信 fangzhen0219 反馈。
喜欢 (1)or分享 (0)
发表我的评论
取消评论

表情
本博客评论系统带有自动识别垃圾评论功能,请写一些有意义的评论,谢谢!