Microsoft Excel 2013: Building Data Models with PowerPivot

Купить бумажную книгу и читать

Название: Microsoft Excel 2013: Building Data Models with PowerPivot

Автор: Ferrari A., Russo M.

Издательство: Microsoft Press

Год: 2013

Страниц: 512

ISBN: 978-0-7356-7634-3

Формат: PDF

Размер: 64 Мб

Язык: english

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

Table of Contents

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