Get to grips with the exciting features and contents of SQL Server Analysis Services 2012 cube development using Packt's new book and eBook!

May 2014 | Cookbooks, Open Source

Packt is pleased to announce the release of SQL Server Analysis Services 2012 Cube Development Cookbook, which provides guidance and information on data cube development techniques, and also the ongoing monitoring and tuning for Analysis Services. This book is available now in print, eBook, Kindle, and selected library formats. The print book is 340 pages long and is competitively priced at $59.99, whilst the eBook and Kindle versions are available for $30.59.

About the authors:

Baya Dewald has been working with Microsoft SQL Server for over 15 years, and with Analysis Services since its debut in 1999. He has architected, developed, and administered databases with millions of users and cubes measured in terabytes. Throughout his career, he has held various certifications, including Microsoft Certified Solution Developer, Microsoft Certified Systems Engineer, and Microsoft Certified Database Administrator. He has managed DBA teams and published over 100 technical articles in SQL Server Magazine, SQL Professional, Tech Target, and InformIT. He has also contributed to several technical books as a co-author and technical reviewer.

Paul Turley is a mentor with SolidQ and is a Microsoft SQL Server MVP. He consults, writes, speaks, teaches, and blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is the director of the Oregon SQL PASS chapter and user group, and the lead author of Professional SQL Server 2012 Reporting Services and 11 other books for Wrox and Microsoft Press. Paul blogs at [url]SqlServerBiBlog.com[/url].

Steve Hughes is a practice lead at Magenic. In his current role, he develops strategy and helps guide data, business intelligence, collaboration, and data integration development using Microsoft technologies, including SQL Server, SharePoint, and BizTalk. He continues to deliver data and business intelligence solutions using these platforms. He has been working with technology for over 15 years, with much of that time spent on creating business intelligence solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable. He also has experience working with a large software company as a service vendor and there received awards for customer satisfaction and engineering excellence. He shares his insights from the field on his blog at http://dataonwheels.wordpress.com.

Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. OLAP (online analytical processing) is a technique for analyzing business data for effective business intelligence.

This practical guide teaches readers how to build business intelligence solutions using Microsoft’s core product—SQL Server Analysis Services. The book covers the traditional multi-dimensional model which has been around for over a decade as well as the tabular model introduced with SQL Server 2012.

Starting with comparing multi-dimensional and tabular models and discussing the values and limitations of each, it then covers the essential techniques for building dimensions and cubes. Following on from this, it introduces the reader to more advanced topics, such as designing partitions and aggregations, implementing security, and synchronizing databases for solutions serving many users.

The book also covers administrative material, such as database backups, server configuration options, and monitoring and tuning performance. It also provides a primer on MultiDimensional eXpressions (MDX) as well as Data Analysis expressions (DAX) languages.

The following are the chapters covered in this book:
Chapter 1: Introduction to Multi-dimensional Data Model Design
Chapter 2: Defining Analysis Services Dimensions
Chapter 3: Creating Analysis Services Cubes
Chapter 4: Extending and Customizing Cubes
Chapter 5: Optimizing Dimension and Cube Processing
Chapter 6: MDX
Chapter 7: Analysis Services Security
Chapter 8: Administering and Monitoring Analysis Services
Chapter 9: Using Tabular Models
Chapter 10: DAX Calculations and Queries
Chapter 11: Performance Tuning and Troubleshooting Tabular Models

Packt Publishing has also released other SQL Server books:
Instant SQL Server Analysis Services 2012 Cube Security
SQL Server 2012 with PowerShell V3 Cookbook

All SQL books are published by Packt Enterprise. Packt Enterprise is a publishing division of Packt Publishing designed to serve the information needs of IT professionals in the enterprise space. Packt Enterprise also publishes on IBM, Java, Microsoft, Citrix, Oracle, Amazon, Google, and SAP technologies.

Anchoring Text – #SQL, #SQL Server Analysis Services, #SQL Server

SQL Server Analysis Services 2012 Cube Development Cookbook
Get to grips with the exciting features and contents of SQL Server Analysis Services 2012 cube development using Packt's new book and eBook

For more information, please visit: Book Page

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software