skip to Main Content

Post by Rob Collie


Click to Download the Workbooks and Data Sources

Apologies for the Delay

No excuses, I just fumbled this.  At one point I *did* plan to make the files available for the Alchemy book, just like I did for my first book.  But then I got lazy and thought “nah, people don’t really seem to need them.”  Which was dumb.  There are even places in the book where I say “you can grab the files and walk through this yourself.”  Ugh, so silly.  Anyway, finally they are ready to be shared:

Grab the Files Here

Don’t Have the Book?  Grab the Files Anyway!

If you want the files but haven’t purchased Alchemy, do NOT feel guilty – just grab the files anyway!  Seriously, “steal” them all you want.  Give them to your friends and family.  Re-gift them at the holidays, heh heh.  Yes, the files contain useful examples on their own, but they’re also a good “advertisement” for the actual book, so we don’t mind.

Click Here to “Steal” With Our Compliments 🙂

Have fun!

Rob Collie

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 15 Comments
  1. Power Pivot Alchemy is like acquiring the skills and tools that a jeweller uses to convert a piece of rock into a dazzling diamond. The book is part of my tool kit to convert data into business insight.

    Thanks Rob and Bill.

  2. Another possible file of use would be a listed file with all the tinny url links you post in the books so I do not have to type them?? Please please!?

  3. Whenever I am opening the files I am getting following error – “The Visual Basic for Applications (VBA) macros in this workbook are corrupted and have been deleted. The macro corruption most likely exists in the current file. To recover the macros, open a backup copy of this file if you have one.” I am not understanding what macros are built in and does it really require to be part of files?
    Please clarify.

    FYI – I tried opening both 2010 & 2013 files but still getting same error.

    1. Thank you for bringing this to our attention. After researching this error, it could be due to macro settings on your computer. If anyone else runs into this error, please let us know, but the macros look to be running fine. Thanks again for the feedback!

  4. Thanks for the learning tools like this book.
    I have a problem with the support file from Chapter 2, which is that the file does not include support for Figure 2.38 from the section “User-Friendly Report Sorting with Slicers”.
    Thank you in advance for your attention.

Leave a Reply

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