My buddy Derek Rickard gave this great talk awhile back at a local “Modern Excel User Group” meetup. I’m putting it here because a) it is awesome and b) I can never find it. Now I can! Definitely worth a watch – some really clean modeling here. Stolen without permission, because I am a bad man. Derek does some Power Pivot consulting, if you need to get ahold of him let me know, and I will get you in touch. If he gets back to me with a link to a website or something, I will add it here Continue Reading
Power Pivot Hosting
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