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, ...
Get Practical PowerPivot & DAX Formulas for Excel 2010 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
