Expert Cube Development with SSAS Multidimensional Models
Alberto Ferrari, Marco Russo, Christopher Webb
Idioma: inglés
Editorial: Packt Publishing, Limited, 2014
- Tapa blanda
- Usado
Librería: Better World Books, Mishawaka, IN, Estados Unidos de AmericaBetter World Books
Vendedor de AbeBooks desde el 3 de agosto de 2006
Condición: Usado - Aceptable
EUR 13,80
Cantidad disponible: 1 disponible
Añadir al carritoDescripción del artículo del vendedor
Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.
N° de ref. del artículo 56746563-6
- Título
- Expert Cube Development with SSAS Multidimensional Models
- Autor
- Alberto Ferrari, Marco Russo, Christopher Webb
- Editorial
- Packt Publishing, Limited
- Año de publicación
- 2014
- Estado
- Good
- Encuadernación
- Encuadernación de tapa blanda
- Idioma
- inglés
- ISBN 10
- 1849689903
- ISBN 13
- 9781849689908
- Peso del artículo
- 1,76 libras
- Dimensiones
- N/A
About This Book
- Design SQL Server Analysis Services cubes, dimensions, and calculations from the experts!
- Add calculations to the cube, including implementing currency conversion and a date tool dimension
- Use security to control access to data in your cube
Who This Book Is For
If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you.You are expected to have some prior experience with Analysis Services cube development.
What You Will Learn
- Build a data mart suitable for use with Analysis Services
- Work with a thread pool effectively
- Create and configure an Analysis Services project in SQL Server Data Tools
- Use the Dimension Wizard and the Dimension Editor to build dimensions
- Create measure groups and associate them with dimensions
- Design cubes and dimensions and also implement common calculations in MDX
- Explore the security model, including dimension security and cell security, and implement dynamic security
- Tune queries to get the best possible performance
- Automate processing and partition creation
- Monitor your cube to see who's actually using it
In Detail
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.
“Sinopsis” puede pertenecer a otra edición de este título.
Reseña del editor
About This Book
- Design SQL Server Analysis Services cubes, dimensions, and calculations from the experts!
- Add calculations to the cube, including implementing currency conversion and a date tool dimension
- Use security to control access to data in your cube
Who This Book Is For
If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you.You are expected to have some prior experience with Analysis Services cube development.
What You Will Learn
- Build a data mart suitable for use with Analysis Services
- Work with a thread pool effectively
- Create and configure an Analysis Services project in SQL Server Data Tools
- Use the Dimension Wizard and the Dimension Editor to build dimensions
- Create measure groups and associate them with dimensions
- Design cubes and dimensions and also implement common calculations in MDX
- Explore the security model, including dimension security and cell security, and implement dynamic security
- Tune queries to get the best possible performance
- Automate processing and partition creation
- Monitor your cube to see who's actually using it
In Detail
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.
“Acerca de” puede pertenecer a otra edición de este título.
Better World Books
Mishawaka, IN, Estados Unidos de America
Vendedor de AbeBooks desde el 3 de agosto de 2006
Tarifas de envío en Estados Unidos de America
| Artículo | De 4 a 8 días hábiles | De 3 a 5 días hábiles |
|---|---|---|
| Primer artículo | EUR 0,00 | EUR 13,34 |
Métodos de pago
Descripción de la tienda
Better World Books (https://www.BetterWorldBooks.com) is a for-profit, socially conscious business and a global online bookseller that collects and sells new and used books online, matching each purchase with a book donation. Each sale generates funds for literacy and education initiatives in the U.S., the UK, and around the world. Since its launch in 2003, Better World Books has raised $33 million for libraries and literacy, donated over 32 million books, and reused or recycled more than 397 million books.…
Información empresarial del vendedor
Better World Books Marketplace, Inc.
55740 Currant Road
Mishawaka, IN Estados Unidos de America 46545
Condiciones de venta
Better World Books (BWB) values your satisfaction and offers you returns within thirty (30) days after the estimated delivery date on most items. All returned items must be in the original condition; used items should include the SKU sticker located on the spine or back of the product.
If you have an incomplete, incorrect, or damaged shipment, please contact our Customer Care team via Abebooks contact seller options before proceeding with the return.Please keep in mind that because we deal mostly in used books, any extra components, such as CDs, DVDs, figurines, or access codes are not included.
Derecho al desistimiento
Si es un consumidor, puede rescindir el contrato de acuerdo con lo siguiente. Por consumidor se entiende cualquier persona física que actúe con fines ajenos a su actividad comercial, empresarial, oficio o profesión.
Información sobre el derecho de desistimiento
Derecho legal de desistimiento
Tiene derecho a rescindir este contrato en un plazo de 14 días sin dar ningún motivo.
El periodo de desistimiento vencerá a los 14 días desde que usted, o un tercero que no sea el transportista e indicado por usted, adquiera la posesión física del último bien o del último lote o pieza.
Para ejercer el derecho de desistimiento, complete de forma electrónica y envíe una declaración clara en nuestro sitio web, desde "Mis compras" en "Mi cuenta". Le enviaremos sin demora un acuse de recibo de dicho desistimiento a través de un soporte duradero (por ejemplo, por correo electrónico).
Para cumplir con el plazo de desistimiento, basta con que envíe su comunicación relativa al ejercicio del derecho de desistimiento antes de que venza el periodo de desistimiento.
Efectos del desistimiento
Si rescinde este contrato, le reembolsaremos todos los pagos que hayamos recibido de usted, incluidos los gastos de envío (excepto los gastos adicionales que surjan si elige un tipo de envío que no sea el tipo de envío estándar más económico que ofrecemos).
Podemos hacer una deducción del reembolso por la pérdida de valor de cualquier bien suministrado, si la pérdida es el resultado de una manipulación innecesaria por su parte.
Efectuaremos el reembolso sin demoras indebidas y, a más tardar, 14 días después de que se nos informe de su decisión de rescindir este contrato.
Efectuaremos el reembolso utilizando el mismo medio de pago que utilizó para la transacción inicial, a menos que haya acordado expresamente lo contrario; en cualquier caso, no incurrirá en ningún cargo como resultado de dicho reembolso.
Podremos retener el reembolso hasta que hayamos recibido los bienes o hasta que nos haya presentado una prueba de que los ha devuelto, lo que ocurra primero.
Deberá devolver los bienes o entregarlos a Better World Books, Mishawaka, Indiana, U.S.A., sin demoras indebidas y, en cualquier caso, en un plazo máximo de 14 días a partir del día en que nos comunique su desistimiento del presente contrato. El plazo se cumple si devuelve la mercancía antes de que venza el periodo de 14 días. Tendrá que asumir los gastos directos de devolución de los bienes. Usted solo es responsable de la disminución del valor de los bienes como resultado de una manipulación distinta a la necesaria para establecer la naturaleza, las características y el funcionamiento de los bienes.
Excepciones al derecho de desistimiento
El derecho de desistimiento no se aplica a lo siguiente:
- La entrega de periódicos, diarios o revistas, con la excepción de los contratos de suscripción; y
- El suministro de contenido digital que no se proporcione en un soporte tangible (por ejemplo, en un CD o DVD) si, al hacer el pedido, aceptó que podíamos empezar a entregarlo y que no podría desistir una vez iniciada la entrega.
Condiciones de envío
Please allow 1-2 business days for order fulfillment.