Professional Microsoft SQL Server 2012 Analysis Services With MDX and DAX

by Ronald Pihlgren Sivakumar Harinath, Ronald Pihlgren, Denny Guang-Yeu Lee

Key Features SQL Server Analysis Services is Microsoft's premier toolset for business intelligence. The 2012 release of SQL Server is the most significant since 2005. The new edition of this book is more than 50% new and revised. The authors of this book are key members of the Analysis Services team at Microsoft About the Book: Professional Microsoft SQL Server 2012 AnalysisServices With MDX and DAX SQL Server Analysis Services, along with the MDX and DAXquerylanguages, provides developers with the tools forbuildingfull-scale multi-dimensional database applications. (MDXand themore simplified DAX are query languages formulti-dimensionaldatabases, just as SQL is the standard querylanguage forrelational databases.) These applications support suchcorebusiness functions as budgeting, forecasting, andmarketanalysis. Analysis Services is a complex product that's used in tandemwithSQL Server Integration and Reporting Services, as well asExcel andSharePoint. With SQL Server 2012, Microsoft builds on anew BusinessIntelligence Semantic Model (BISM) that will be thecornerstone ofall Microsoft's BI efforts. PowerPivot will beenhanced withadditional capabilities such as Key PerformanceIndicators (KPIs).Microsoft has also made it simpler to set up andadminsterPowerPivot for SharePoint. For business analysis, Microsoft is adding new BI projecttypesbased on PowerPivot's data model and the Vertipaq engine.BusinessIntelligence Development Studio (BIDS) and SQL ServerManagementStudio (SSMS) will be enhanced to support these newcapabilities.The same tools that PowerPivot added to Excel to workwith the newdata model will be included in BIDS and SSMS. Professional SQL Server 2012 Analysis Services with MDX andDAXshows readers how to build sophisticated businessintelligencesolutions using SQL Server Analysis Services, alongwith SQL ServerIntegration and Reporting Services. The authorsbegin with anoverview showing how Analysis Services can be used tobuild datawarehouses and multi-dimens

1172 pages, Paperback

First published June 26, 2012