- Shopping Bag ( 0 items )
From Barnes & NobleOur Review
Data cubes. Multidimensional expressions. OLAP. If ever anything sounded hard, it's data analysis. With SQL Server 2000, Microsoft continues its quest to change all that. SQL Server's new Analysis Services is almost easy -- but not quite. Microsoft SQL Server 2000 Analysis Services Step by Step gets you over those final hurdles, with some of the clearest data analysis explanations and instructions we've seen yet.
Every chapter is organized as a lesson, with accompanying files on the CD-ROM. If you're a DBA, you'll learn how to create and manage your Analysis Services database. If you're a business analyst, you'll learn how to transform your spreadsheet models into a form you can scale -- and share -- throughout the enterprise. And if you're a business decision-maker, you'll discover exactly what you can expect from SQL Server 2000's Analysis Services.
You'll find step-by-step coverage of data cubes: imagining them, planning them, designing them, creating, them, processing them, and browsing them. You'll master SQL Server 2000's Dimension Editor, use it to work with star schema, time, and snowflake dimensions, and create real-world cubes for finance, forecasting, and Internet tracking.
Microsoft SQL Server 2000 Analysis Services Step by Step includes a detailed chapter on integrating with Office 2000's analysis components (such as Excel PivotTable reports). There's a full section on Multidimensional Expressions, which transform your large OLAP database into a sophisticated calculation engine. Finally, since you want rapid performance but don't have infinite hardware budgets, the book walks you step by step through optimizing both storage and processing.
This book's authors are professional OLAP and data warehouse trainers. It shows, through the masterful use of analogies and examples. They've figured out exactly how to communicate this stuff. If you're just getting into SQL Server 2000 data analysis, this book's a must.