skip to Main Content

Guest Post by Tim Rodman, currently blogging about Acumatica ERP @

Self-Service BI and Power Pivot Barriers To Entry
They may take our lives, but they’ll never take our freedom Self-Service BI and Power Pivot.

Brief Intro from Rob:  Tim has a great “backstory.”  He found out about Power Pivot in the “usual” way – via a completely random coincidence.  I taught a private class to a firm here in town a couple years back, and one of the attendees (a guy named Andy) lived a few houses down the street from Tim.  Sitting outside at a summer barbecue, Andy mentioned Power Pivot to Tim, Tim said “what’s that?” and six months later Tim was a speaker at our Modern Excel User group.  I think he has some very interesting things to say here – very introspective and honest.  Worth a read for everyone.

Take it away Tim…

I’ve been thinking lately about Self-Service BI and barriers to entry. Now, when it comes to Self-Service BI, much of the focus is on the technology. Do you want to go with Microsoft, Tableau, something else? It seems to me like most of the content on the subject of Self-Service BI is focused on comparing the different technology offerings. I personally don’t know much about the gory details related to the technology behind these products, but I do think that too much attention is given to the technology and not enough attention is given to the people.

In my opinion, PEOPLE are the biggest barrier to entering the Self-Service BI age, not technology.  Note: for the purposes of this post, I’m going to focus on Power Pivot since this is appearing on a Power Pivot blog.

I have been reading Rob’s blog here for about a year now. One thing I appreciate about Rob is that he really believes that Power Pivot is for the Excel Pro, not just the super geeky IT professional. I have been slowly implementing Power Pivot in my organization for the past six months or so and, based on my experience interacting with non-techy users, I have to agree with Rob that Power Pivot really is for the Excel Pro. Recently I was wondering, why aren’t more companies experiencing this phenomenon? Then it dawned on me, it’s the IT professionals in many cases who are the real barrier to entry for Self-Service BI and Power Pivot. The reason I’m not experiencing resistance from the IT department in my organization is that I happen to be in the IT department.

It’s very easy for the IT department to start thinking too highly of themselves or to exercise too much control over their organization’s data. Some IT people see themselves as the guardians to all information in their company. They watch their users like a hawk to make sure they aren’t using non-IT sanctioned products like Dropbox for sharing files or instant messaging for communicating with other employees. This philosophy finds its way into reporting as well. How many times have you heard something like this from an IT person?

  • – I would LIKE to show you how to create this report on your own, but I can’t because it’s REALLY complicated.
  • – We should leave report-writing to the EXPERTS so we can ensure that there aren’t any errors.
  • – We would open this up to everyone, but we just can’t afford to send everyone to the week-long training class that I went to.

The truth is: this stuff isn’t as complicated as many people make it out to be. If you don’t believe me, start showing Power Pivot to others in your organization and watch it take off. I think the real problem is that many IT people are scared of losing power. They like to be able to work magic without others really understanding exactly what it is that they do. They don’t want the bright light of Self-Service BI to shine on what they are doing because people might discover that they aren’t as magical as everyone thought. They clutch their reporting tools in their hands like Gollum clutching the ring in Lord of the Rings because they know that information is power.

Self-Service BI and Power Pivot Barriers To Entry

The peril of clutching IT power too tightly

An IT professional CAN be a big asset if you are trying to introduce Power Pivot to your organization. They can help make your data easier to access. They can help users form meaningful relationships between different types of data. But, it’s also possible that they can secretly sabotage your attempt at Self-Service BI. The IT department has a lot of power, and much of that power comes from their knowledge being shrouded in secrecy. Here are some signs that you have an anti-Self Service BI mole in your IT department:

  • – You hear a lot about the “major” technical challenges that will need to be overcome before you can introduce Power Pivot in your organization.
  • – “If we do this, we will lose the one version of the truth and our data will no longer be trustworthy.”
  • – You sometimes notice a bulge under the shirt of one of the “reporting technicians” that is about the size of a gun and you overhear them talking on the phone in a foreign language (probably contacting the rogue government that employs them). Ok, this is a little excessive, but you get the idea.

This might seem like a harsh critique of the IT professional, but remember:  I *AM* an IT professional.  It takes one to know one.  I believe that at least some element of this philosophy has been ingested by every IT professional, myself included.  IT departments have power and power corrupts.

The irony is that you are actually better off as an IT professional if you share your magic tricks with others because you build connections with people and you gain prestige with others by making their lives easier. I’ve noticed this when doing ERP implementations. During an ERP implementation, there are always those who resist putting their information into the ERP system because they think that they are going to somehow become obsolete. They think that the only way they can remain valuable to the company is to keep what they know in their head, on sticky notes, or in some cryptic filing system that no one else can understand. That way they become the gatekeeper to a world of information, thus ensuring job security for themselves in the future. The reality is that you will actually have more job security if you increase visibility into your area and make it easier for others to access things because you will build connections with others and they will appreciate you for being a team player. The same goes for Self-Service BI.

The real value that a person provides to their organization is their ability to communicate and connect with others. The easier they can make things for their customers (internal and external), the more valuable they will be to their company. Communication is key and Power Pivot helps us to communicate with data better than ever before. If you are in an organization with an overbearing IT department, please join me in helping to throw off the yoke of your oppressors and entering the age of Self-service BI. Enter the data democracy revolution by employing Power Pivot in your organization.

This Post Has 13 Comments
  1. ERP seems scary to people and very few people want to delve any deeper than to know how to enter data without causing problems and how to get their own reports. I like it when a user wants to delve deeper and tweak reports or create custom views that will make their jobs easier. I like to enable those people.

    When it comes to BI, I’d like to be an enabler and I think that PowerBI will be a great tool for handing off the tools, a little at a time. So far there are not many Excel power users in my organization, but there are several advanced users who want to expand their skills and I’m happy to offer the training.

  2. I wonder if I’m in a minority here, coming to PowerBI from the Finance/User end of the continuum, as opposed to from IT. (I know we’re all on the same side here, but I do wonder all the same: I think it’s a potentially revealing stat.)

    I’m something of an evangelist in my organization for users, especially Finance Analysts, upskilling in Excel – and while I haven’t always brought colleagues onside as much as I’d have liked to, I recently organized some (Spanish-speaking: Miguel Escobar) PowerPivot training and no less than 40 (!) have signed up. It will be very interesting to see the user uptake % afterwards.

    And to Tim’s post, IT had absolutely nothing to do with organizing this, much less funding it!

    – juanito

    1. At the very beginning (2009), it was basically *only* IT and BI types reading this site.

      But long ago – several years ago in fact – the “Excel pro” audience passed the IT/BI crowd and is now the overwhelming majority of readership (about 80% at last survey, which was admittedly also a long time ago).

      So, 80% Excel Pros, 20% IT. That’s the readership here.

      BUT what % of Excel Pros know about Power Pivot? Probably 1% at best. So when you bump into another Excel Pro, they likely will have no idea what Power Pivot is. IT, by contrast, is much more aware.

      There are just so many more Excel Pros in the world – that explains the difference.

  3. Hi Juanito.
    I am also from the finance department. I think the beauty of Power Pivot is that it enables a non-IT people (Excel pro) to have the ability to analyze millions rows of data and easily share the easy-used BI tool with users in sales, marketing, and other departments.
    I am also trying to implement Power Pivot in my company. My problem is people here don’t appreciate data analysis and managers have been used to making decisions purely based on their experience.
    I hope my work can change some of their opinions.

    1. Sounds as though you have a little bit of an uphill problem there…but I bet you know people who would be open to your approach – and if your data showed another angle…how convincing would that be!

      1. Actually this is THE reason it is hard to implement something like Power Pivot. It should be a slam dunk and managers should be praising you for doing it… BUT! Managers don’t like facts. Now that might sound stupid, but one could argue that facts does NOT bring the success people want. If Steve Jobs listened to facts there would be no iphone, and no ipod. If Henry Ford listened to facts there would be no cars.

        I know its hard for IT-people to understand just how irrational us finance people and managers are, but you really have to accept it. Cause if you look at us, well we might be irrational, but very much predictable in our irrationality. (For example most of us wear waaaay to big suits and shirts, very predictable….)

        Don’t get me wrong here… Im not saying it is right for managers to prefer “experience” over facts… but they did get hired because of “experience”… if we start to do business based on facts… well that guy is going to get fired.

        In a way this is the finance peoples thing they are trying to protect. If you don’t have this problem, and its the finance people that want the BI thing… you can be sure that you instead have the above problem of the IT-person wanting to protect its thing, namely all the data.

        Its just people wanting to uphold the illusions of wizardry. And its a really tiresome mess for us that just want to make tomorrow a bit better.

        1. Thanks for this thoughtful post David B!

          Predictably Unpredictable…Love it.

          One of my favorite management gurus of all time is Tom Peters. He has weighed in on the very interesting topic you raise. Specifically, with this new-found ability to support evidence based decision making based on boatloads of data, how do you accommodate for Steve Jobs? (maybe we can nudge Tom into commenting here)

          With respect to Medicine, I believe his view is that the docs, can override the algorithm’s but they better have their S*** to together when they do!

          1. I believe the “Money Ball” strategy here can be a valuable backup for the BS, but manager have to appreciate the data, the trends that the data shows and most importantly, the accountability to goals and metrices that data shows (or doesn’t in many cases). A good manager is only threatened by numbers if they show his/her inability to manage…

        2. David B,

          Your “managers don’t like facts” comment made me think of this dilbert comic:

          It seems like managers want facts. But, once they get the facts, they spend all their time trying to disprove them. Maybe it’s because, as you say, the managers are afraid of getting fired if the “facts” replace the need for “experience”.

          I’m not sure it has to be this way though. There is always more analysis to be done. The model is never complete. There will always be the need to supplement the “facts” with “experience”.

          But, maybe you’re right, it’s not just the IT professional who wants to keep things shrouded in secrecy. The business manager may have the same motive when it comes to making data-driven decisions.

          1. Im not saying its right… Im just talking from experience. I used to be an accountant, moved on to business controlling and now I got tired of managers beeing managers and joined the BI-consultants. They like facts like I do 🙂

            But its also as was discussed in another post. One reader hade made a script that saves the PowerPivot Dashboard as a PDF-file and mails it to the top management. Its also related to the above. Its like the managers think “Hmm… facts in excel aren’t real facts, but this PDF-file is locked… this must be the truth!”

            And sooner or later every reader on this page will probably meet someone that matches that description. And remember then that no… its not you, its them. They just get paid a lot for some reason.

  4. Hm, this is an interesting angle. I speak as a trainer so I am (to some degree) straddling the two worlds. I see so many people coming in asking for pivot tables (usually with a bead of sweat trickling down their brow) and then they end up saying “is that it?” or “wow, I used to do all those percentages manually” – I pause to wipe a tear from my eye at all their wasted time. I work with finance people and they immediately “get” the value of Powerpivot – more so than other groups I have noticed. Another thread that I see in IT departments are the people who hate Microsoft – they don’t want to learn about Excel and they secretly think Google docs are just as good (it is in the way a bike is as good as a Ferrari – all depends). What I would love is for people to start using Powerpivot and to get so comfortable with it that they start forgetting about the formulas and start playing with the data..I do think though that there needs to be specific customised help for people to implement Powerpivot – to reassure them (especially Finance people) that their figures can be trusted.

  5. One of the challenges with encouraging Power Pivot adoption without IT is that in many cases it requires the assistance of an IT department. Installing add-ins, getting 64-bit Excel, upgrading to Excel 2013 (for Power View)…those are all points at which a non-IT person might have to make contact with IT and potentially get shut-down before they even have a chance to prove the power of Power Pivot.

    One recommendation I make for people facing this situation who work for eligible companies: the Microsoft Home Use Program ( Get the work version of Excel 2013 on your personal machine for next to nothing and use that to make a case for being allowed to install it at work.

    And to defend the IT professional a little bit….there is nothing more painful than getting a report someone else has built that doesn’t match the official report, and having to go through the code transaction by transaction to figure out the differences and “prove” why the official report is right. It’s a good exercise, but it’s so time consuming…

    1. You are so right on. Microsoft making Powerpivot enterprise only (or standalone Excel) was such a mistake. Coupled with Powerpivot being tied so much to sharepoint..

Leave a Reply

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