Picture 1 of 2
Picture 1 of 2
Definitive Guide to DAX, The: Business intelligence with ... by Ferrari, Alberto
8M+ feedback. Millions of books, dvds & more in stock!
£20.99
ApproximatelyEUR 25.17
Condition:
Very Good
A book that has been read and does not look new, but is in excellent condition. No obvious damage to the book cover, with the dust jacket (if applicable) included for hard covers. No missing or damaged pages, no creases or tears, no underlining or highlighting of text, and no writing in the margins. Some identifying marks on the inside cover, but this is minimal. Very little wear and tear. See the seller’s listing for full details and description of any imperfections.
7 available9 sold
Postage:
Doesn't post to United States.
Located in: GB, United Kingdom
Delivery:
Varies
Returns:
30 days return. Buyer pays for return postage.
Payments:
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:303409508452
Item specifics
- Condition
- Title
- Definitive Guide to DAX, The: Business intelligence with Micro...
- Book Title
- Definitive Guide to DAX, The: Business intelligence with Micro...
- ISBN
- 073569835X
- EAN
- 9780735698352
- Type
- Textbook
- Binding
- Paperback / softback
- Date of Publication
- 20151029
- Publication Name
- N/A
- Release Title
- Definitive Guide to DAX, The: Business intelligence with Micro...
- Artist
- Ferrari, Alberto
- Brand
- N/A
- Colour
- N/A
- Format
- Paperback
- Language
- English
- Subject Area
- Computing: Professional & Programming
- Publisher
- Microsoft Press,U.S.
- Subject
- Computer & IT
About this product
Product Identifiers
Publisher
Microsoft Press,U.S.
ISBN-10
073569835x
ISBN-13
9780735698352
eBay Product ID (ePID)
216579315
Product Key Features
Subject
Computer & IT
Language
English
Type
Textbook
Subject Area
Computing: Professional & Programming
Format
Paperback
Dimensions
Height
229mm
Width
188mm
Weight
958g
Additional Product Features
Date of Publication
13/10/2015
Pagination
592
Place of Publication
Redmond
Country of Publication
United States
First Published
2015
Table of Contents
Foreword xviiIntroduction xixChapter 1: What is DAX? 1Understanding the data model 1Understanding the direction of a relationship 3DAX for Excel users 5Cells versus tables 5Excel and DAX: Two functional languages 8Using iterators 8DAX requires some theory 8DAX for SQL developers 9Understanding relationship handling 9DAX is a functional language 10DAX as a programming and querying language 11Subqueries and conditions in DAX and SQL 12DAX for MDX developers 13Multidimensional vs. Tabular 13DAX as a programming and querying language 13Hierarchies 14Leaf-level calculations 15Chapter 2: Introducing DAX 17Understanding DAX calculations 17DAX data types 18DAX operators 21Understanding calculated columns and measures 22Calculated columns 22Measures 23Variables 26Handling errors in DAX expressions 26Conversion errors 26Arithmetical operations errors 27Intercepting errors 30Formatting DAX code 32Common DAX functions 35Aggregate functions 35Logical functions 37Information functions 39Mathematical functions 39Trigonometric functions 40Text functions 40Conversion functions 41Date and time functions 42Relational functions 42Chapter 3: Using basic table functions 45Introducing table functions 45EVALUATE syntax 47Using table expressions 50Understanding FILTER 51Understanding ALL, ALLEXCEPT, and ALLNOBLANKROW 54Understanding VALUES and DISTINCT 58Using VALUES as a scalar value 59Chapter 4: Understanding evaluation contexts 61Introduction to evaluation contexts 62Understanding the row context 66Testing your evaluation context understanding 67Using SUM in a calculated column 67Using columns in a measure 68Creating a row context with iterators 69Using the EARLIER function 70Understanding FILTER, ALL, and context interactions 74Working with many tables 77Row contexts and relationships 78Filter context and relationships 80Introducing VALUES 84Introducing ISFILTERED, ISCROSSFILTERED 85Evaluation contexts recap 88Creating a parameter table 89Chapter 5: Understanding CALCULATE and CALCULATETABLE 93Understanding CALCULATE 93Understanding the filter context 95Introducing CALCULATE 98CALCULATE examples 101Filtering a single column 101Filtering with complex conditions 106Using CALCULATETABLE 109Understanding context transition 111Understanding context transition with measures 114How many rows are visible after context transition? 116Understanding evaluation order of context transition 117Variables and evaluation contexts 118Understanding circular dependencies 119CALCULATE rules 122Introducing ALLSELECTED 123Understanding USERELATIONSHIP 125Chapter 6: DAX examples 129Computing ratios and percentages 129Computing cumulative totals 132Using ABC (Pareto) classification 136Computing sales per day and working day 143Computing differences in working days 150Computing static moving averages 151Chapter 7: Time intelligence calculations 155Introduction to time intelligence 155Building a Date table 156Using CALENDAR and CALENDARAUTO 157Working with multiple dates 160Handling multiple relationships to the Date table 161Handling multiple Date tables 162Introduction to time intelligence 164Using Mark as Date Table 166Aggregating and comparing over time 168Year-to-date, quarter-to-date, month-to-date 168Computing periods from prior periods 171Computing difference over previous periods 174Computing the moving annual total 175Closing balance over time 178Semi-additive measures 178OPENINGBALANCE and CLOSINGBALANCE functions 184Advanced time intelligence 188Understanding periods to date 189Understanding DATEADD 191Understanding FIRSTDATE and LASTDATE 196Understanding FIRSTNONBLANK and LASTNONBLANK 199Using drillthrough with time intelligence 200Custom calendars 200Working with weeks 201Custom year-to-date, quarter-to-date, month-to-date 204Computing over noncontiguous periods 206Custom comparison between periods 210Chapter 8: Statistical functions 213Using RANKX 213Common pitfalls using RANKX 216Using RANK.EQ 219Computing average and moving average 220Computing variance and
Item description from the seller
Business seller information
WORLD OF BOOKS LIMITED
Debbie Nicholl
Mulberry House
Woods Way
Goring-by-sea
West Sussex
BN12 4QY
United Kingdom
Value added tax number:
- DE 281042328
- EL 996857788
- ES N8267548I
- FR 27823676960
- GB 922696893
- IT 00185819992
Trade registration number:
- 06437594
I certify that all my selling activities will comply with all EU laws and regulations.
CRN Number:
- 06437594
Registered as a business seller
Seller Feedback (13,073,423)
This item (3)
All items (13,073,423)
n***5 (934)- Feedback left by buyer.
More than a year ago
Verified purchase
Perfect
c***r (239)- Feedback left by buyer.
More than a year ago
Verified purchase
Book arrived promptly in excellent condition. Great service. Many thanks.
a***2 (413)- Feedback left by buyer.
More than a year ago
Verified purchase
Thanks
c***u (182)- Feedback left by buyer.
Past month
Verified purchase
Excellent service
n***e (663)- Feedback left by buyer.
Past month
Verified purchase
Brilliant ,thank you
4***i (369)- Feedback left by buyer.
Past month
Verified purchase
Good value and condition. Prompt delivery.
More to explore:
- The Intelligent Investor Business, Economics & Industry Non-Fiction Hardcover Books,
- The Intelligent Investor Business, Economics & Industry Non-Fiction Hardcover Books in English,
- The Intelligent Investor Business, Economics & Industry Paperback Fiction & Non-Fiction Books,
- The Intelligent Investor Business, Economics & Industry Paperback Fiction & Non-Fiction Books in English,
- The Intelligent Investor Business, Economics & Industry Management Techniques Non-Fiction Paperback Fiction & Books,
- Biology Study Guide School Textbooks & Study Guides,
- Workbook School Textbooks & Study Guides,
- English School Textbooks & Study Guides,
- School Textbooks & Study Guides,
- Science School Textbooks & Study Guides