You'll explore everything that Analysis Services 2008 has to offer and examinethe important features of this product with the help of step–by–step instructionson building multi–dimensional databases. Within each chapter, you will not only learn how to use the features, but you'll also discover more about the features at a user level and what happens behind the scenes to make things work. You'll get a look at how features really operate, enabling you to understand how to use them to their full potential. Plus, you'll sharpen your ability to debug problems that you might not have been able to otherwise.
What you will learn from this book
Who this book is for
This book is for database and data warehouse developers and administrators interested in exploiting the power of business intelligence and leveraging the SQL Server 2008 tool set.
Wrox Professional guides are planned and written by working programmers to meet the real–world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Part I: Introduction.
Chapter 1: Introduction to Data Warehousing and SQL Server 2008 Analysis Services.
Chapter 2: First Look at Analysis Services 2008.
Chapter 3: Introduction to MDX.
Chapter 4: Working with Data Sources and Data Source Views.
Chapter 5: Dimension Design.
Chapter 6: Cube Design.
Chapter 7: Administering Analysis Services.
Part II: Advanced Topics.
Chapter 8: Advanced Dimension Design.
Chapter 9: Advanced Cube Design.
Chapter 10: Advanced Topics in MDX.
Chapter 11: Extending MDX Using External Functions.
Chapter 12: Data Writeback.
Part III: Advanced Administration and Performance Optimization.
Chapter 13: Programmatic and Advanced Administration.
Chapter 14: Designing for Performance.
Chapter 15: Analyzing and Optimizing Query Performance.
Part IV: Integration with Microsoft Products.
Chapter 16: Data Mining.
Chapter 17: Analyzing Cubes Using Microsoft Office Components.
Chapter 18: Using Data Mining with Office 2007.
Chapter 19: Integration Services.
Chapter 20: Reporting Services.
Part V: Scenarios.
Chapter 21: Designing Real–Time Cubes.
Chapter 22: Securing Your Data in Analysis Services.
Chapter 23: Inventory Scenarios.
Chapter 24: Financial Scenarios.
Chapter 25: Web Analytics.
Appendix A: MDX Functions.
Matt Carroll is currently a Senior Development Lead on the SQL Server Integration Services team at Microsoft. Prior to this, he spent 10 years working on the SQL Server Analysis Services team as a developer and then development lead. He's presented on Analysis Services at VSLive and compiled and edited the whitepaper "OLAP Design Best Practices for Analysis Services 2005."
Sethu Meenakshisundaram has more than 20 years of Enterprise System Software Development experience. Sethu spent a good portion of his career at Sybase Inc. in architecture, development, and management building world class OLTP and OLAP Database Systems. Sethu was instrumental in developing and leading highly complex clustered systems of Adaptive Server Enterprise. Early in the '90s, Sethu developed a version of Sybase Adaptive Server running on the Windows platform. Most recently he was an Architect in the SQL Server BI team driving technology and partner strategy. Prior to Microsoft, Sethu managed all of Server development as Senior Director at Sybase including building teams in the U.S., India, and China. He is currently a Vice President in charge of Technology Strategy at SAP Labs, USA.
Rob Zare is a program manager on the SQL Server development team. He's worked on the product since shortly before the first service pack of SQL Server 2000. During that time, he's focused primarily on Analysis Services, though for the next major release of SQL Server he'll be focused on Integration Services. He is the co–author of Fast Track to MDX and regularly speaks at major technical conferences around the world.
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co–author of "SQL Server 2000 Data Warehousing with Analysis Services" and "Transforming Healthcare through Information [Ed. Joan Ash] (2008)". In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
Utilizziamo i cookie di profilazione, anche di terze parti, per migliorare la navigazione, per fornire servizi e proporti pubblicità in linea con le tue preferenze. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie clicca qui. Chiudendo questo banner o proseguendo nella navigazione acconsenti all’uso dei cookie.