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: <ul>
<li>Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers </li> <li>Create dimensions and measure groups to build, browse, and modify OLAP cubes</li> <li>Design objects to handle unique financial analysis requirements</li> <li>Improve query performance with aggregations and user hierarchies </li> <li>Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques </li> <li>Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes</li> <li>Manage role-based security and restrict data access</li> <li>Deploy and maintain a database in a production environment</li> </ul>
CD features <ul>
<li>All practice exercises and answer files</li> <li>Fully searchable eBook</li> </ul>
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Computers & Technology

Misner, Stacia

Consulting, Hitachi

Jacobsen, Reed

Computer Science

Microsoft Press

Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: <ul>
<li>Construct and execute MDX queries</li> <li>Work with tuples, sets, and expressions</li> <li>Build complex sets to retrieve the exact data users need</li> <li>Perform aggregation functions and navigate data hierarchies</li> <li>Assemble time-based business metrics</li> <li>Customize an Analysis Services cube through the MDX script</li> <li>Implement dynamic security to control data access</li> <li>Develop MDX-driven reports in SQL Server Reporting Services 
</li> </ul>
CD features: <ul>
<li>Practice exercises</li> <li>Database and code samples</li> <li>Fully searchable eBook</li> </ul>

Microsoft® SQL Server® 2008 MDX Step by Step

Smith, Bryan C.

Clay, C Ryan

Programming Languages

See the best price to sell, buy, or rent books by Consulting, Hitachi. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Consulting, Hitachi