Micro Excel 2013: Building Data Models with PowerPivot

Your guide to quickly turn data into rests. Transform your skills, data, and business—and create your own BI solutions using ware you already know and love: Micro 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 meaningf information and on-the-job rests—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 manipate large data sets, often in millions of rows
Perform simple-to-sophisticated calcations and what-if analysis
Create complex reporting systems with data modeling and Data Analysis Expressions
Share your rests effortlessly across your organization using Micro 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 CALCATE
Using hierarchies
Using Power View
Shaping the reports
Performing date calcations in DAX
Using advanced DAX
Using DAX as a query language
Automating operations using VBA
Comparing Excel and SQL Server Analysis Services



Название: Micro Excel 2013: Building Data Models with PowerPivot
Автор: Ferrari A., Russo M.
Издательство: Micro Press
Год: 2013
Страниц: 512
ISBN: 978-0-7356-7634-3
Формат: PDF
Размер: 64 Мб
Язык: english