Trade in SQL Server 2005 Analysis Services Step by Step Book/CD Package (Step by Step (Microsoft)) for an Amazon.co.uk gift card of up to £0.30, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more
Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization.
Discover how to:
Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers
Create dimensions and measure groups to build, browse, and modify OLAP cubes
Design objects to handle unique financial analysis requirements
Improve query performance with aggregations and user hierarchies
Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques
Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes
Manage role-based security and restrict data access
Deploy and maintain a database in a production environment
{"itemData":[{"priceBreaksMAP":null,"buyingPrice":20.15,"ASIN":"0735621993","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":29.4,"ASIN":"0735624054","isPreorder":0},{"priceBreaksMAP":null,"buyingPrice":22.71,"ASIN":"0735622507","isPreorder":0}],"shippingId":"0735621993::8ftWUgyK81bCvj0zd7oZ6MKItu7emTU3QcdUem0R1fCdHp9%2F5AYqcser%2BOUMeoGupSlEOCNsqNw%2Bk9tHgJKwf6KbAcCzstEz,0735624054::MJVA6qsAsvSbF16aOA13l95qYkMbTa4QhIDCEbUB2yiS5Jy4I%2FyT7MO6KvA9h35JwmX3YWqoywg0bBdTi9LoEsREW0x3PKnN,0735622507::cZLIPH1T6GTRTjHHQFZ977eTtyC9seudq5Ut2HTjk6SftLYQ30tM%2Bt0YMAADxbGe1ZPePZ6dwWHV0k1%2F%2Fz78ebmeDa52%2BxpF","sprites":{"addToWishlist":["wl_one","wl_two","wl_three"],"addToCart":["s_addToCart","s_addBothToCart","s_add3ToCart"],"preorder":["s_preorderThis","s_preorderBoth","s_preorderAll3"]},"currenyCode":"GBP","shippingDetails":{"xz":"same","yz":"same","xy":"same","xyz":"same"},"tags":["x","y","z"],"strings":{"addToWishlist":[null,null,null],"addToCart":["Add to Basket","Add both to Basket","Add all three to Cart"],"showDetailsDefault":"Show availability and delivery details","shippingError":"An error occurred, please try again","hideDetailsDefault":"Hide availability and delivery details","priceLabel":["Price:","Price For Both:","Price For All Three:"],"preorder":["Pre-order this item","Pre-order both items","Pre-order all three items"]}}
Reed Jacobson is a senior architect in Hitachi Consulting’s Business Intelligence practice. He has authored several training courses and books, including Microsoft SQL Server 2000 Analysis Services Step by Step.
Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.
Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services
First Sentence
Microsoft SQL Server 2005 Analysis Services is a tool to help you implement business intelligence (BI) in your organization. Read the first page
I liked the book for its extensive use of step-by-step tutorials but was disappointed to find nothing about data-mining, which is very much present in of Microsoft's official SSAS basic 3 day course, moc2791.
This book is a good beginners guide to SSAS 2005. It covers the key elements of the software and how to use them. It has a nice tutorial set to demonstrate the features that the book describes. The only downside is that the book isn't very indepth. Many of the features need greater description and detail. But as a beginners guide it is very good.
This book delivers exactly what the title suggests it does, it is an excellent step by step guide, there is lots of 'how to' exercises throughout each chapter. Within 3 days of reading I had an understanding of the fundemental principals of an OLAP database and how AS 2005 fits that model, and within 5 days was able to start bringing together that knowledge to work with some degree of confidence with AS 2005 and the Business Intelligence Studio. If you're new to AS2005 and OLAP I would consider this as required reading. If you're just new to AS 2005 it proves as a very good guide as to what is where in the tool set.
