I can't recall if I have spoken about the many benefits of hosting your PowerPivot workbooks on SharePoint. Most any document is going to benefit from having a single source of "the truth" and avoiding "oh, you have the Tuesday version!? There was a new version Thursday" trauma. But in the case of Power Pivot workbooks this gets amplified a bit. The reason is that while you may have 1 or 2 authors for your workbooks... You may have many many folks that want to consume your Continue Reading
Many-to-Many Relationships
So, here we are… staring down two tables in the field of insight battle. It’s a standard (if highly simplified) “Budget vs Actuals” situation. We are total n00bs, and we see some fields that look similar, and we think… “sweet, let’s relate those two bad boys!” Alas: The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values. Oh. Right. As we discussed here, Power Pivot does not directly support Many to Many Continue Reading
1000 Forum Posts
If you want to learn something, read about it. If you want to understand something, write about it. If you want to master something, teach it. – Yogi Bhajan Over at Mr Excel Power BI Forums, I have just made my 1000th post! It’s been a bit over a year since I decided to stick with the Agile BI world as my full time career. I was going back and forth with sticking to what I had done for 20 years… (developing software) and leaving that all behind for the exciting world of Continue Reading
Screencast: xVelocity Internals
Any sufficiently advanced technology is indistinguishable from magic I have been wanting to do a Kahn Academy style screencast for awhile and finally forced myself to do it! It is… possible… that I spent a bit too much time working out the quirks in the software, and not enough time planning out what the heck I was talking about… but I put enough effort into it, that it would be a shame not to post it. The loose goal was to discuss (at least at a high level) the whys and hows of the Power Continue Reading