Excel tip: How to clean duplicate rows

Data is often imperfect As consultants we know that perfect data is a myth. No matter the organization or website, data is gunky, irregular, and often broken. Was at Starbucks this morning doing my travel and expenses. Went to the American Express website and...

I am sorry.

When you’re sorry, just say the words I said this to five different people on Friday. “I am sorry”. An overly curt email. Late for a meeting. Over-stepping bounds, a little disrespectful of the staffing process. Not bringing an extra copy of a...

What is return on equity (ROE)?

ROE (return on equity) Yes, this is one of the key formulas that most MBAs (yes, including Marketers) remember learning on their path to financial literacy. It is often the best FIRST place to start for financial statement analysis. In simplest terms, it tells...

Human slavery still exists?

Christmas morning and I am pretty comfortable at home. Warm, well-fed, and laughing. This is in stark contrast to many kids in the world. Pope Francis pointed out the plight of children in his Christmas address here:  “. . children displaced due to war and...

Do you know the 4 happiness chemicals?

Ran across this article on the four chemicals that are responsible for our happiness. Sad to think that our happiness is just a bunch of chemicals – but science does a great job of de-constructing our world, for the good of our health, but the death of mystery....

Discussion: Gender equality in consulting

Gender blind consulting?  For any of us in management consulting, we are fairly blind to gender in the work place. You see men and women partners, principals, senior managers, managers, senior consultants, consultants, analysts, and interns. Yes, I do believe there...

What is competitive intelligence? 20 tips

When I was working overseas, I was on a competitive intelligence project. It might sound super-crafty, and Mission-Impossible, but it was not. It was actually quite boring.  Lots of meetings to share information, and try to piece together the competition’s...

Foreign aid, a few charts and graphs

After reading some news this morning, I wanted to re-post this from 2 years ago about US foreign aid. For my non-American readers, hope you find this not-too-boring. Consultants make tables and graphs That is a large part of what we do. Please see some visualization...

What is the potential for MOOCs?

MOOCs are not new Massively Open Online Courses (MOOC) have been around in their current form for about six years. They continue their march to democratize education. If you are not familiar with these free online courses taught by some of the best professors in the...

Data analysis in 20 minutes

Consultants are in the business of taking messy, unorganized data and turning it into information, and hopefully, some insights. Here is a simple example of excel clean up, and the steps to copy, paste, filter, sort, and cleanse data. For most consultants, the data...

Consulting advice: Be, do, say

Be. Do. Say. I heard this for the first time 3 weeks ago. It makes so much sense.  In the overly-marketed world we live in, there is incessant advertising noise, propositions, and promises. Through the clutter of insincerity and puffery, which brands and people can...

Consulting advice: Like your boss

If you like your boss = winning There is significant evidence that shows that “liking your boss” is a huge source of work satisfaction. Put another way, if you don’t like your boss, you will not be happy. Accenture says 31% of people leave their job...

We all watched the video, start with the WHY

There is a famous TED talk by Simon Sinek called How Great Leaders Inspire Action. 57 million have watched it so far. If you have an interest in consulting, management and persuading people into action, you need to watch it here.  The concept is basic, but powerful...

Kenneth Feinberg: What is a life worth?

Consultants solve ambiguous problems   So do lawyers I recently watched an interview with Kenneth Feinberg, a famous lawyer, and was struck by his confidence, poise, professionalism, humor, and mindfulness. All traits that consultants should try and emulate. Even...

Opportunity cost: no decision is free

Opportunity cost = what if?  I first learned about opportunity cost in college. It was a radical idea for me at the time, and frankly, clients and consultants probably don’t think about it enough. The idea is simple, but powerful; resources you plan to spend...

BCG: Six simple rules to manage complexity

BCG has a new book  They make the argument that companies have a bad habit of responding to complex business environments by simply getting more complicated. This is so true. For those of us who have worked with Fortune 500 clients, there seems to be an endless number...

Resumes are bait, make it count

I am not in HR, a recruiter, or even a super linkedin.com user. That said, I was on the recruiting team at a Big 4 consulting, and we looked through hundreds of resumes every year and 90% of them went into the trash. We probably spent less than 15 seconds on a cover...

Get a MBA? Pros and Cons

I got my MBA many years ago. It was a good use of my time, attention, and money. That said, there are a lot of skeptics out there, and they have good reasons. 3 Cons of the MBA Inflation. Typically the more of something there is – all things being equal –...

BCG report: Ending the Era of Ponzi Finance

Not sure how this happens, but the entire developed world is in debt. Europe, the US, and Japan have borrowed so much money that they are headed towards ruin. The Boston Consulting Group even went so far as to call it the biggest Ponzi finance scheme in history. That...