Back in the good old days, when I had more time and ambition, I really wanted to make a “generic oData feed”… built into Excel. The idea was that since Power Pivot could read oData… if I could make it super easy to convert any data source into an OData feed, then we could easily consume almost any data source. For some reason I was always excited to feed the results of a PowerShell script into PowerPivot… probably because PowerShell is basically my favorite thing evar. Well, with the Continue Reading
Growing Great Teams
This is something I have been thinking about quite a bit lately. Probably because I have been on so many terrible teams. :) While I don’t think there is anything surprising here, I do think it is something you have to work on… always. Obey Wheaton’s Law Coined by actor/nerd Wil Wheaton, this is probably the most important: “Don’t be a dick”. It is my belief that a lot of people in technology grew up smart nerds, which is not real an asset… as a kid. But then they get older… and suddenly Continue Reading
Segmentation in Power BI
I wish I had an awesome intro for this. I was mostly excited to write this entry… though, the techniques are fairly well known. I totally have no problem repeating good techniques, because… you are going to forget you read it in some other blog 2 years ago anyway But as I got into creating the sample pbix file… things didn’t really go that well. Pretty sure we are hitting some bugs in Power BI (yes, I have reported them!)… but we can mostly work around them. Continue Reading
Choropleth Maps in Power BI… with R
Rumors of my death were greatly exaggerated. Let’s get back to work. Fancy Map Okay, we want a map of “The States” where each state is colored by some metric. In our case, it is the Gross Margin we made off sales for that state. The style of map is called a Choropleth (apparently – I had no idea ). This is pretty easy in Power BI! Insert a “Filled Map” visual Click on your “state” column. Click on your GM$ measure. There is no step 4. Unless you want to tweak the colors a bit. I Continue Reading