Practical PowerPivot & DAX Formulas for Excel 2010
Authors: Tennick, Art
ISBN-13: 978-0-07-174685-4
ISBN-10: 0071746854
©2011 | 1st Edition | 448 pages , Softcover
Status: September 2010
Price: US$ 39.99
Author’s Site | Learn More
Extract actionable BI using Excel 2010 PowerPivot and DAX language
Featuring 200 ready-to-use DAX queries, Practical PowerPivot & DAX Queries for Excel 2010 shows Office and Excel power users how to take advantage of DAX (Data Analysis Expressions)—the new standard language for extracting BI within Excel. An entire section shows how to create tables, pivot tables, and PowerPivot tables in Excel. You can then progress to writing DAX queries and formulas to harness the power of BI.
This solutions-based guide contains more than 200 DAX queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:
- Query: Introduction and description of query and its use
- Syntax: Complete DAX syntax
- Result: Screen shot showing the data returned in an Excel 2010 pivot table
- Analysis: Analysis of the results and tips for customization
Practical PowerPivot & DAX Queries for Excel 2010
- Includes 200+ ready-to-use, easily customizable DAX queries, all available for download
- Features a practical and hands-on approach with a minimum of difficult concepts and theory
- Explains how to visualize actionable BI
- Helps to dramatically improve analysis and decision-making skills
About the Author
Art Tennick (Brighton, UK) has worked in relational database design and SQL queries for over 20 years. He has been involved in multidimensional database design, cubes, data mining, and DMX and MDX queries for 10 years. His experience in Excel spans 20 years. Based in the UK, he has been a software consultant, trainer, and writer for some 25 years. Recently, he has worked with several major retail and banking corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2010. This is his 20th book and he has also written over 300 articles for computer magazines in the USA, the UK, and Ireland. His web site is www.MrCube.net.
Review
1. SciTech Book News, February 2011 Issue
Beginning with a foreword by Thierry D’hers, one of the lead designers of this new Microsoft Business Intelligence software, this work provides definitive instruction in the basic use of PowerPivot and the companion scripting language DAX. This software allows business users to access enterprise level, company wide information sources from their desktop installations of the Excel spreadsheet application without the help of their IT department yet within a controlled and connected data pool. The first half of this guide is a reference that describes each of the capabilities of the plug-in within the Excel environment with a screen shot and step-by-step instructions. The second section provides over 250 DAX formulas for extracting specific types of data and reports from the PivotPoint/Excel environment. DAX formulas as well as sample Excel data used in this work are available online. Tennick is an expert in database design and Microsoft’s SQL server. (Annotation ©2011 Book News Inc. Portland, OR)
Related Titles
Table of Contents
Part I: PowerPivot Fundamentals
Chapter 1 PowerPivot: Quick Start
Chapter 2 PowerPivot: Overview
Chapter 3 PowerPivot: In-depth
Chapter 4 DAX: Overview
Chapter 5 Pivot Tables and Pivot Charts: Overview
Part II: DAX
Chapter 6 Fundamental Functions: Filter, Logical, and Miscellaneous Functions
Chapter 7 Aggregate Functions: Statistical Functions and SUM()/SUMX() Functions
Chapter 8 Date & Time Functions 1/2: Basic Functions
Chapter 9 Date & Time Functions 2/2: Time Intelligence Functions
Chapter 10 Text Functions
Chapter 11 Math & Trig Functions
Part III: PowerPivot and DAX Applied
Chapter 12 A Few Ideas: PowerPivot and DAX Solutions
Part IV: Appendices
Appendix A SQL Queries for PowerPivot
Appendix B MDX Queries for PowerPivot
Appendix C DMX Queries for PowerPivot
