Your guide to quickly turn data into results.

NOTE: This book is based on Office Customer Preview; its content and publication date will be updated for final Office 2013 software.

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®

Create Business Intelligence (BI) solutions with the Business Intelligence Semantic Model (BISM) Tabular model—and discover a simpler method for analyzing business data. Led by three BI experts, you'll learn how to use several BISM tools, such as the Vertipaq in-memory storage engine, the DAX programming language, and the semantic model that enables data navigation. Whether you're experienced with the BISM Multidimensional model or a SQL Server developer new to Analysis Services, this book is the ideal way to get started with the BISM Tabular model.

Topics include:

• BISM architecture
• Loading data inside the tabular model
• Basics of the DAX language
• Understanding evaluation contexts
• Querying tabular
• Understanding time intelligence in DAX

This book introduces PowerPivot in Excel 2010 to power users and data analysts who want to give their data meaning by creating their own Business Intelligence models. This is a book for advanced users of Excel, and not for programmers-- PowerPivot, in its 1.0 version, will not be usable as a development tool.