skip to Main Content


This Highly Scientific Chart Reflects My Experiences of the Past Four Years

So Many Things to Write About!

There are many things competing for my digital ink today.  Microsoft has released a workbook size optimizer and I owe someone named “Doody” a post on that.  I have more to add to the last two posts.  I have a “tournament rules versus prison rules” post that is dying to get onto the page, inspired by Jeremy Bartz.  My wife and I spent yesterday with Chandoo and his family.

But something in the news recently brought another long-simmering topic to the foreground…

“We Steal Millions From Our Customers, and They Have No Idea”

Pilot Flying J Allegedly Underpaid Fuel Rebates to Multiple Trucking Firms –
a Practice That Only One Such Firm Detected!

An absolutely fascinating story is taking place in Tennessee.  The FBI has raided the headquarters of Pilot Flying J (a huge chain of gas stations and truck stops across the US), and even seized the computers of top execs, in connection with a scam.

The alleged scam goes like this:

  1. If you’re a trucking company and operate a fleet of 100 trucks, you buy a lot of fuel.
  2. That makes you a very valuable customer for someone like Pilot – they want your business.
  3. So Pilot offers you a rebate – if you buy X amount of fuel per month, they will refund you N percent at the end of the month.
  4. But certain people at Pilot figure out that smaller trucking companies have NO IDEA how much they are owed in rebates each month.
  5. So those people start shortchanging those smaller customers – sending them smaller rebates then they are owed – and pocketing the difference!
  6. This practice was referred to as “managing the discount,” or more colorfully, “jacking the discount,” or my favorite, “f—ing the customer.”


One Customer DID Discover the Scam – From the ESPN Article (Click for the article)

3.5 Cents Per Gallon in Rebates Were Withheld???

OK, diesel fuel is selling for less than $4 a gallon these days, so to shortchange someone 3.5 cents in rebates is a full 1% of the full purchase price

Not 1% of the rebate.  1% of the purchase price.  Rebates were typically around 4% of the purchase price, from my reading of the affidavit.

So they were shaving about 25% off of the discounts owed!  Wow, that’s a lot of shaving!

How Did They Get Away With This?

Simple.  They just needed to know which of their customers were sophisticated enough to catch it.  And if you weren’t sophisticated, they screwed you:


From Conversations Taped by FBI Informants

So Much Lurking in the Dark!  So Much Opportunity!

The lesson of this story, for me, is NOT that there is fraud in the world.  I expect this sort of thing happens all over the place.  In some sense the folks at Pilot are just unlucky that someone went to the FBI.  I’m sure many companies run similar scams and are currently sweating whether this Pilot thing will unmask their own fraud.

The bigger lesson is just how many people are blind to their own data, and how expensive that is.  Being defrauded is just ONE way you can lose money.  Bad, uninformed decisions take many forms.


Recently Said to Me by a Top Exec at One of the World’s 25 Biggest Companies

I talk (and write) a lot about traditional BI vs. Excel, how the latter dwarfs the former, and how PowerPivot blends the strengths between the two.  But make no mistake – that tension is NOT the primary change going on in the world.  Nor does it even represent the bulk of the opportunity.

The primary opportunity, in terms of data, is “lighting up the darkness,” as Bob Marley would say.

We have a lot of darkness to light up.  Which is a good thing for people like us.

Oh, and God Hates Cleveland!

Funny side angle:  the only reason I am even aware of this story at Pilot is because the CEO of Pilot recently bought the Cleveland Browns, so the story surfaced in my daily reading of sports news.

Bill Simmons loves to joke about how “God Hates Cleveland” and this is a new angle to that story.

Promising new owner pledges to turn the Browns franchise around.  Everyone gets excited.  Oh wait, promising new owner may be going to jail?  (The FBI alleges he was well aware of the scam over the years).  Wouldn’t that be funny?

Rob Collie

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 5 Comments
  1. Having just started reading this blog recently as my BI tasks are increasing, I’m glad to know that I’m in the right place with a Bill Simmons mention. Great post.

    1. Heh heh, I wondered how many visitors here also read the Sports Guy. Now I know it’s nonzero 🙂

      Welcome! And thanks for the compliment.

  2. Rob.. Glad you took notes about that talk.

    Grantland is one of my must read blogs, next to this one. 🙂

    Based on this post, there has to be an untapped job market for BI detectives to find anomalies in this type of fraud.

  3. Love the story! I’ve come to be a big fan of your posts and have been spreading them to all my unsuspecting friends.
    We experienced this same sort of ordeal several years ago with a large copier manufacturer. They were truly surprised when we were able to show them how much they really owed us… While fraud charges were never brought against them, they did pay us what was owed without much fuss.

    1. Hey thanks Paul! 🙂

      Yeah, I mean, at times it’s hard to see this as an FBI-worthy crime. Far bigger crimes take place every day in plain sight. I mean, it was definitely dirty and dishonest. But the crooks in this case have to be absolutely STUNNED that they’ve landed in hot water with the FBI over it. You don’t have to be corrupt to the core in order to have become caught up in this.

      I’m generally the “muckraking” sort, but in this case my fascination is not with the relatively normal people accused of this scam, but with the blindness that allowed it to happen for many years. Your copier firm story confirms that for me – things like this are must-read material for people like us.

Leave a Reply

Your email address will not be published. Required fields are marked *