Download App
ISBN
:
9780071074179
Publisher
:
Tata Mcgraw Hill Education Private Limited
Binding
:
Paperback
Pages
:
476
Year
:
2010
₹
595.0
₹
464.0
Buy Now
Shipping charges are applicable for books below Rs. 101.0
View DetailsEstimated Shipping Time : 5-7 Business Days
View DetailsDescription
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
A Practical Guide to Error-Control Coding Using MATLAB
Yuan Jing
Starts At
6043.0
8512.0
29% OFF
Business Modeling: A Practical Guide to Realizing Business Value
Dave M. Bridgeland
Starts At
3659.0
5154.0
29% OFF
Evolutionary Computation: Toward a New Philosophy of Machine Intelligence
David B. Fogel
Starts At
6807.0
8957.0
24% OFF
Java Server Programming Java Ee5 Black Book, Platinum Ed (With CD)
Kogent Learning Solutions
Starts At
467.0
599.0
22% OFF
Optical Pattern Recognition 17 (Proceedings of SPIE)
David P. Casasent
Starts At
3280.0
4494.0
27% OFF
Simulation Engineering: Build Better Embedded Systems Faster
Jim Ledin
Starts At
14230.0
16547.0
14% OFF
Delivering Digitally: Managing the Transition to the New Knowledge Media
Alastair Inglis
Starts At
7945.0
10454.0
24% OFF
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
Item
Delivery
Unit Price
Quantity
Sub Total
Order Summary