Business Intelligence and the CFO

Business Intelligence and the CFO

Business Intelligence (BI) is at the crossroads of business and tech and it connects so many different aspects of running the business. It’s a very important, yet often misunderstood and underutilized, part of your organisation.?

When the data BI brings in is used in a smart and strategic way, it can produce incredible advantages. However, this department needs to be connected to an executive level manager who can manage and promote this data in an effective and convincing way.

TL;DR?

If you prefer listening over reading, tune into NotebookLM's Audio Overview for an engaging and convenient experience. It’s the perfect way to absorb the key insights of my article while on the go—whether you're commuting, working out, or relaxing.

Business Intelligence: Defined

Before I go too much further, let's first quickly define Business Intelligence - as this term has changed in meaning over the years.?

BI emerged in the 1960s as a way of sharing information across an organisation, but the advent of computer technology transformed and expanded this role. The Big Data Revolution has transformed entire industries and modern BI covers so much more now, including data mining, reporting, querying, data preparation and statistical analysis.?

Business Intelligence

The Business Intelligence department are collectors of data. They use a wide range of tools, applications and methodologies to bring in valuable data organisations can use to make smart business decisions. They pride themselves on impartial measuring and accurate reporting.?

Business Intelligence goes beyond just business analytics. Business analytics is one subset of BI, but there’s much more to it. This department brings in a huge amount of data from multiple sources, structuring it and defining it so that it can be used in practical ways.?

Every business produces data - no matter what you are selling. BI creates a comprehensive view of the data within an organisation, while using that data to drive change, adapt to the market, eliminate inefficiencies and more.?

Where does Business Intelligence fit into your organisation?

Dilbert accurate data

So, who is in the best position to assure acceptance of the data that BI brings into the company and make the most of it??

Most larger companies have the resources and organizational capacity to hire a Chief Information Officer (CIO), integrate them into the organisational structure and provide sufficient headcount, budget and support. In these cases the, CIO is likely the natural choice to lead BI.?

However, many smaller, medium-sized companies may face more difficulties, and the solution is not so obvious. Nevertheless, BI is still very important.??

So, if your company does not have a CIO or the resources or inclination to hire someone in this position, then how do you make the most of BI? If your company doesn’t have an executive leadership structure with a CIO yet, both the CFO and CTO come to mind - especially since BI brings business and tech together in a powerful way.??

When it comes down to it, the BI department should be aligned with an executive who understands the broad picture of the company’s goals, financial plan and strategy and can translate the company mission into concrete KPIs.?

In my opinion, it makes a lot of sense to let the CFO lead the introduction and launch of BI - as they are in the best position to do this.?

I have worked with some excellent CTOs in the past (you know who you are). However, in most companies the CFO is likely to be closer to the business than the CTO, because they already process, use and analyse a lot of (mostly financial) data. CFOs carefully curate high quality data and are highly involved in these types of big-picture strategic decisions. Generally if the data is accepted by a CFO as usable or correct, this means it can be relied upon and trusted.?

In fact, I believe that when CFO and Business Intelligence work together effectively, this can offer the company a huge strategic advantage.

Even if your company does already have a CIO - they should be working closely with the CFO when it comes to BI.?

Once BI is established within the organization, you may choose to separate it with a CIO and/or a Chief Data Officer (CDO) joining the C-level. Either way, whomever BI reports to, the buy-in from the CFO is highly important.?In particular the CDO needs the full support by the other C-level executives to make an impact.

The data harnessed by the BI department can be the secret weapon a CFO needs to offer valuable insight to their company. The CFO and the BI department are a good fit because they should be in close communication and implement strategic, tactical and operational changes.?

Why do the BI department and the CFO make such a powerful and valuable team, and how can you set up this partnership strategically for best results?

Business Intelligence is the key to offering more insight as a CFO?

Cartoon by Timo Elliott (timoelliott.com/blog/cartoons)

The CFO has an increasingly important role within any company - no longer simply accountants. In the past, the finance department had been in charge of keeping the books, managing the budget and looking after cash and capital.

Still today, when it comes to working with data beyond accounting postings, many CFOs and their teams mostly use Excel to collect data manually and store it rather than studying and understanding it. The result is disconnected and inconsistent data silos.?

However, as our global economy becomes increasingly competitive, it becomes even more essential for every member of an organisation to add direct value. The potential is there for CFOs to do so much more.?But this is an entire topic in itself. Here are some of my thoughts on how the mandate of finance is changing.

CEOs and Boards are demanding more from the typical CFO, counting on them to offer insight, advice and strategy for the company. That’s why this role is in a perfect position to make the most of the data Business Intelligence can offer.?

The finance department can be a powerful agent of change for the entire organisation. This makes the CFO and the BI department a perfect match: a powerful combination that can elevate a company to the next level.

As a CFO, the Business Intelligence department is your way of bringing more value to the organisation by having lots of high-quality data and knowing how to use it. A strong relationship with BI is what allows a CFO to do something more effectively with the data collected, enabling them to elevate their role from accountant to strategic advisor.?There is a relatively old, but still relevant white paper written by Wayne Eckerson that is worth having a look at.

It’s almost as if the powerful amount of data BI brings in will “supercharge ” the position of CFO, presenting them an opportunity to do more than just accounting.?

How Business Intelligence enhances the role of the CFO

Business Intelligence and the CFO

A CFO who is actively working with a Business Intelligence department will be of much more value to an organisation than the old-fashioned typical “accountant” CFO. Rather than just keeping track of the numbers, BI can help a CFO do so much more.?

Here are a few of the ways BI enhances the role of the CFO:?

1. Impartially collecting information

Companies need an unbiased stream of data that comes with no particular agenda or filter.?

The role of the BI department is not primarily to analyse or interpret the data. Instead, first of all it collects as much data as possible in a totally impartial way. This unbiased stream of data that comes with no particular agenda or filter is crucial for a company.?

Sometimes when those who are collecting data have motivations behind their search, they tend to discover data that supports the ideas they were trying to prove. This often happens naturally - and those who are guilty of it might not even be aware of it.?We are all guilty of confirmation bias in some situations and we need to work on overcoming it.

When the CFO accepts the data, this adds a lot of credibility to it. The CFO is discerning when it comes to data, so their acceptance of the data is a positive sign of its reliability to the rest of the company. When a BI department brings in data with the CFO's seal of approval, you can rest assured that they are not looking for the right data to support a particular position. The data is totally impartial, scientific and fact-based.?

The BI department provides the basis for clear and scientific answers to questions such as “Who are your most profitable clients? How did your sales team perform over the last quarter?” “How much revenue did your most recent marketing campaign generate?”

With the BI department in charge of bringing this data in, the finance department can focus its time and energy on analysing the data, rather than collecting it. Unhindered by the goals and motivations of each of the separate departments, the BI department then brings the information to each respective expert so they can decide what data is most important and what to do with it.?

2. Corralling a wide range of data

CFOs have to lead by example in overcoming data silos and championing the use of a wide range of of data.

Having a bigger picture and a more robust set of data is extremely important when it comes to making business decisions. However, looking at a diverse range of data all at once can be confusing and overwhelming - unless you have a BI department to keep it organized.?

The BI department collects data from multiple sources and brings it all together to make it more manageable. When the CFO works closely with BI, this results in a change of mind-set regarding how to use data in the finance department in general. They will see the value in combining all types of data - from financial to non-financial.?

This will set a great example with the potential to ripple throughout the rest of the company. The team will start to think outside of the data silos of its particular department and combine data from all sorts of sources for decision-making.?

This means that rather than having lots of separate sources of data, all the sources can be integrated and used in harmony with each other. Without the BI department to organize and make sense of this stream of diverse data, it would be overwhelming noise.?

Without a strong BI strategy to bring this data together, it would remain siloed. For example, you might have web traffic data from Google Analytics, but no insight on how to use it to adjust your sales efforts or operations. This means missing out on valuable insights.?

3. Clearly defining the data?

As a CFO you have to support a single version of?truth throughout the entire organization, and make sure that it can be reconciled to financial information.

When the BI department defines the data, it establishes agreed-upon answers to the question of “what does this data mean?” Everything is quantified and described clearly and therefore can be used more effectively, because all departments understand the data in the same way.?

Without these definitions, the data can feel quite meaningless. Various departments within the business can use and interpret it in different ways, which is highly counterproductive and can lead to a lot of confusion.?

It’s essential for the definitions to be the same throughout the entire company and for there to be one single version of truth . This is crucial for ensuring that the data filtering from the BI department to the rest of the company is widely accepted.

If you are collecting data, but you don’t know what that data means, you won’t be in a position to use it effectively. What often happens is that various departments come up with their own definitions, which is incredibly confusing and leads to misunderstandings.?

For example, the definition of “active customer” needs to be the same in the marketing department as in the finance department - as well as everywhere else.?

Only then will you be able to establish a company-wide definition of essential KPIs such as CLV/LTV (customer lifetime value) and ROAS (return on advertising spend). When this is achieved the data can be combined and collected across the company for effective decision-making, planning and budgeting.

Instead of arguing about what the numbers mean, the team can spend its time identifying issues and agreeing on strategies going forward.?

4. Allowing for informed decisions?

Develop a data-driven culture by setting the expectation that all decisions are to be anchored in data.

One of the most valuable roles of the Business Intelligence department is providing information and context, which allows the CFO to make smart, informed decisions. Without this context, the strategies you use to run your business are merely guesses - hopeful stabs in the dark.

For example, let’s imagine that the company is deciding whether to invest marketing resources into retaining existing customers or marketing to new customers. This strategy cannot be figured out simply by making assumptions or doing what other companies have done; you need to look at the numbers.?

In order to make such a decision, there are some very important things to know. Let’s use the example of a SaaS business:?

  • How do you define the data underlying your most important customer metrics, such as new, active, reactivated, and churned customer? For example, is an active customer simply someone with an active account, or someone who spends a certain amount per month or uses your service a minimum number of times??
  • How much does it cost to market to existing yet dormant customers and win back their business again??
  • How much does it cost to bring a new customer through every step of the sales funnel and win their business??
  • How much, on average, does the typical existing customer spend compared to a new customer??

You must answer all of these questions before you can determine whether the ROI would be higher on marketing to existing customers versus new customers.?

This information gives context to the decision, allowing all choices to be as informed as possible. CFOs have to lead by example to develop a data-driven culture: Decisions are to be based on actual facts and numbers, rather than doing things “because it’s how they’ve always been done” or based on gut feeling. For some ideas how to start,?David Waller of Oliver Wyman recently wrote a good article on the 10 steps to creating a data-driven culture .

Also, it’s essential for BI to pre-filter with data sets that are safe to be used by others. This style of “self-serve BI” allows anyone to run the analyses themselves and not necessarily under the guidance of an analyst.?

?Instead of just feeding in meaningless data, the BI department helps to uncomplicate the data and deliver it in a way that makes it easier to use.?

5. Spotting weaknesses

Business Intelligence can be your informal internal audit department.

It’s often true that stepping back and approaching a problem from a different angle can bring better insight and fresh ideas.?

By collecting more robust data and looking at it from a bird’s eye view, the BI department is more likely to spot issues with the company that might not be apparent to each of the individual departments.?

There may be weaknesses in your organisation that are not readily visible from unusual reports. The robust and comprehensive data collected by the Business Intelligence department allows for this type of “full-picture” analysis.?

Also, the BI department has the potential to spot missing, incomplete and inconsistent data. This often hints at weaknesses in a company’s controls and processes, which is very important.?

This allows each department to make adjustments that could result in huge savings. You’ll be able to work proactively to prevent any weaknesses from causing problems before the end of the next financial period.?

6. Predicting trends

Take your forecasts to the next level by applying machine learning algorithms and advanced statistical methods.

A truly effective CFO doesn’t just react to past data. They make predictions and intelligent guesses about what’s coming up next and then prepare themselves.?

Rather than simply applying traditional approaches to forecasting, the complex data BI collects allows CFOs to use advanced methodologies to make projections for the future of the company and develop smart plans. Of course, it’s impossible to know the future with 100% certainty.?

However, with the right data you can make smart informed guesses and be ahead of the curve. What about a forecasting model incorporating over 200 variables as described in a recent article by McKinsey ? BI makes it possible! Without this aspect, many businesses remain reactive and lose their competitive edge, doomed to always fail to take advantage of the next smartest move.?

The BI department can keep up with developments in the industry, monitor changes in the market and anticipate customer needs. BI will also help the company discover its relative strengths and weaknesses against its competitors and identify trends and market conditions.?

Armed with this information, decision-makers can act swiftly and correctly and take a chance on potentially profitable opportunities.?

How to get started with Business Intelligence

Forecasting sheet

The position of the CFO is evolving to encompass so much more, which makes it a very exciting time to be in this role. By using the power of a BI department, you can elevate the CFO's role and bring more valuable, data-based insight to your company.?

Not only will Business Intelligence help you deliver more value in the role of CFO, but it will also benefit the entire business.?

A study by Nucleus Research revealed that an investment in analytics pays back $9 for every dollar spent. Such a phenomenal ROI is any CFO's dream. These fantastic results are probably the most enticing reason for CFOs to get involved with the Business Intelligence department.

If you’re ready to bring a business intelligence department into your company, but you don’t know where to start, here are a few important pointers:?

  • The type of CFO who can make the most of a BI department is one who is analytical and tech savvy. They will place value in the data the BI department collects and go into the process with their eyes open.?
  • Start by defining your business strategy, as well as the key performance indicators that will help measure whether you have achieved the goals of that strategy.?
  • I recommend ensuring that the BI department and the CFO are located close to each other. For example, in my company I even moved the BI and finance departments so they were located on the same floor.?
  • Clearly define roles. Everyone should know who reports to whom and about what aspects of the business.
  • Don’t be afraid to ask questions. After all, as the CFO it’s impossible to be the expert in everything, so don’t pretend you are. Instead, focus on being a competent partner to discuss these topics with. Work closely with the BI department and be inquisitive - so that you can fully understand what they are doing and how to apply it to your goals. They are at the crossroads of business and tech, and their expertise can be an incredibly valuable resource.?

Want to learn more about how CFOs can work together with Business Intelligence to offer more value in their roles? Want to discuss this and related topics in general? Feel free to reach out and contact me here on LinkedIn. I am always up for a good, inspiring discussion and exchange of ideas.

Andres Varela

Director at Blue Ant Consulting | Operations, Transformation and Product -working across other functions as needed | PMP | PSPO

1 个月

Nice. Here’s how I took the podcasting feature a little further to give voices *and faces* to a fascinating topic: my CV. https://www.dhirubhai.net/posts/andresvarela_recruiters-dont-always-get-me-so-i-generated-activity-7246123744392306688-a8Lw

回复
Dyana Rose Rivera

Finance Operations | Strategic Finance | Ex Country Head of Treasury at Lazada | eCommerce | Start-up

2 年

Definitely agree with this, Michael! BI plays a very important role not just in finance development but with the company as a whole. Thank you for sharing!

Eugene Lee

Building and changing people, processes, systems and organisations | Deepening understanding and bringing insights through compelling narratives | CA(Singapore) | ISCA PBA | ACLP

2 年

Thanks for the article Michael. Data is definitely a multi-faceted tool that can be used for many contexts. The main challenge is that currently the main datasets are scattered in different systems and formats. But even if we manage to get everything in one place, it stills need to be put in the right context to form the right narrative. This is not just a matter of competency, but also integrity and objectivity. There are examples of people using the data to say what it means, and also using it to say what it doesn't. It's crucial that Finance professionals involved in this area balance between partnering the business and giving them moments of truth. With suitable people using the right tools and appropriate approaches to get the relevant data across in a compelling way, the organisation is empowered to do more and better where it matters.

Grace Wang

Bybit Global,CPA, Fintech , Crypto,Web3

2 年

Looks great

Daniel Wong, CA, CFA

Finance Lead - Corporate Finance & Analytics at Octet

2 年

This is a very well-written article Michael. Very relatable and provided a lot of take-aways for me personally!

要查看或添加评论,请登录

社区洞察

其他会员也浏览了