Does your project require excel / Tableau?

Whatever your project scope, if you are not using excel – to categorize, count, calculate, or correlate things – I would argue that you really don’t have much of a project. It’s my bias, but a project that does not require excel in some form is well . . .more like coaching, staff augmentation, project management, and training – not management consulting. A bit arrogant, perhaps.

In essence, without excel you are not really driving to a conclusion using data. There might be research (sure), and interviews (sure), and observations (sure), but it’s more anecdotal and qualitative. Your “analysis” is based on impressions, feelings and points of view, not data. Basically, you don’t have enough data to need excel. Bad.

Small sample size

If you are not using excel in some way, it means that you have a small sample size. Your analysis is too narrow, and perhaps misleading. Somehow you are keeping track on paper, MS Word, or in your mind.

  • A robust logistics spend analysis might involve 100,000 deliveries
  • An analysis of bed utilization for a hospital might have 30,000 patient records
  • A trade promotion analysis might involve 3,500 different product types

How are you organizing that in your head?  Are you digging into the data enough?

Excel is the lifeblood of the consultant

The first place for most consulting analysts to start is excel. It is like the Karate Kid who constantly practiced “wax on, wax off” to learn the skills needed to fight. Same thing with excel. Like Malcolm Gladwell’s Outliers (affiliate link) you need 10,000 hours of deliberate practice with excel to call yourself an expert and proficient.

To be successful, you need to quickly be able to group, organize, slice-and-dice data.

A GMAT analogy might be: Consultant : Excel = Plant : Water.   

What novices don’t realize that behind every smartly worded, insightful PowerPoint is usually 2-3 crazy, ugly, complicated (and often frustrating) excel files. We might use Powerpoint to simplify complex ideas, and hallway conversations to build client rapport, but excel is where the money is made. From my experience, there are 10 hours of Excel for every 1 hour of Powerpoint.

Excel nerds, welcome here 

The consultants who come out of undergraduate engineering programs understand the importance of having good data. You get excel. These are the folks who model out student loan debt, and catalog recipes on excel. They are a bit type-A, and really keep things organized. Wicked good at excel and understand its importance. You get it.

Find data / Create data to put into excel

If you are on a project that does not require excel. . . think again. Push yourself to find or create quantifiable data (e.g., surveys, interviews, RFP evaluation scores) that can be analyzed, and categorized. You will see trends and commonalities that you would not see if without the rows and the columns. It will force you to think through the data, and give you more credibility in the eyes of your client. 

Eureka moments happen in Excel

Although people think of PowerPoint for its graphics and visuals, it is when you are analyzing data with excel that those Eureka moments avail themselves. Powerpoint is for telling stories. Excel is for uncovering the real story.

Visualization: 

I realize that a lot of data-discovery now happens in Tableau.  It makes excel laborious, I get it. An Analytics director once told me, “If I had to use Excel instead of Tableau, I would refuse.”  Perhaps the post should be re-titled, find the data, put it in Tableau.

 

Related posts

Share This