|
|
Fast Track to MDX Mark Whitehorn, Robert Zare and Mosha Pasumansky Microsoft's Analysis Manager makes OLAP cubes incredibly easy to build and deploy. However the real power of OLAP lies in its ability to help you solve real-life business problems; to release that power you need to use the language that controls the cubes and allows them to be queried. That language is MDX (Multi Dimensional eXpressions). Fast Track to MDX gives you all the necessary background to let you to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems.
|
|
|
Microsoft Analysis Solutions: OLAP and Data Mining with Microsoft Analysis
Services by Thomsen & Spofford A much-needed user manual for Microsoft's groundbreaking OLAP and data mining tool. This up-to-date user guide covers the major new release of Microsoft OLAP Services, now called Microsoft Analysis Services--the technology that made online data analysis widely available for application developers. A sequel to our successful Microsoft OLAP Solutions, this book provides detailed instructions for installing, using, and managing Microsoft Analysis Services as well as integrating it with other Microsoft data warehouse tools. Coverage of new features includes data mining in analysis services, working with the analysis manager interface, scalability features in analysis servers, and allowing clients to analyze information while disconnected from the server.
|
|
|
MDX Solutions: With Microsoft SQL Server Analysis Services
by Spofford A hands-on tutorial on building and using multidimensional data warehouses The SQL query language is used to access data in most simple databases. But for multidimensional (or OLAP) data warehouses, Microsoft developed MDX. The MDX query language has become essential know-how for developers and users alike, whether for data warehouses or for budgeting and planning systems. This tutorial/reference guide shows developers and users how to use MDX to access and analyze data for decision support. Both the standard language and Microsoft's own extensive additions to MDX are explained. |
|
|
Microsoft SQL Server 2000 Analysis Services Step by Step by Reed
Jacobson OLAP SERVICES FUNDAMENTALS is the fast, complete self-training course to online analytical processing (OLAP)-from the premier provider of OLAP training. It's designed to quickly show you why multidimensional data cubes are such a powerful, popular analysis method, and teach you the pitfalls and design strategies behind using OLAP techniques. The content of the book spans a full five days of instructor-led training, including 2.5 days of in-depth introduction to OLAP, 1.5 days of OLAP solutions and advanced concepts, and one day to investigate the Microsoft Excel for OLAP Client. All in all, it's the fastest way to become fully conversant with Microsoft OLAP Services and the solutions you can build with them.
|
|
|
Microsoft OLAP Unleashed by Peterson, et al Microsoft OLAP Unleashed offers professional-level expertise and an in-depth explanation of the latest in multidimensional database management. It contains an entire section on MDX, the programming language of OLAP. MS OLAP Unleashed details real-world uses, how to prepare data, and how to implement an OLAP system. Topics include preparing data, creating cubes, using PivotTable Service, OLAP programming, using Excel as client, server security, real-world examples, managing a data warehouse MDX reference, and system.
|
|
|
Microsoft® SQL
Server™ 2000 Resource Kit Create, maintain, and optimize powerful database applications for SQL Server™ 2000, a key Microsoft® .NET Enterprise Server, with expertise from those who know the technology best—the SQL Server 2000 product team and Microsoft Consulting Services. This essential kit is packed full of technical details, tools, and utilities to help you maximize the productivity of your enterprise systems, create efficient database applications, and tune the performance of your servers and databases. The MICROSOFT SQL SERVER 2000 RESOURCE KIT includes information about core functionality and new features of SQL Server 2000, plus a CD-ROM full of unique tools and samples. It also covers vital topics such as data warehousing, security, failover clustering, scalability, XML, and digital dashboards. This powerhouse reference is the essential resource for every SQL Server user who seeks maximum performance from SQL Server 2000. ANALYSIS SERVICES: Get practical solutions to real-world business problems using OLAP cubes, Multidimensional Expressions (MDX), data mining, and data access technologies. |
Other Microsoft OLAP books, which I didn't read, so I cannot recommend, but they do exist:
- A Practical Guide to Microsoft(R) OLAP Server by John Shumate
- Microsoft SQL Server OLAP Developer's Guide by William C. Amo
- SQL Server Developer's Guide to OLAP with Analysis Services by Mike Gunderloy, Tim Sneath
- Data Warehouse Und OLAP Mit Microsoft by Gerhard Brosius
- Professional SQL Server 2000 Data Warehousing with Analysis Services by Robert Skoglund etc
- Professional Data Warehousing with SQL Server 7.0 and OLAP Services by Sakhr Youness
- Unlocking OLAP With SQL Server 7 and Excel 2000 by Wayne S. Freeze