O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introduction

PowerPivot and DAX

PowerPivot for Excel 2010 helps you to extract real, actionable Business Intelligence (BI), and increase effective decision making. It’s ideal for the average Excel user—and it’s a non-developer entry point into BI. This is BI for the masses. Furthermore, PowerPivot for Excel is a free download from www.powerpivot.com.

BI is wonderful. However, implementing BI solutions (before PowerPivot) is not for the faint-hearted. Traditionally, the first step is to build a relational star schema database (possibly in SQL Server), and then to construct an SSAS (SQL Server Analysis Services) cube from the star schema. Building a star schema requires an understanding of SQL Server (or Oracle, or DB2, or MySQL), the SQL language, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required