Sort Your Data On Load For Improved Compression

Sort Your Data on Load for Improved Compression

My last 2 blog posts have been about data compression – that theme continues today.  In December I blogged about the basics of compression and impacts that columns have on file size and did some testing with randomised data.  In January I went a bit deeper and talked about restructuring your data to get better compression.  In the comments section of this last post in January there was a seemingly innocuous comment from Mati Seig at the bottom of the…

Read the Rest
For Real This Time:  Show Barnes & Noble That Power Pivot And Power BI Are Important!

For Real This Time: Show Barnes & Noble that Power Pivot and Power BI are Important!

Sunday, Feb 7th in a Local B&N:  That Silver/Grey Spined Book is Ours! OK, for real, B&N has them now!  (I have seen them myself, as pictured above, and every B&N I’ve called has them). Remember, they accepted our challenge of an experiment:  they will stock our new book for a few weeks and see what kind of “action” it gets.  If it does decent sales, they will keep the book on the shelves (AND start stocking more such books,…

Read the Rest
Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?

Oh Em Gee: Embedded Power BI Dashboard, Google Analytics, Real-Time?

I Bet You Think This is a Picture, Don’t You? Yeah, this is the place in most posts where you will find a picture…  but aha!  It is anything BUT! That’s not a picture, it’s a fully interactive Power BI dashboard embedded into this page! (Click, zoom/pan, hover – try it out) (And check Back EVERY HOUR for the latest stats – it updates automatically!) (If you're looking at this in email and can't see it, try this link instead.)…

Read the Rest
Upcoming In-Person Class Schedule, March-May

Upcoming In-Person Class Schedule, March-May

Upcoming Two-Day Classes in DC, Seattle (Consecutive with MDIS), Philly, and Indy – Plus a 1-Day Precon at PASS BA in San Jose A bit more organized this year… (Today’s post is short and direct, with another “real” post coming on Thursday about Power BI.) We’re going to be announcing our class schedule a bit further in advance this year, and today we’re excited to share that we have dates scheduled through May Washington DC, March 8-9 The full two-day…

Read the Rest
MS Roadmap: The Good, The Bad, And The Ugly

MS Roadmap: The Good, the Bad, and the Ugly

Yeah I’m a Bit Slow… Back in October, Microsoft released a roadmap blogpost detailing plans and direction for their BI platform.  I kinda pressed the Snooze bar on paying attention, because hey, I was super busy, plus…  I always tend to take my time with announcements like these.  I do my best “digestion” once the noise has died down, and my best thinking slowly, in quiet. Spoiler: Mostly Positive Words like “Bad” and “Ugly” are overkill, as my reactions are…

Read the Rest
Traditional BI Is (Unintentional) Corporate Sabotage

Traditional BI is (Unintentional) Corporate Sabotage

A CIA Manual for Inaction Perhaps you’ve seen this making the rounds on Facebook:  in the 1940’s, the CIA created a sabotage guide for citizens of France and other occupied countries.  You know, to screw with the Nazis, which is pretty much All Good.  This manual was declassified within the past ten years, and it provides an intriguing glimpse into human nature. The manual contains the sorts of things you’d expect to find:  how to wreck equipment, ruin fuel, disrupt…

Read the Rest
Show Barnes & Noble That Power Pivot Is A Monster!

Show Barnes & Noble that Power Pivot is a Monster!

***Update***  B&N got confused on this, and does NOT have the books in stock yet!  Their system thinks our 2nd edition is only available as an eBook (they entered the 1st edition ISBN into their system rather than the new one).  Stand by for an update on this, we will let you know the new availability date.  Apologies folks Earlier this month we had a conversation with the “Product Mix” department at Barnes and Noble (the dominant bookstore chain here…

Read the Rest
Year To Date In Previous/Prior Year

Year to Date in Previous/Prior Year

YTD is easy with “standard” calendars, but the previous year’s equivalent is a non-obvious formula. Back in the Saddle! What’s this, you say??  Yeah, it’s Rob, and I’m here with an actual formula post!  Woo woo!  Starting the year off right, as they say. We’ve got a lot going on early this year, so expect to see a number of announcements and reminders in the coming weeks (one of which later THIS week, and it’s super exciting for me at…

Read the Rest