Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.

  • Apple
  • Android
  • Windows Phone
  • Android

Pour obtenir l'appli gratuite, saisissez votre ou numéro de téléphone mobile.

Prix Kindle : EUR 16,24

Économisez
EUR 22,77 (58%)

TVA incluse

Ces promotions seront appliquées à cet article :

Certaines promotions sont cumulables avec d'autres offres promotionnelles, d'autres non. Pour en savoir plus, veuillez vous référer aux conditions générales de ces promotions.

Envoyer sur votre Kindle ou un autre appareil

Envoyer sur votre Kindle ou un autre appareil

Expert Cube Development with SSAS Multidimensional Models par [Webb,  Chris, Ferrari,  Alberto, Russo,  Marco]
Publicité sur l'appli Kindle

Expert Cube Development with SSAS Multidimensional Models Format Kindle

5.0 étoiles sur 5 3 commentaires client

Voir les formats et éditions Masquer les autres formats et éditions
Prix Amazon
Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
EUR 16,24

Longueur : 402 pages Langue : Anglais
  • En raison de la taille importante du fichier, ce livre peut prendre plus de temps à télécharger

Concours KDP Salon du Livre


Descriptions du produit

Présentation de l'éditeur

Expert tips and tricks for designing Analysis Services Multidimensional Models

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.

Biographie de l'auteur

Chris Webb

Chris Webb (chris@crossjoin.co.uk) has been working with Microsoft Business Intelligence tools for 15 years in a variety of roles and industries. He is an independent consultant (www.crossjoin.co.uk) and trainer (www.technitrain.com) based in the UK, specializing in SQL Server Analysis Services, MDX, DAX, Power Pivot, and the whole Power BI stack. He is the coauthor of MDX Solutions with Microsoft SQL Server Analysis Services 2005 and SQL Server Analysis Services 2012: The BISM Tabular Model. He is a regular speaker at user groups and conferences, and blogs about Microsoft BI at http://cwebbbi.wordpress.com/.



Alberto Ferrari

Alberto Ferrari (alberto.ferrari@sqlbi.com) is a consultant and trainer who specializes in Business Intelligence with the Microsoft BI stack. He spends half of his time consulting for companies who need to develop complex data warehouses, and the other half in training, book writing, conferences, and meetings. He is a SQL Server MVP and a SSASMaestro. He is a founder, with Marco Russo, of www.sqlbi.com, where they publish whitepapers and articles about SQL Server Analysis Services technology. He coauthored several books on SSAS and PowerPivot.



Marco Russo

Marco Russo is a Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design, but he is also involved in the complete development lifecycle of a BI solution. He has particular competence and experience in sectors such as financial services (including complex OLAP designs in the banking area), manufacturing, gambling, and commercial distribution. Marco is also a book author, and in addition to his BIrelated publications, he has authored books about .NET programming. He is also a speaker at international conferences such as TechEd, PASS Summit, SQLRally, and SQLBits. He achieved the unique SSAS Maestro certification and is also a Microsoft Certified Trainer with several Microsoft Certified Professional certifications.


Détails sur le produit

  • Format : Format Kindle
  • Taille du fichier : 16709 KB
  • Nombre de pages de l'édition imprimée : 402 pages
  • Editeur : Packt Publishing (24 février 2014)
  • Vendu par : Amazon Media EU S.à r.l.
  • Langue : Anglais
  • ASIN: B00IN0TIC0
  • Synthèse vocale : Activée
  • X-Ray :
  • Word Wise: Non activé
  • Composition améliorée: Non activé
  • Moyenne des commentaires client : 5.0 étoiles sur 5 3 commentaires client
  • Classement des meilleures ventes d'Amazon: n°203.879 dans la Boutique Kindle (Voir le Top 100 dans la Boutique Kindle)
  •  Voulez-vous faire un commentaire sur des images ou nous signaler un prix inférieur ?

click to open popover

Commentaires en ligne

5.0 étoiles sur 5
5 étoiles
3
4 étoiles
0
3 étoiles
0
2 étoiles
0
1 étoile
0
Voir les 3 commentaires client
Partagez votre opinion avec les autres clients

Meilleurs commentaires des clients

Format: Format Kindle Achat vérifié
Une excellente approche de la modélisation en cube SSAS. L'ouvrage est pédagogique et la lecture est agréable. L'ouvrage s'adresse à tous les publics : débutants et expérimentés car il traite de toute la chaîne.
Remarque sur ce commentaire Avez-vous trouvé ce commentaire utile ? Oui Non Commentaire en cours d'envoi...
Merci pour votre commentaire.
Désolé, nous n'avons pas réussi à enregistrer votre vote. Veuillez réessayer
Signaler un abus
Format: Format Kindle Achat vérifié
Je me suis mis très récemment aux produits BI Microsoft et malgré une formation sur les produits, subsistaient des points d'ombres et d'inconnus.
Ce livre m'a vraiment permis de monter rapidement en compétence et de cibler selon mes besoins.
C'est une vraie bible, les exemples sont complets et faciles à comprendre.
En plus à chaque fois qu'il faut creuser un sujet, il y a des URLs nous permettant d'aller trouver l'info désirée ailleurs !!
Remarque sur ce commentaire Avez-vous trouvé ce commentaire utile ? Oui Non Commentaire en cours d'envoi...
Merci pour votre commentaire.
Désolé, nous n'avons pas réussi à enregistrer votre vote. Veuillez réessayer
Signaler un abus
Format: Format Kindle
D'abord, les auteurs ne sont pas des inconnus, il s'agit des meilleurs experts du moment dans leur domaine. Chris Webb, Alberto Ferrari et Marco Russo sont connus pour leurs compétences en matière de décisionnel.
Ensuite, le contenu du livre est à la hauteur de la qualité de ces auteurs : en un mot, complet. Lorsque beaucoup d'ouvrages se contentent d'introduire des informations de base pour commencer à créer un cube, celui-ci va plus loin : les exemples sont bien choisis et suffisamment complets.
En quelques mots, il s'agit de l'ouvrage que toute personne doit avoir (comme moi) pour améliorer le fonctionnement de leurs modèles multidimensionnels.
Remarque sur ce commentaire Avez-vous trouvé ce commentaire utile ? Oui Non Commentaire en cours d'envoi...
Merci pour votre commentaire.
Désolé, nous n'avons pas réussi à enregistrer votre vote. Veuillez réessayer
Signaler un abus

Commentaires client les plus utiles sur Amazon.com (beta)

Amazon.com: HASH(0x8799f294) étoiles sur 5 10 commentaires
4 internautes sur 4 ont trouvé ce commentaire utile 
HASH(0x87e8ce10) étoiles sur 5 Practical implementations for SSAS 26 mars 2014
Par Gilbert Quevauvilliers - Publié sur Amazon.com
Format: Broché
This book is a must read if you are looking for some useful and practical information in your SSAS Multidimensional models. But it must be noted that this is not an introduction into SSAS Multidimensional modelling, rather practical real world examples.
I found that the book is a wealth of information that can be applied to your working environment. There are a lot of real world examples that I have had a look at and made me check and update my SSAS Multidimensional models so that they can be that much faster and quicker.
It is also a great reference book, for when you are looking for a specific issue, where you can find the requirement and how to solve your particular issue.
I also really enjoyed the book, because it got straight into the requirement and then explained how to potentially solve or improve your requirement. Along with this I found that it was great where they applied their working experience in what they encountered and how they overcome an issue.
It is written by the guys who I consider to be some of the leaders in SSAS Multidimensional modelling. And you can see by the context of the detail in the book, as well as their examples that this happens often in the working environment, and how to get the best performance from your SSAS Multidimensional models.
A great read and I would recommend this book to anyone who is looking for a wealth of information as well as some great insight into the inner workings of SSAS Multidimensional models.
3 internautes sur 3 ont trouvé ce commentaire utile 
HASH(0x87e8ce64) étoiles sur 5 Solid 19 décembre 2014
Par Dimitri Shvorob - Publié sur Amazon.com
Format: Broché
What can I say - another excellent book from the author team I came to associate with high quality after reading their books on SSAS Tabular and PowerPivot. (And one finds even more SSAS wisdom by following the links in the book). However, I would moderate enthusiasm of some of the other reviews, which seem to recommend the book to everybody, and confirm that this is indeed an intermediate-to-advanced book. At the risk of sounding like a Packt hired gun :), I would recommend SSAS Multidimensional beginners to start with "Getting Started with SQL Server 2012 Cube Development" by Lidberg, and point to "SQL Server Analysis Services 2012 Cube Development Cookbook" by Dewald et al. as the best entry in the intermediate category. (But don't learn MDX from those books - "Microsoft SQL Server 2008 MDX Step by Step" by Clay and Smith is so much better). Unfortunately, the genre of SSAS Multidimensional books is not as developed as I would like - isn't it odd, for example, that this (intermediate-to-advanced, as I said earlier) book seems to be the only one mentioning something as bread-and-butter as slowly-changing dimensions? - and "Expert cube development" is a necessary, high-impact entry into the market.
1 internautes sur 1 ont trouvé ce commentaire utile 
HASH(0x87cb22b8) étoiles sur 5 The best guide to SSAS 2012 Multidimensional Models 30 juillet 2014
Par Rick Oller - Publié sur Amazon.com
Format: Broché
Expert Cube Development with SSAS Multidimensional Models is a thorough, in-depth tour of SSAS 2012 from the Multidimensional models perspective. The authors state up front that this is not a book about SSAS Tabular models and this is an important distinction to keep in mind, as it affects the entire approach to SQL Server BI, from the installation of SSAS forward.
We are taken through a basic cube setup, mercifully not using the Northwinds sample database. I like how the authors repeatedly caution that a number of key elements need to be gotten right in the data mart before cube setup begins. While these elements can also be dealt with in the cube definition, it doesn’t mean they should be, and that distinction is borne out by experience, which the authors clearly have, in spades.
We are presented with a number of useful components of SSAS Multidimensional Models including Measure Groups, Drillthroughs, Calculations (with a smattering of MDX code, about as much as I could handle) and some useful chapters on security and performance tuning.
I was relieved that this was not a 1,000+ page book designed to monopolize shelf space in the tradition of old school technical book publishing. For me, it struck a good balance between level of detail and keeping things moving, so I was able to productively work through it in a reasonable amount of time. For a fairly dry topic the authors managed to keep it interesting, although it helps as a reader if you have some cube exposure (as I did) prior to attempting this book.
4 internautes sur 5 ont trouvé ce commentaire utile 
HASH(0x87cb2684) étoiles sur 5 Book Review: Why You Should Read Expert Cube Development With SSAS 2012 Cover to Cover 15 juin 2014
Par Sherry Li - Publié sur Amazon.com
Format: Format Kindle
Expert Cube Development with SSAS 2012 Multidimensional Models was published earlier this year by Packt Publishing. It’s the second edition of the very successful book on SSAS cube development by three well-known industry leaders, Chris Webb, Alberto Ferrari and Marco Russo.

This book is not a tutorial book on using SSAS as a tool. It is more of a guided tour through the lifecycle of building an Analysis Services solution with an informed commentary telling you what to do, what not to do, and what to look out for.

Reading this book cover to cover

If you are a SSAS cube developer, you would want to read this book cover to cover, no matter what level you are, with the exception of absolute beginners who do not understand basic Analysis Services concepts yet, such as what a cube and a dimension is.

I bought the first edition a few years ago, but didn't read it cover to cover because at the time I didn't find some of the topics relevant to my work. Earlier this year I bought the second edition and I found myself unable to put the book down. By the time I knew it, I had already read it cover to cover once, with pages of notes in Microsoft OneNote. Knowing that my cube development skills could have progressed much faster, I wish I had read the book a few years ago cover to cover.

So don’t repeat the same mistake I made. Whether you already have the first edition or just bought the new 2012 edition, go ahead and start reading it now.

What I enjoyed about the book

I don't wish to spoil your fun with the book, so I'll just gloss over a few key points about the book.

1. Beginner developers might think that cube development is all about how to use SSAS as yet another tool. This book will change your mind. The big chunk of Chapter 1 focused on the data modeling for Analysis Services. Then the book moved on to Chapter 2 to show you how to build basic dimensions and cubes. More complex dimension modeling is covered in Chapter 3. Data modeling for measures and measure groups is covered in Chapter 4. What I enjoyed the most is how the book presented the challenges we all encountered in our day-to-day work and provided the best practices in terms of data modeling in Analysis Services multidimensional model.

2. Microsoft Analysis Services is not a standalone technology, it's part of a family of technologies and disciplines that all work together to make it possible for end-users to do interactive data analysis, reporting, and visualization. From a developer's point of view, these technologies include the SQL Server engine, the Reporting Services, the Analysis Services, with the Integration Services in the middle as the glue. The disciplines include, but are not limited to, data warehouse data modeling, multidimensional modeling, and designing and implementation for performance and good user experience. I personally find that being able to fit all these techniques and disciplines together in the lifecycle of building an Analysis Services solution is not an easy task. Throughout the book the authors did a fantastic job of showing how each technique and discipline can fit seamlessly to build high performance cubes.

3. As a tool, Analysis Services is very easy to use; some might say too easy. Dimensions and cubes are built with various wizards with properties already being filled with default values. You can have a cube up and running in a matter of minutes. Some properties are for cube's client tools to consume, but many of the properties are cube's metadata and will end up having some impact on the cube processing performance, query performance, and/or storage engine performance. Assuming that your cube has started its life with a good design, then a good portion of a cube developer's job is to understand what those impacts are and to make informed trade-off decisions. This book is a life-saving book that tells you what those properties mean, what to do with them, what not to do, and what to watch out for.

4. Bad cube query performance can be detrimental for your Analysis Services projects. The book has devoted an entire Chapter 8 to query performance tuning. The concept of query performance tuning is very familiar to SQL Server developers, but cube query performance tuning methodology has its own twist and turns, such as the Formula Engine vs. the Storage Engine, the partitions and aggregations, and tuning an algorithm in MDX. The book explains in detail what to do with each methodology and even the right tools and scripts to use to get the job done correctly.

5. I also like the many links in the book to other very detailed white papers, such as "The Analysis Services 2008 R2 Performance Guide", and "The Many-to-Many Revolution". Many blog posts are also included in the book, such as the blog posts from Mosha Pasumansky who was considered the most influential person in MDX.

No covering of SSAS Tabular models

As you may know, as of SQL Server 2012, there are two versions of Analysis Services: Multidimensional and Tabular. Although both of them are called Analysis Services and can be used for much the same purposes, the development experience for the two is completely different.

I have bought the first edition a few years ago. Although this is basically the same book as the first edition, I still went ahead and bought it because the 2012 edition has a new section that talks about the DAX query support in SSAS 2012 multidimensional model. Don't get me wrong, this book only covers SSAS Multidimensional models. But it's nice to have a new section on how SSAS 2012 multidimensional model supports not only MDX queries, but also DAX queries.

No substantial changes in this second edition

Since there are no substantial changes in this second edition, it’s probably not worth buying a copy of the second edition if you already have a copy of the first edition. What is covered in the first edition should work perfectly fine in SSAS 2008 and 2012, and even in 2014. This is because Microsoft has not added anything that is substantially new to SSAS Multidimensional models since the 2008 version. But if you don't have the 2008 edition, I'd recommend you to buy this new 2012 edition, even if you are still working on cubes in SSAS 2008.

Not a book for absolute beginners

If you still need to understand basic Analysis Services concepts, such as what a cube and a dimension is, then this book is not book for you. This book does not take the form of a basic tutorial either.

Authors’ personal experience and thoughts are invaluable

Chris Webb, Alberto Ferrari, and Marco Russo are well-known in the SSAS and MDX community. This is an invaluable book because it contains their personal experience and thoughts. I myself visit Microsoft books online (BOL) very often. But if a book is solely derived from BOL then it is not too useful for me, as I can read it in the BOL myself. I am putting this review on my blog, and also planning to put it out on Amazon and Barnes and Nobel, hoping that all cube developers will read the book cove to cover.

Packt Publishing

Packt Publishing is one of my favorite tech book publishers. Their books focus on practicality, recognizing that readers are ultimately concerned with getting the job done. They also offer a subscription service, which I personally also use. Good job for putting out "Expert Cube Development with SSAS 2012"!
2 internautes sur 3 ont trouvé ce commentaire utile 
HASH(0x87cb2768) étoiles sur 5 Most useful reference on MDX available 17 mai 2014
Par René Berends - Publié sur Amazon.com
Format: Format Kindle Achat vérifié
Most useful reference on MDX available. Most samples are applicable to your SSAS projects directly. Clear explanation on theory behind and when and why to use a specific MDX pattern.
Ces commentaires ont-ils été utiles ? Dites-le-nous