Professional SQL Server Analysis Services 2005 with MDX - Sivakumar Harinath, Stephen R. Quinn

Professional SQL Server Analysis Services 2005 with MDX

Buch | Softcover
864 Seiten
2006
Wrox Press (Verlag)
978-0-7645-7918-9 (ISBN)
46,55 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
Shows how Analysis Services and MDX can be used to build data warehouses and multidimensional databases. This book describes the development processes for building dimensions and cubes from various data sources. It demonstrates a variety of techniques in real-world scenarios and shows how MDX can be used for analysis of business problems.
* Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases * The authors then describe the development processes for building dimensions and cubes from various data sources * Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems * Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

Sivakumar Harinath was born in Chennai, India. Siva has a Ph.D. in Computer Science from the University of Illinois at Chicago. His thesis title was: "Data Management Support for Distributed Data Mining of Large Datasets over High Speed Wide Area Networks." Siva has worked for Newgen Software Technologies (P) Ltd., IBM Toronto Labs, Canada, and has been at Microsoft since February of 2002. Siva started as a Software Design Engineer in Test (SDET) in the Analysis Services Performance Team and is currently an SDET Lead for Analysis Services 2005. Siva's other interests include high performance computing, distributed systems and high speed networking. Siva is married to Shreepriya and had twins Praveen and Divya during the course of writing this book. His personal interests include travel, games/sports (in particular, Chess, Carrom, Racquet Ball, Board games) and Cooking. You can reach Siva at sivakumar.harinath@microsoft.com Stephen Quinn was born in San Luis Obispo, California. Stephen has a Masters degree (1988) in Cognitive Psychology from California State University, Chico and is scheduled to receive his Masters of Business Administration (MBA) from the University of Washington, Seattle, in June 2006. Stephen is married to Katherine and is raising his daughter, Anastasia. He has been in most roles common to the R&D environment i.e., software developer, technical writer, technical support specialist and several quality assurance roles. Stephen has published some 20 articles in the magazines Byte, InfoWorld and Datamation. With 15+ years of software experience; Stephen has worked the last 8 years at Microsoft; most recently as a Technical Writer in SQL User Education and before that, for several years as Test Manager in the SQL Business Intelligence Unit. You can reach Stephen at srq@portfolioeffect.com.

Acknowledgments. Introduction. Part One: Introduction. Chapter 1: Introduction to Data Warehousing and Analysis Services 2005. Chapter 2: First Look at Analysis Services 2005. Chapter 3: Introduction to MDX. Chapter 4: Working with Data Sources and Data Source Views. Chapter 5: Dimension Design. Chapter 6: Cube Design. Part Two: Advanced Topics. Chapter 7: Advanced Topics in MDX. Chapter 8: Advanced Dimension Design. Chapter 9: Advanced Cube Design. Chapter 10: Extending MDX using External Functions. Part Three: Administration, Performance Tuning Integration. Chapter 11: Updating Your UDM Data. Chapter 12: Administering Analysis Services. Chapter 13: Performance Optimization. Chapter 14: Data Mining. Chapter 15: Analyzing Cubes using Office Client Components. Chapter 16: Integration Services. Part Four: Scenarios. Chapter 17: Reporting Services. Chapter 18: Designing Real-Time Cubes. Chapter 19: Securing Your Data in Analysis Services. Appendix: MDX Function and Operator Reference. Index.

Erscheint lt. Verlag 30.5.2006
Zusatzinfo Illustrations
Sprache englisch
Maße 187 x 236 mm
Gewicht 1206 g
Einbandart Paperback
Themenwelt Informatik Datenbanken SQL Server
Informatik Office Programme Outlook
ISBN-10 0-7645-7918-5 / 0764579185
ISBN-13 978-0-7645-7918-9 / 9780764579189
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch (2018)
Carl Hanser (Verlag)
40,00
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
49,90