The 5 skills for kick-ass business analysis

A heavily underrated discipline in most companies is that of business analysis. Whenever a company decides to ‘get smart’ on products, customers and marketing, it should reinforce its business analysis leg. That does not mean companies need to hire armies of ‘beancounters’ that sift through the financial statements to explain variations to budget. It also does not mean hiring a legion of heavyweight controllers. It’s more than that, and the bulk of the work can be done with a few skilled analysts. As long as they keep this in mind:

  1. Most business models are very simple – and can therefore be analysed similarly. Most  companies are either in manufacturing goods or in providing services. They either sell it to end consumers or to other businesses. So here’s a few exercises you want to be doing when analysing your profit line.
    1. breakdown by major family of products (or service). Work with lines containing 6 columns: the revenue (vs bud or prior year), quantity (vs same), the price (vs same). Repeat this line for every major product family and you’ll have a clear overview.
    2. follow up sales: are certain products related to each other? Do we sell them in equal quantities to the same customers. Did we sell them pieces of equipment that will require spare parts/consumables? Do we sell it to them at the expected volumes?
  2. YTD? YTG! 90% of all managerial reviews I sit in, review the actual performance from 1 Jan that year until now. I understand that’s what the bonus depends on, but it’s also a bit like driving a car by looking only into the rear view mirror. A really proactive business analyst almost naturally will work on a landing forecast, connecting the Year to Date (YTD) results with the Year to Go (YTG) forecasts to have a good view.
  3. Start with end in mind: one of these good habits of highly effective people: When swimming upstream in the endless river of data, it’s very easy to drown in it. At all times, keep an eye on what information you need to get. In the end, it’s not about the volume of data you crunch, it’s about the information you turn it into. A good example is the Pareto analysis, one of the best ways to visualize and prioritize.
  4. Ratios: decide with the management on a few key ratios that will serve as the Key Performance Indicators (KPI) for the business. Chart their evolution over time, it will show deterioration/improvement quicker than other financial statements.
  5. Technicalities: ‘Garbage in is garbage out’ as the adage goes. That indeed is true for the business analyst. What is needed in the first place is data, flat data. By ‘flat’ data I mean having all data (down to the individual invoice line) in one sheet, consistent, with the fields next to each other in columnar format. No half fabricates that already contain subtotals and special grouping, that will come later in the mapping you do yourself. That way it is easy to crunch it in Excel or Access. Consistency is easily reached if data are delivered in flat form. On top of that, you need the confidence to handle these often huge datasets. And for that you need deep excel knowledge, where in my opinion the most important ones are vlookup and pivot tables. Macros are however not essential.
Advertisements

About curiousmanager

In life there are generalists and specialists. Although your job pushes you down towards a certain specialization, I feel it's important to keep your eyes and mind open for new stimuli. And I want to share my journey through arts, literature and sciences with other knowledge workers and managers. You don't have time to read. Let me do that for you and present only the best of the best in my blog!
This entry was posted in Finance for Curious Managers and tagged , , , . Bookmark the permalink.

9 Responses to The 5 skills for kick-ass business analysis

  1. Pingback: The difference between a Business Controller and a Financial Controller | The Curious Manager

  2. Marva Wootan says:

    certainly like your web site but you need to check the spelling on quite a few of your posts. A number of them are rife with spelling issues and I find it very troublesome to tell the truth nevertheless I will definitely come back again.

  3. I’m extremely impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself? Either way keep up the nice quality writing, it’s rare to see a great blog like this one today..

  4. Pingback: The Ultimate Business Case | The Curious Manager

  5. Pingback: Business Controller « Ernest CHS

  6. nyenstad says:

    All you need is flat data, vlookup and pivot tables – true! Find a way to extract data from ERP, columnize it, and you are good to go!

    • diego luna says:

      Anybody knows an specific system (nor ERP or excel neither) to link KPI, financial information, executive reports?

      Great blog by the way

      • hi Diego,
        one of the systems I looooove to work with is Qlikview. The concept is easy: it will read in a data cube, and in a very user-friendly environment you’ll build queries for KPIs and reports. As the datacube refreshes overnight, so do your reports. Best of all you can download a free copy for individual test use on the site!
        Could you do me a favor and spread the word on this blog, i could use some traffic 🙂

  7. Pingback: The most common pitfalls when implementing a new ERP | The Curious Manager

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s