Microsoft Excel 2013: Building Data Models with PowerPivot
Microsoft Excel 2013: Создание модели данных с помощью PowerPivot
Год выпуска: 2013 Автор: Ferrari A., Russo M. Наличие иллюстраций: Цв. иллюстрации Жанр: Учебник Язык: Английский Издательство: Microsoft Press ISBN: 978-0-7356-7634-3 Формат: PDF Качество: Электронное издание: оригинал-макет Количество страниц: 512 Описание: Your guide to quickly turn data into results. Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You’ll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required!
Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint
Introduction to PowerPivot Using the unique features of PowerPivot Introducing DAX Understanding data models Publishing to SharePoint Loading data Understanding evaluation contexts Understanding CALCULATE Using hierarchies Using Power View Shaping the reports Performing date calculations in DAX Using advanced DAX Using DAX as a query language Automating operations using VBA Comparing Excel and SQL Server Analysis Services