How do you feel about honesty? Me… I’m a total fan! So, here goes… the only reason I am writing this post is so that I can link to it… from over on the Mr Excel Forums. While a bunch of my posts have been very not targeted at brand new folks, the people asking questions on the forum tend to be completely new to Power Pivot. They ask for a formula to do such and such… then, I have to ask if they mean a “Calculated FIeld” or a “Calculated Column”… and then they gimme the ol’ Ron Weasley look. Continue Reading
Crushing The Nouns
Repost: This was originally posted over at PowerPivotPro. I have since heard from numerous people that really enjoyed it… so I am re-posting here By nature, I am a rather skeptical person. When I first hear an idea, I generally think it is probably wrong. This isn't one of my finer traits and I am sure it drives Rob insane, since he has a rather impressive track record of being correct. Thankfully, this blog entry is not about one of the times I assumed Rob Continue Reading
WordPress Migration
I am still making some tweaks, but it seems we have successfully migrated to a new host for our WordPress site. I have made some minor style and content changes, adjusted settings to maximize my real estate on blog posts, and such. If you see anything truly messed up, please let me know Continue Reading
Power Pivot Hierarchical Data
Edit: Before or after reading my version, go read what Marco and Alberto have to say on the subject. I find it confusing... so two views are probably better than one: http://www.sqlbi.com/articles/autoexist-and-normalization/ Hierarchical. Just saying that makes me feel smart; though, I’m not super sure I spelled it right. Here, I am not talking about the feature that let’s you group a set of columns such that you can drop them all into a pivot table as one set. So far as I can tell, that is Continue Reading