Practical PowerPivot & DAX Formulas for Excel 2010 (Database & ERP - OMG)

3.5 avg rating
( 12 ratings by Goodreads )
 
9780071746854: Practical PowerPivot & DAX Formulas for Excel 2010 (Database & ERP - OMG)

250 + ready-to-use, powerful DAX formulas

Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide.

  • Build pivot tables and charts with PowerPivot for Excel
  • Import information from Access, Excel, data feeds, SQL Server, and other sources
  • Organize and format BI reports using the PowerPivot Field List
  • Write DAX formulas that filter, sort, average, and denormalize data
  • Construct complex DAX formulas from statistical, math, and date functions
  • Compare current and past performance using date and time intelligence
  • Handle non-additive numbers, non-numeric values, and running totals
  • Develop complete self-service and sharable BI solutions in a few minutes

Download the source code from www.mhprofessional.com/computingdownload

"synopsis" may belong to another edition of this title.

About the Author:

Art Tennick has worked in relational database design and SQL queries for more than 20 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Art is the author of Practical MDX Queries for Microsoft SQL Server Analysis Services 2008. His website is www.MrCube.net.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Tennick, Art
Published by McGraw-Hill Education (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Quantity Available: 14
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education, 2010. PAP. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # CM-9780071746854

More Information About This Seller | Ask Bookseller a Question

Buy New
17.29
Convert Currency

Add to Basket

Shipping: 2.80
Within United Kingdom
Destination, Rates & Speeds

2.

Art Tennick
Published by McGraw-Hill Education (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Paperback First Edition Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2010. Paperback. Book Condition: New. book. Bookseller Inventory # 0071746854

More Information About This Seller | Ask Bookseller a Question

Buy New
16.41
Convert Currency

Add to Basket

Shipping: 5.08
From U.S.A. to United Kingdom
Destination, Rates & Speeds

3.

Arthur D. Tennick
Published by McGraw-Hill Education - Europe, United States (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Paperback Quantity Available: 10
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2010. Paperback. Book Condition: New. Language: English . Brand New Book. This title provides 250+ ready-to-use, powerful DAX formulas. Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide. Build pivot tables and charts with PowerPivot for Excel. Import information from Access, Excel, data feeds, SQL Server, and other sources. Organize and format BI reports using the PowerPivot Field List. Write DAX formulas that filter, sort, average, and denormalize data. Construct complex DAX formulas from statistical, math, and date functions. Compare current and past performance using date and time intelligence. Handle non-additive numbers, non-numeric values, and running totals. Develop complete self-service and sharable BI solutions in a few minutes Download the source code from our associated website. Bookseller Inventory # AA39780071746854

More Information About This Seller | Ask Bookseller a Question

Buy New
24.50
Convert Currency

Add to Basket

Shipping: FREE
Within United Kingdom
Destination, Rates & Speeds
International Edition
International Edition

4.

TENNICK
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Soft cover Quantity Available: > 20
International Edition
Seller
University Bookstore
(DELHI, DELHI, India)
Rating
[?]

Book Description 2010. Soft cover. Book Condition: New. This book is BRAND NEW Soft cover International edition with black and white printing. ISBN number & cover page may be different but contents identical to the US edition word by word. Book is in English language. Bookseller Inventory # UN-TM-IN-338

More Information About This Seller | Ask Bookseller a Question

Buy New
13
Convert Currency

Add to Basket

Shipping: 11.67
From India to United Kingdom
Destination, Rates & Speeds

5.

Arthur D. Tennick
Published by McGraw-Hill Education - Europe, United States (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Paperback Quantity Available: 10
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2010. Paperback. Book Condition: New. Language: English . Brand New Book. This title provides 250+ ready-to-use, powerful DAX formulas. Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide. Build pivot tables and charts with PowerPivot for Excel. Import information from Access, Excel, data feeds, SQL Server, and other sources. Organize and format BI reports using the PowerPivot Field List. Write DAX formulas that filter, sort, average, and denormalize data. Construct complex DAX formulas from statistical, math, and date functions. Compare current and past performance using date and time intelligence. Handle non-additive numbers, non-numeric values, and running totals. Develop complete self-service and sharable BI solutions in a few minutes Download the source code from our associated website. Bookseller Inventory # AA39780071746854

More Information About This Seller | Ask Bookseller a Question

Buy New
25.39
Convert Currency

Add to Basket

Shipping: FREE
Within United Kingdom
Destination, Rates & Speeds

6.

Tennick, Art
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Quantity Available: > 20
Seller
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2010. PAP. Book Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9780071746854

More Information About This Seller | Ask Bookseller a Question

Buy New
19.79
Convert Currency

Add to Basket

Shipping: 7.31
From U.S.A. to United Kingdom
Destination, Rates & Speeds

7.

Art Tennick
Published by McGraw-Hill Education 2010-09-01, Emeryville, Calif. :|London (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
New paperback Quantity Available: > 20
Seller
Blackwell's
(Oxford, OX, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education 2010-09-01, Emeryville, Calif. :|London, 2010. paperback. Book Condition: New. Bookseller Inventory # 9780071746854

More Information About This Seller | Ask Bookseller a Question

Buy New
27.99
Convert Currency

Add to Basket

Shipping: FREE
Within United Kingdom
Destination, Rates & Speeds

8.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071746854 ISBN 13: 9780071746854
New PAPERBACK Quantity Available: 1
Seller
Booklot COM LLC
(Philadelphia, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0071746854. Bookseller Inventory # Z0071746854ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
26.86
Convert Currency

Add to Basket

Shipping: 4.61
From U.S.A. to United Kingdom
Destination, Rates & Speeds

9.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Quantity Available: 1
Seller
Ohmsoft LLC
(Lake Forest, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. Book Condition: Brand New. Ships from USA. FREE domestic shipping. Bookseller Inventory # 0071746854

More Information About This Seller | Ask Bookseller a Question

Buy New
24.40
Convert Currency

Add to Basket

Shipping: 7.66
From U.S.A. to United Kingdom
Destination, Rates & Speeds

10.

Tennick, Art
Published by McGraw-Hill Education (2010)
ISBN 10: 0071746854 ISBN 13: 9780071746854
New Quantity Available: 1
Seller
Nearfine Books
(Brooklyn, NY, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2010. Book Condition: new. Shiny and new! Expect delivery in 2-3 weeks. Bookseller Inventory # 9780071746854-1

More Information About This Seller | Ask Bookseller a Question

Buy New
29.32
Convert Currency

Add to Basket

Shipping: 4.15
From U.S.A. to United Kingdom
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book