Independent Publishers Group Logo

Sign up today...
for featured pop culture and science reads, books for kids and teens,special offers, bestsellers, and more, in your inbox!

Subscribe to receive special offers, monthly books suggestions, seasonal selections, and more!

Comprehensive Power BI
Comprehensive Power BI

Comprehensive Power BI


256 Pages, 8.25 x 10.5

Trade Paper, $34.95 (US $34.95) (CA $46.95)

Publication Date: June 2020

ISBN 9781615470624

Rights: WOR

Holy Macro! Books (Jun 2020)

Not Yet Published. Estimated release date: June 2020


An approachable manual for Excel users on writing formulas in PowerPivot

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. This updated third edition covers new features introduced in 2018-2019. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months. 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." 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 are now available within the pages of this easy-to-follow guide.

Author Biography

Ryan Bergstrom is a consultant with PowerPivotPro and enjoys witnessing "the moment" when a client realizing how revolutionary PowerBI, PowerPivot, and PowerQuery are for their business. Ryan cut his data teeth with CRM administration and building ad hoc Excel reports. Rob Collie is an entrepreneur, author, and consultant. He was one of the founding engineers behind PowerPivot at Microsoft and operates the world's leading PowerPivot website, He lives in Indianapolis.  Ryan Sullivan received a degree in Pure Mathematics before becoming a full stack developer for Microsoft Business Intelligence tools. His interests include optimizing business through intelligent data use, empowering analysts in the trenches, and hurling himself out of airplanes.