A Simple Guide to Data Analysis For Key Account Managers

Key Account Managers rely on data analysis to understand their client’s performance and to identify trends and new opportunities. Get started with this guide.

A Simple Guide to Data Analysis For Key Account Managers

As a Key Account Manager, your client relies on you to analyse information and discover insights that help them to make better and more strategic decisions.  Devoting regular time to developing an analytical mindset to help you understand and solve problems is a cross skill that will serve you well in any industry and help future-proof your career.

So if you've neglected your analytical skills, read on for some tips to survive in the world of big data.

Data analysis for key account managers

  • Data analysis is here to stay.  You need to keep learning and build your skills in order to stay relevant and future-proof your career
  • Improve your problem solving with fun board games like chess, learning a new language or setting up a habit tracker.
  • Data analysis is less about math and more about detective work.  Look for clues.
  • You only need to master 4 basic analysis concepts: relationship, composition, distribution and comparison
  • Excel is your friend.  Spend time getting to know each other better.
  • Data needs you to tell a story.  Share what's interesting and has an impact.  Leave out the boring bits.
  • Tell your story visually.  Charts and infographics are an easy and compelling way to share information in a way that's easily understood.
  • Colour and layout are important.  Choose a colour palette that observes the rules of colour theory and use a grid system in your presentations.
  • Keep learning

Getting started with data

If you've not crunched numbers in a while, then you may need to give the left side of your brain a nudge.  Activities like board games (e.g. chess) and puzzles can improve your analytical thinking.

Statistician Nathan Yau, in his excellent post How to Think Like a Statistician - Without the Math, shares the important things he learned when playing with data, and they don’t require a Masters Degree:

  • Attention to detail: Don’t just look for trends and patterns – you also need to be observant to outliers, data points and inconsistencies
  • See the big picture: Zoom out, maybe the story looks different.  For example, don’t obsess over one day’s worth of data if you’re reviewing an entire year.
  • No agendas: Obviously, you’ve got a purpose for reviewing the data but keep an open mind.  You may find patterns that surprise you.
  • Look outside the data: The numbers alone may not give you the context – you might need to go to other sources to reveal the who, what, where, when and how.
  • Ask why: If you find some data odd, investigate.  Mistakes happen.

The Basics

Data becomes far more interesting - and valuable - when you understand not only what happened, but why.   As a Key Account Manager, you understand your business and your client like no-one else and are in a unique position to bring the data to life.

Before you start thinking you hate math, let me reassure you that most Key Account Managers will only need to understand 4 basic techniques:

  • Relationship - determining whether there is a link between two or more variables.  For example, ice-cream sales and hot weather.
  • Composition - the way in which a whole or mixture is made up.  For example, what type of queries generated support cases.
  • Distribution - all the possible values of the data and how often they occur.  For example how often airlines are on time.
  • Comparison - the calculation and display of the differences and similarities between data.  For example annual sales this year compared to last year

Your current reporting tools probably give you everything you need.  If not then to get to grips with these models, I'd suggest this free training course from Excel Exposure. They offer a superior range of video tutorials from beginner to advanced, covering data analysis and Excel in detail.

If you want to explore further, some introductory statistics knowledge will help you interpret data more easily and reliably.   As a Key Account Manager it’s unlikely you’ll need to get too deep into the subject,  so here are the concepts I think are most helpful to know.

The ability to take data—to be able to understand it, to process it, to extract value from it, to visualise it, to communicate it—that’s going to be a hugely important skill in the next decades.

Dr Hal R. Varian // Chief Economist, Google

Become a storyteller

Data doesn't speak for itself.  In fact, it can be painfully shy.

Key Account Managers are there to guide the conversation and coax the data to reveal what's interesting.

So how do you get started?

Jim Stikeleather, Strategist & Innovation Officer at Dell, outlines some ground rules in How to Tell a Story with Data:

  • Find the narrative: Share the facts of course, but also share what story is emerging from the data.
  • Think about your audience: Is it someone new to the topic, or an expert. Perhaps an executive that’s only going to skim for the significant facts and conclusions.  Know who you are targeting.
  • Be objective: It can be hard, especially when the data doesn’t always tell you what you wanted to hear.  Present alternative views and importantly use visual choices that aren’t misleading.  For example, representing a survey result in a pie chart with  “67% agree” sounds like an important observation, but is misleading if you only had 3 respondents.
  • Don’t censor: Leave the data alone.  Try not to mess with the source if you can avoid it.  There may be some cleansing involved, but don’t start adding or excluding data until you know what it’s saying.
  • Edit: Less is more.  it might look good but if it’s not really saying anything, get rid of it.

Brent Dykes, Director of Data Strategy at Domo, says, "A data story is an effective combination of data, narrative, and visuals that seeks to explain, enlighten and engage"

Communicating with data is an essential skill and plays a vital role in your business meetings, internal conversations, and other daily interactions.  Data has all sorts of fascinating stories to share, it just takes you to uncover them.

Data Storytelling

Explore data, discover insights, explain with visuals. Source: Adventures In Data Storytelling: Three Key Traps To Avoid

Start with charting

Clients are looking to you to organise the data in a way they can understand.  As an Account Manager, you’re the subject matter expert on your products and services.  How these interact with your client and the successes, risks and new opportunities emerging are key themes your client wants to know.

Presenting your data in a chart is one of the best ways to emphasise important information, tell your story and for that story to be repeated by your client to their stakeholders.  If you're new to charts, I highly recommend Hubspot's fantastic and easy to follow tutorial How to Make a Chart or Graph in Excel.

Let’s consider this simple before and after example by Birch Studio. Both the report and the charts below compare actual budget allocation.  The charts make it much easier for quick comparison of data sets and require minimal processing time in the viewer’s mind.

A Simple Guide to Data Analysis For Key Account Managers

One of the challenges with visualising numeric data is deciding which chart to use.  If you’re not sure, check out this handy diagram, designed by Andrew Abela. the author of Advanced Presentations by Design: Creating Communication That Drives Action.

Just start from the centre and follow your way to the perfect chart choice.

A Simple Guide to Data Analysis For Key Account Managers
This SlideShare also covers the fundamentals of chart design including chart types and when to use them, as well as design best-practices like colour schemes.

Use infographics

If you struggle with charts and dashboards, think about using an infographic to tell your story.  They're actually very easy to create to visually present your information and very compelling - particularly when you want to communicate your message to a wide audience.

Visme is a drag-and-drop online design tool.  They also have an outstanding blog, The Visual Learning Center.  It’s a fantastic resource to help you become a better visual communicator and storyteller. If you’re interested in getting started with Infographics, their 3-part series is a must read:

Visme has also launched a free Make Information Beautiful Video Series offering practical advice on communicating visually and improving how you present data.

Presentation design tips

Color theory

Using colour is helpful to highlight the important parts of your presentation.   Stick to 3 to 4 colours, and observe colour theory.  If you don't know what analogous, monochromatic and triadic schemes are, don't worry, neither do I.

Check out Adobe Color Wheel which lets you to select your primary colour and then gives suggestions based on the rule of your choice.

Your business may already have brand guidelines which catalogue things like fonts, colours and chart styles to ensure a consistent theme is applied to any collateral.  Check with your marketing team if you can't easily find it. 

If there are no brand guidelines, then why not build one or at least use a colour scheme that's sympathetic with your logo.

Use a Grid System

Moving your charts from Excel into a presentation is simple.  It's just a matter of Copy and Paste.  Using a grid system in your presentation can allow elements to be displayed in consistent locations, and helps the viewer absorb information more quickly.


  • Statistics How To. This is the only site you are going to need.  It’s a comprehensive database of more than 1,000 articles on elementary statistics and help.  Their tagline is Statistics for the rest of us!
  • Microsoft’s Excel Training Centre. Is a great place to start.  it covers everything from worksheet basics, data analysis, charting and formulas in great detail and really helpful tutorial videos.
  • Chandoo.org. Microsoft’s help pages will only take you so far.  Once you get into complex data or advanced functions, you’ll need to move on.  Chandoo.org is one of the best sites around providing great Excel guides for all levels of expertise.
  • Mr Excel Message Board. More than 30,000 Excel questions a year are answered at this forum.  With a massive active community of Excel gurus all generously sharing their wisdom, I return to this site again and again to find the answers I need.
  • CourseDuck. A massive list of 150+ of the web's top Excel courses, tutorials and other training content. . Rankings are based on more than 10,000 student reviews.

Further reading

Data Analysis doesn't have to be hard if you focus on the basics

Warwick Brown

Warwick Brown is one of the leading key account management experts in the world. Through The KAM Club, a global membership community for key account managers, his blog that reaches 20,000 people every month, and a range of training and coaching services, Warwick has helped thousands of key account managers get better results, faster.


data visualisation, excel, powerpoint

Want more actionable ideas every week?

Join thousands of sales, customer success and key account management readers and subscribe to the One Step Ahead newsletterEnter your email to receive new ideas that grow client revenue and retention, as well as high quality career, business trends and productivity insights - direct to your inbox. For free!

Account Manager Tips