Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016

Power Pivot and Power BI The Excel User s Guide to DAX Power Query Power BI Power Pivot in Excel Microsoft PowerPivot is a free add on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before and this book is the first to tackle DA

  • Title: Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
  • Author: Rob Collie Avichal Singh
  • ISBN: null
  • Page: 207
  • Format: Kindle Edition
  • Microsoft PowerPivot is a free add on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience Written by the world s foremost PowerPivot blogger and practitioner, the book s concMicrosoft PowerPivot is a free add on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience Written by the world s foremost PowerPivot blogger and practitioner, the book s concepts and approach are introduced in a simple, step by step manner tailored to the learning style of Excel users everywhere The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce It includes lessons on the difference between calculated columns and measures how formulas can be reused across reports of completely different shapes how to merge disjointed sets of data into unified reports how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not and how to create time intelligent calculations in pivot tables such as Year over Year and Moving Averages whether they use a standard, fiscal, or a complete custom calendar The pattern like techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy to follow guide This updated second edition covers new features introduced with Office 2015.

    One thought on “Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016”

    1. Realistically I am never going to "finish" this book - it lives on my desk at work and is rapidly becoming tatty and dog-eared from use as I wrestle with the transition from Excel to "grownup" BI - but I'm calling it done. An excellent, highly readable resource for Excel users wanting to branch into advanced analytics using the new Microsoft "Power" suite. Do not allow Microsoft's online help to drive you to despair - buy this book!

    2. FantasticHaving a basic understanding of formula syntax is really all you need to dive in here. The book progresses I an a way that makes sense, and is easy to follow. The concepts are laid out in a way that builds upon the previous chapter, and even if you don't understand the "why" behind the formulas they still work. Practice with the concepts will lead to it "clicking"

    3. Really clear and well put together book walking through the basics of the power family and the fundamentals of the Dax language. Great use of examples and a clear progression through the features and formulas.

    4. New excel horizonsThis book completely changed my perspective on excel capabilities and I can hardly wait to put some of the examples described into real life.

    5. Excellent book. If you use Excel and want to extend the power of Excel, have a crack at Power Pivot (providing you have Excel Standalone or ProPlus, as it isn't provided in Excel Home Subscription). If starting or even experienced, then this book is a must-have on your shelf. I like how Rob clearly steps through what you would likely see as a result (i.e. not correct) until all steps are considered and applied accordingly (example: Sum at the bottom doesn't equal the Sum value in your Pivot Tabl [...]

    6. Forget Excel and learn thisAmazing book, didactic, funny and inspirational. If your job is all about Excel, this book will change your life. I started in Power Pivot watching YouTube tutorials, but I realized that I was in front of such a huge, indispensable and important tool, that I decided to buy this book based on the reviews and I don't regret. In fact, I had not written any review in upon this purchase

    Leave a Reply

    Your email address will not be published. Required fields are marked *