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...

Build trust, it’s increasingly rare

It’s all about trust I am in the people business. I teach, train, write, read, talk, record, coach, listen, and persuade . . . people. Recent interactions, good and bad For the last 6 months, when I look back on my emails and text messages with the 100+ people...

Good day for me, Tableau stock up 20%

I am a terrible stock-picker Trust me, my portfolio returns lag the general market. If you read about a stock on this consulting blog – just look the other way. I am writing about it because management consultants need to understand how the capital markets,...

Consultants eat well; don’t get fat

Consultants eat well No question about it. Consultants are foodies. We treat good restaurants like wild game. Find them. Eat there. Of course we cannot, do not go to $$$$ restaurants on our client’s dime, but we do eat at $$ restaurants and expense it. Rarely do...

Autumn leaves, New York 

Worked like a dog this week. Got a $284 speeding ticket. Need some changes in the working team. However, life is still good. Check out these leaves from New York, where the client site is. Enjoy.        ...

Consulting week recap in 16 photos

Photos capture a lot Busy week shown in photos. Two projects and alternate travel today to the west coast. Good times. The collage app is called Photogrid.  Guns and Roses and Queen on Pandora while waiting for security. Super long lines, but bearable with music and a...

Travel folly: Oh #$^#, this is not my room

Today was a travel day – like most Mondays.  There were two odd things about today. Good thing – no one next to me on the plane There was no one sitting next to me on the plane today. I completely spread out, and put my stuff in the seat next to me. It...

Presenters, the PowerPoint is there to help

Reading PowerPoint = Painful to watch Last week I was a in a painful 1 hour meeting where the presenter kept reading his slides. Ouch. Each page was like a kick to my shins. Imagine, this is what clients see and feel when you read your PowerPoints.   PowerPoint is the...

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...

Consultants need to get paid, get the AR

Accounts receivable (AR) is what people owe you For anyone who has written an invoice or had difficulty getting a client to pay you for your work, you know how awkward and stressful it is wait for the money. Checking your email, mailbox and bank account to see in...

Consultant 6am flight home: 3 photos

Traveling is exhausting How strange is it to commute by plane. We are whistled in by clients, ready road-warriors, bringing news from far away. Our time is “valuable”, marked by our bill rates and our inaccessible during travel times and Fridays. Travel...

Who reads this blog? 10 survey results

Thanks for reading this blog (written in 2015) I have enjoyed your company and comments. Hope you find this stuff – not so boring – and potentially helpful. Some survey results which hint at www.consultantsmind.com readers. As my wife flattered me and also...

Consulting tip: Read the Economist

I have been reading the Economist since 1991. So many reasons I like the magazine: Clear thinking, clear writing International in scope; not America-centric Libertarian thinking, but not “gold standard” fundamentalist Opinionated; strong point of view...

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...

Working at the Hotel

“It’s 1am and I am working on a proposal due this Friday from the hotel lobby. It has to go through multiple reviews, so I would be wise to get it 80% finished tonight. Oy Vey. Walking around the hotel – to wake myself up – this is what I see....

Creators vs. critics

Had dinner with a good friend last night, and we talked about the two kinds of people you meet online: creators and critics. Think about all the titans of podcasting. 1. Creators There are people who give generously and want others to win. You can call them givers....

Bain & Co: Stop wasting valuable time

So I am a procrastinator. I will just admit it. Don’t make me give you examples. . . This is the right Bain & Company blog post for me here.  Basically, here are Bain’s 7 ways to stop wasting valuable time. Get the most out of your executives. . . Bain...

Mad Men had it right, do the work

I am Generation X and I am getting tired. Getting tired of asking for permission to ask junior consultants to do work.  Tired of the fear of offending their sensibilities. Tired of doing the thinking. Tired of trying to “charge them up, get them excited”...

Work with people you like and trust

In 2014, I interviewed about 50 people for positions in our consulting group. Most of the time, I am giving case interviews to test people’s logical structuring, and analytic skills.  Sometimes, I have a chance to speak more openly – both the good reasons...

Metrics are important, and also over-used

Metrics are everywhere As a consultant, we are in the business of quickly understanding business problems, proposing solutions, and measuring results. Metrics are a necessary evil of any project. The classic continuous improvement methodology DMAIC depends on M...

What do consultants do?

It’s one person’s opinion, but here are 130 blog posts which I wrote over the last 3 years to describe my world-view of consulting. Hope you find it useful. Consultants are a strange breed We span all industries, but ultimately we are in the business of...

Big Design: McKinsey & Company buys Lunar

Design is popular.  It’s not surprising that McKinsey & Company bought a design company. Many consulting firms are branching out with acquisitions in areas which were once considered non-core. Deloitte has picked up a few digital agencies. Accenture bought...

Poor, slow decision-making is everywhere

Meetings are over-rated Okay, I said it. I have seen too many organizations put together committees to drive “alignment”, when in actuality, they are trying to mollify a miscreant or hedge away the risk by legislating an answer. Too often, it fails to...

Best work comes after an idea fight club

“Idea fight club” I coined this idea in 2015, this was the scenario: The consulting team had an ambiguous client problem (no surprise there) and the team had not set on an approach yet. Differing ideas, pros vs. cons. It was all on the table in a smart...

Consulting hack: Free movies on Delta Studio

I have flown Delta for 15 years, but just recently discovered Delta Studio. For those who don’t know, you can watch free movies and TV shows using GoGo Inflight Wi-fi. Phone: Download GoGo app.  Connect to wifi, open app. Click of Delta Studio. Laptop: Connect...

Relaxation: Cherry blossoms

Monday night in the hotel. Lots of work, but not in the mood. Instead, thinking about the cherry blossoms I saw with my wife this weekend. A much better thought. Related posts: Consulting travel The consulting life.  Good dinners...

How to get through rough manager days

From 2015: I have not blogged in a month because of international travel, 3 concurrent projects, and honestly, some of the toughest manager days I have ever had. Got some new folks, a fairly ambiguous project, and a lack of thinking. Sad, but true. A lack of real...