• Books RSS Feed

    by Published on 2017-12-20 08:49 PM

    DIY BI eBook Series:
    Tips, Tricks and Techniques for Building Your Own BI Solutions


    This free eBook series is available to our Excelguru email newsletter subscribers. Each book contains ...
    by Published on 2016-10-17 10:08 PM     Number of Views: 1345 

    Learn to Write DAX:
    A Practical guide to learning Power Pivot for Excel and Power BI


    Add to Cart

    Power Pivot has been called “the best thing to happen to Excel in 20 years.” It is a revolutionary piece of software that brings everything that is good about enterprise-strength business intelligence (BI) tools directly to you right inside Excel, and without the negative time and cost impacts you would normally expect from big-scale BI projects. Analyses that you would never have considered viable in the past are now easily doable tasks within the current business cycle.

    But to unleash the enormous power of Power Pivot, you will need to learn how to write DAX. Power Pivot is very learnable, but it also very different from Excel so you need some structured learning if you want to use the tool effectively. This book is written specifically with the Excel user in mind, geared towards the way Excel ...
    by Published on 2015-10-22 06:42 PM     Number of Views: 25819 

    M is for (Data) Monkey:
    The Excel Pro's Definitive Guide to Power Query

    Add to Cart

    It may have a funny title, but this will be one of the most important Excel books you ever buy in your career.

    The Excel book that will change YOUR life...
    Written BY Excel pros FOR Excel pros, this book has been designed to guide you through learning how to master the new "Get and Transform" data experience in Excel. Released as a free add-in from Microsoft for Excel 2010 and 2013, Power Query technology is now built in to Excel 2016 and the Power BI Desktop application. This technology is a game changer, and will revolutionize the way you work with your data forever.

    Way back when this book was nothing more than a concept, we knew that it needed to be approached in a specific way. It had to speak to Excel users, the problems that they face on a daily basis, and ways to solve those problems both effectively and efficiently. It had to be written to keep you engaged, and to take you on a guided journey, learning from someone who understands you as an Excel pro, how you work, and what you face on a daily basis.

    We're proud to say that we believe that we've delivered on that goal, starting with common tasks you perform, and back filling them with real world issues, inspired by a wide variety of real world data sets. Packed with downloadable files and step by step instructions, this book is built to help you master Power Query so that you can use it in your own work, with your own issues. This book was designed from the beginning to get you up to speed quickly, and to give you the knowledge to build awesome Excel solutions ...
    by Published on 2017-12-20 09:15 PM

    Magic Tricks for Data Wizards:
    Tips & Tricks for Power Query in Excel and Power BI



    In the online Power Query workshops that we deliver as part of our Power Query Training project, we commonly talk about how data professionals can often perform “Magic” ...
    by Published on 2016-10-17 08:32 PM     Number of Views: 1177 

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


    Add to Cart

    Excel pros are used to working with unstructured data. This ability is what has made Excel so successful, but it’s also this freedom that makes learning Power Pivot challenging. Why? Because Power Pivot requires structured data, something we’re just not used to.

    It’s for this reason that we HIGHLY recommend Power Pivot and Power BI as an essential part of the learning journey. In fact, had it not been for the material in this book, Ken says he wouldn’t be equipped to teach courses on Power Pivot.

    Learning how tools work is great, but if you can’t figure out how to apply it to your own work, it doesn’t help. And that, right there, is why this book is so essential. Not only does it teach you the concepts of how to build your DAX measures, this book clearly works through how DAX ...

  • MVP Logo
  • View Cart