Автор: Harinath Название: Professional Microsoft SQL Server 2012 Analysis Services with MDX ISBN: 1118101103 ISBN-13(EAN): 9781118101100 Издательство: Wiley Рейтинг: Цена: 47520.00 T Наличие на складе: Поставка под заказ. Описание: Professional SQL Server 2011 Analysis Services with MDX and DAX shows readers how to build sophisticated business intelligence solutions using SQL Server Analysis Services, along with SQL Server Integration and Reporting Services. The authors begin with an overview showing how Analysis Services can be used to build data warehouses and multi-dimensional databases. They then quickly move to a tutorial that describes the development process for building dimensions and cubes from various data sources. The authors show how MDX and the more simplified version of MDX, DAX, can be used to query databases to provide sophisticated analysis of business problems. They will demonstrate a variety of techniques against real-world case scenarios. They will also show how Analysis Services can be used with other components of SQL Server, including Integration Services, Reporting Services, and Data Mining to provide comprehensive, end-to-end solutions. The 2011 book will be more than 50% new and revised to cover new features and enhancements, including: Improved integration with Excel and SharePoint 2010 The new DAX language, which is a more simplified, user-friendly version of MDX. PowerPivot, a new tool for performing simplified analysis of data. Integration of Analysis Services with PowerPivot, plus enhancements to PowerPivot, including Key Performance Indicators. The new Business Intelligence Semantic Model (BISM). Significant enhancements to Business Intelligence Development Studio (BIDS) and SQL Server Management Studio (SSMS) A new BI tool, code-named Crescent, that will revolutionize how data is reported. Integration with the Vertipaq engine for improved performance.
Автор: Ferrari Alberto, Russo Marco Название: The Definitive Guide to Dax: Business Intelligence for SQL Server Analysis Services and Excel ISBN: 073569835X ISBN-13(EAN): 9780735698352 Издательство: Неизвестно Рейтинг: Цена: 57470.00 T Наличие на складе: Невозможна поставка. Описание: This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, how DAX behaves differently from other languages, and how to use this knowledge to write fast, robust code. If you want to leverage all of DAX's remarkable power and flexibility, this no-compromise "deep dive" is exactly what you need. Perform powerful data analysis with DAX for Microsoft SQL Server Analysis Services, Excel, and Power BI
Master core DAX concepts, including calculated columns, measures, and error handling
Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions
Perform time-based calculations: YTD, MTD, previous year, working days, and more
Work with expanded tables, complex functions, and elaborate DAX expressions
Perform calculations over hierarchies, including parent/child hierarchies
Use DAX to express diverse and unusual relationships
Measure DAX query performance with SQL Server Profiler and DAX Studio
Казахстан, 010000 г. Астана, проспект Туран 43/5, НП2 (офис 2) ТОО "Логобук" Тел:+7 707 857-29-98 ,+7(7172) 65-23-70 www.logobook.kz
