0

My Bag

0.00

Download App

Practical PowerPivot & DAX Formulas for Excel 2010 22.0%OFF

Practical PowerPivot & DAX Formulas for Excel 2010

by Art Tennick

  • ISBN

    :  

    9780071074179

  • Publisher

    :  

    Tata Mcgraw Hill Education Private Limited

  • Binding

    :  

    Paperback

  • Pages

    :  

    476

  • Year

    :  

    2010

595.0

22.0% OFF

464.0

Buy Now

Shipping charges are applicable for books below Rs. 101.0

View Details

Estimated Shipping Time : 5-7 Business Days

View Details

Share it on

  • Description

    take advantage of DAX (Data Analysis Expressions)—the new standard language for extracting BI within the familiar environment of Excel. 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

  • Author Biography

    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. Table of Contents Part I: PowerPivotChapter 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: Appendixes: Queries for PowerPivot Appendix A. SQL Queries for PowerPivot Appendix B. MDX Queries for PowerPivot Appendix C. DMX Queries for PowerPivot Index

Related Items

-

of

  • OFFER

    Practical .NET 2.0 Networking Projects

    Wei-Meng Lee

    Starts At

    314.0

    349.0

    10% OFF

  • OFFER

    Practical JBoss Seam Projects

    Jim Farley

    Starts At

    272.0

    299.0

    9% OFF

  • OFFER

    Practical Data Design

    Michael H. Brackett

    Starts At

    3463.0

    4878.0

    29% OFF

  • OFFER

    A Practical Guide to Error-Control Coding Using MATLAB

    Yuan Jing

    Starts At

    6043.0

    8512.0

    29% OFF

  • OFFER

    Business Modeling: A Practical Guide to Realizing Business Value

    Dave M. Bridgeland

    Starts At

    3659.0

    5154.0

    29% OFF

  • CognitivelyInformed Systems: Utilizing Practical Approaches to Enrich Information Presentation and Transfer

    Eshaa M. Alkhalifa

    Starts At

    7673.0

  • OFFER

    Evolutionary Computation: Toward a New Philosophy of Machine Intelligence

    David B. Fogel

    Starts At

    6807.0

    8957.0

    24% OFF

  • THE SCIENCE OF INFLUENCE

    Kevin Hogan

    Starts At

    295.0

  • OFFER

    Information Storage and Retrieval

    Robert R.l Korfhage

    Starts At

    229.0

    249.0

    8% OFF

  • OFFER

    Windows Vista Secrets

    Paul Thurrott Brian Livingston

    Starts At

    449.0

    599.0

    25% OFF

  • OFFER

    Java Server Programming Java Ee5 Black Book, Platinum Ed (With CD)

    Kogent Learning Solutions

    Starts At

    467.0

    599.0

    22% OFF

  • OFFER

    Medical Imaging 2001: Image Processing

    Milan Sonka

    Starts At

    7732.0

    10593.0

    27% OFF

  • OFFER

    Optical Pattern Recognition 17 (Proceedings of SPIE)

    David P. Casasent

    Starts At

    3280.0

    4494.0

    27% OFF

  • OFFER

    Simulation Engineering: Build Better Embedded Systems Faster

    Jim Ledin

    Starts At

    14230.0

    16547.0

    14% OFF

  • OFFER

    Delivering Digitally: Managing the Transition to the New Knowledge Media

    Alastair Inglis

    Starts At

    7945.0

    10454.0

    24% OFF

  • OFFER

    Network Security,A Hackers Perspective

    Ankit Fadia

    Starts At

    375.0

    399.0

    6% OFF

© 2016, All rights are reserved.

Subscribe to Our Newsletter

 

Are you sure you want to remove the item from your Bag?

Yes

No

Added to Your Wish List

OK

Your Shopping Bag

- 1 Item

null

Item

Delivery

Unit Price

Quantity

Sub Total

Shipping Charges : 0.0 Total Savings        : Grand Total :

Order Summary