-
Seasonal Offer:
This title is part of our Seasonal Offers promotion.
Practical PowerPivot & DAX Formulas for Excel 2010
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £8.50
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Practical PowerPivot & DAX Formulas for Excel 2010 for an Amazon.co.uk gift card of up to £8.50, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Special Offers and Product Promotions
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
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
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.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
This is the second 'PowerPivot' book that I have bought. I have not got past Chapter 4 with the FIRST because there are some sample files either missing or not provided, making it difficult to follow along with the text.
This book is different. There are 15 small sample files (mainly giving some of the SQL) but the big advantage is that the book uses the Microsoft Northwind database and the text is therefore very easy to follow. The pre-Access 2007 (the better) version of Northwind can be downloaded online and you can even download an Excel version of Northwind for use if you do not have Access installed. The book also covers SQL Server.
However, this book is probably not for the Excel beginner and you need to persevere when reading some of it. Because some paragraphs may cover SQL Server, Access and Excel you will need to sometimes decide what you want to 'skip'.
The DAX formulas are described well and there are screenshots that show the results of the examples given.
One particular issue that I have not found mentioned in this book (or the other book that I have) is that the 'ribbon' in the PowerPivot window becomes a 'toolbar' when running PowerPivot in Windows XP - the ribbon appears when using Windows 7.
If you want to get to grips with PowerPivot and are prepared to persevere, this is a very good book. I am very pleased with it.
This book is different. There are 15 small sample files (mainly giving some of the SQL) but the big advantage is that the book uses the Microsoft Northwind database and the text is therefore very easy to follow. The pre-Access 2007 (the better) version of Northwind can be downloaded online and you can even download an Excel version of Northwind for use if you do not have Access installed. The book also covers SQL Server.
However, this book is probably not for the Excel beginner and you need to persevere when reading some of it. Because some paragraphs may cover SQL Server, Access and Excel you will need to sometimes decide what you want to 'skip'.
The DAX formulas are described well and there are screenshots that show the results of the examples given.
One particular issue that I have not found mentioned in this book (or the other book that I have) is that the 'ribbon' in the PowerPivot window becomes a 'toolbar' when running PowerPivot in Windows XP - the ribbon appears when using Windows 7.
If you want to get to grips with PowerPivot and are prepared to persevere, this is a very good book. I am very pleased with it.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
5 reviews
7 of 7 people found the following review helpful
PowerPivot
27 Oct 2010
Format:Paperback|Amazon Verified Purchase
Practical PowerPivot & DAX Formulas for Excel 2010 is your standard How-to. From the title I expected a little more, and while my rating and this review sounds like a slam, its not. The book is a simpple block and tackle how to use. It well structured but not especially engaging. It reads like a reference text or the user's guide that should come with the product.
With that said, If you're looking for deep insights, cleaver tricks, and interesting examples or fluffy graphics this is not the book. If you're looking for a straight how-to, this is dead on. While I rate it a 3, I'm a very hard reviewer as I go up the scale. If you ask would I purchase the book again or was it a good value, I'd say yes again to both.
With that said, If you're looking for deep insights, cleaver tricks, and interesting examples or fluffy graphics this is not the book. If you're looking for a straight how-to, this is dead on. While I rate it a 3, I'm a very hard reviewer as I go up the scale. If you ask would I purchase the book again or was it a good value, I'd say yes again to both.
5 of 5 people found the following review helpful
Good insight into Powerpivot - book title is accurate
11 Mar 2011
Format:Paperback|Amazon Verified Purchase
Before I concidered purchasing this book, I already owned three powerpivot books. All were rated close to 5 stars by prior reviewers. I was not excited about yet investing in a fourth book, but I still struggled to identify and use functions available with the feature rich power pivot product. After reviewing the limited previews of this book available on Amazon, I was torn but finally decided to take the plunge in yet another purchase.
Wow, on day one I am using several of the 250 practical DAX formula's. One example is creating "running totals". Searching "running totals using power pivot" on google resulted in identifying complex solutions using the Calculate function. But when reading this book, I find a simple answer, the TotalYTD function! Then I needed to calculate the "percentage of a column" and a "percentage of a parent". Right there in chapter 12. The associated graphics helped immensely when trying to understand the variations of these calcuations.
Of all the four Powerpivot books I now own, this is by far my favorite as it is to the point, easily identifies features that are not readily apparent and helps clarify how to use functions making it very "practical" as the book title states. I carry this book with me to and from work everyday. Best $26 I have ever spent - great price for an excellent new book on Amazon. Now that I own the book, would have spent much more.
Wow, on day one I am using several of the 250 practical DAX formula's. One example is creating "running totals". Searching "running totals using power pivot" on google resulted in identifying complex solutions using the Calculate function. But when reading this book, I find a simple answer, the TotalYTD function! Then I needed to calculate the "percentage of a column" and a "percentage of a parent". Right there in chapter 12. The associated graphics helped immensely when trying to understand the variations of these calcuations.
Of all the four Powerpivot books I now own, this is by far my favorite as it is to the point, easily identifies features that are not readily apparent and helps clarify how to use functions making it very "practical" as the book title states. I carry this book with me to and from work everyday. Best $26 I have ever spent - great price for an excellent new book on Amazon. Now that I own the book, would have spent much more.
Your PIVOT POWER 2010 Excel Formulas Practical
28 May 2012
Format:Paperback|Amazon Verified Purchase
Generally informative book. The author is without question an expert at data analysis and its management. In fact so much that he cannot resist to to digress into MDX, data cubes, SQL, and various other sophisticated data analysis methods. His side-trips make the book less readable and leaves the reader questioning his focus. While the non-DAX matters discussed are very informative, it would appear that the writer could have possibly handled these digressions either as footnotes, or as Appendixes. The book already contains 3 Appendixes and the subjects covered therein are at times repetitive of information covered earlier in the book.
The author could make his book far more readable by citing the navigational instructions in more logical sequence and format. For example, if a command is located buried in the Ribbon, why not start with what the reader sees and drill down from there. The writer seems to prefer to use the quite the opposite, the "drill up" method, which makes the book less readable and forces the reader the do mental gymnastics. Highlighting the COMMANDS in BOLD, or ITALIC letters or some other similar way, even if just capitalized, would make reading much easier by separating the navigational instructions from the text.
The book could certainly have been more readable had the author not wrote it in second person. As it is now, the reader suffers through, or attempts to ignore, hundreds of pronouns .. YOU and YOURS, not one of which advances the thesis of the book. Expecting the reader to read "your data".. and "you do this" .. "you do that" gets boring rather quickly, especially when some sentences contain 3 or 4 "you-s" and "your-s". (If you had to scratch your head with your hand, when your eyes saw the jumbled order of words in the review title, it is intentional and intended to draw attention to the awkward, illogical manner in which command navigations are handled in the book.)
The writer represents that the reader can download from a cited website 250 DAX formulas. The formulas download into .txt formatted documents with no explanations, or any further advice. It is not quite clear from the book how exactly the reader/user benefits from downloading them. The formulas appear to have been formatted to be used with the various data tables and databases discussed in the book.
Discounting the aforesaid organizational and writing style deficiencies, the book is well worth reading; it is certainly a very valuable, very useful reference manual on the subject of DAX formulas; and its price is most reasonable.
I am glad to have bought and read the book for it certainly gave me a good insight, into DAX and will keep it within reach as delve into Business Intelligence type analysis using DAX formulas, and POWERPIVOT in EXCEL 2010.
The author could make his book far more readable by citing the navigational instructions in more logical sequence and format. For example, if a command is located buried in the Ribbon, why not start with what the reader sees and drill down from there. The writer seems to prefer to use the quite the opposite, the "drill up" method, which makes the book less readable and forces the reader the do mental gymnastics. Highlighting the COMMANDS in BOLD, or ITALIC letters or some other similar way, even if just capitalized, would make reading much easier by separating the navigational instructions from the text.
The book could certainly have been more readable had the author not wrote it in second person. As it is now, the reader suffers through, or attempts to ignore, hundreds of pronouns .. YOU and YOURS, not one of which advances the thesis of the book. Expecting the reader to read "your data".. and "you do this" .. "you do that" gets boring rather quickly, especially when some sentences contain 3 or 4 "you-s" and "your-s". (If you had to scratch your head with your hand, when your eyes saw the jumbled order of words in the review title, it is intentional and intended to draw attention to the awkward, illogical manner in which command navigations are handled in the book.)
The writer represents that the reader can download from a cited website 250 DAX formulas. The formulas download into .txt formatted documents with no explanations, or any further advice. It is not quite clear from the book how exactly the reader/user benefits from downloading them. The formulas appear to have been formatted to be used with the various data tables and databases discussed in the book.
Discounting the aforesaid organizational and writing style deficiencies, the book is well worth reading; it is certainly a very valuable, very useful reference manual on the subject of DAX formulas; and its price is most reasonable.
I am glad to have bought and read the book for it certainly gave me a good insight, into DAX and will keep it within reach as delve into Business Intelligence type analysis using DAX formulas, and POWERPIVOT in EXCEL 2010.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
