This morning I ran into an interesting problem. We have an office365 document library we’re using as a small scale CMS, where users are contributing documents and editing the attributes of those documents. PowerBI can then query the attributes in …..
This seems like it should be straight forward, but it’s not. The documentation on the TOTALYTD function is not great. Suppose I have a fact table with monthly revenue, and a standard date dimension. The date dimension has a date …..
So far in 2016, this seems to be a common sight; There seem to be endless articles prescribing the reasons the top goal has failed over the years. The technology is ahead of the business. The business didn’t know what …..
I’ve been working on a big powerBI dog and pony show lately, and have discovered a couple things in my haste. (Not really when I want to be discovering them) Filtering over a summarize or crossjoin is a terribly inefficient …..
The analytics and business intelligence spaces are frequently poorly executed spaces. After more then a decade operating in this space, I believe I’m beginning to understand why. With a background in software engineering, and a dozen engagements in the financial, …..
I’ve been working on a new power BI model this week, with the intent of showing historical attributes of work done over time. So I end up with table OrdersPFMHistory which contains a key that indicates a state at a …..
Earlier this year, Microsoft acquired Datazen, keeping true to their strategy of services and devices. I’ve had the fortune of trying out these new tools for a client of mine. I’m going to quickly cover how to set up a …..
I’ve recently finished reading Nate Silvers the signal and the noise. Trained as an engineer, now working as a data scientist, this book appealed to me. I figured that I could reap some important lessons that I might be able …..
This week I attended a tableau showcase. I enjoy attending these events, not for information on the product, rather for information on which way the industry is moving. This event showcased several Tableau customers, namely Alberta Health Services (AHS), Groundswell …..