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
Converting Row Context into Filter Context
Intro The first sentence of each blog post is always the hardest. Whew! Glad that is out of the way. Movin’ on! Part of me wants to skip or delay this post – as I have it on good authority that the Italians are going to write this up for us. And they actually understand this, where I stumbled onto this and was completely confused, flabbergasted, perplexed, baffled and mystified! (I may have pulled out the thesaurus, but you can’t prove it). But, I can’t Continue Reading
Unique and Ugly Primary Keys of Doom
I’m currently working with a bunch of data about real estate. The properties are identified by an ugly string. Of DOOOM! There are quite a few relationships built on this ugly sucker, which led me to wonder… what if I mapped them all into a simple integer? I whipped up some totally bogus sample data to test this, using Property Ids that look like “WA534879” and “CA35849”. Properties have attributes like SqrFt, # of Beds, and what region it is in. And I hooked up a few million rows of Continue Reading