Alberto Ferrari, Marco Russo

Microsoft Excel 2013 Building Data Models with PowerPivot

Microsoft (R) Excel (R) 2013

• Broschiertes Buch

Produktbeschreibung

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¿

Product Description
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¿

Produktdetails

• Business Skills
• Verlag: Microsoft Press Corp.
• 1st. ed.
• Seitenzahl: 512
• Erscheinungstermin: 15. März 2013
• Englisch
• Abmessung: 228mm x 189mm x 30mm
• Gewicht: 810g
• ISBN-13: 9780735676343
• ISBN-10: 0735676348
• Artikelnr.: 36722366

Autorenporträt

Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.

Inhaltsangabe

Introduction
Chapter 1: Introduction to PowerPivot
Chapter 2: Using the unique features of PowerPivot
Chapter 3: Introducing DAX
Chapter 4: Understanding data models
Chapter 5: Publishing to SharePoint
Chapter 6: Loading data
Chapter 7: Understanding evaluation contexts
Chapter 8: Understanding CALCULATE
Chapter 9: Using hierarchies
Chapter 10: Using Power View
Chapter 11: Shaping the reports
Chapter 12: Performing date calculations in DAX
Chapter 13: Using advanced DAX
Chapter 14: Using DAX as a query language
Chapter 15: Automating operations using VBA
Chapter 16: Comparing Excel and SQL Server Analysis Services
About the Authors