Presenting FP&A Strategy’s Data Maturity Model to Accelerate your Finance transformation
By James Myers, Global Finance Executive and Finance Transformation Consultant
It’s the middle of the year and it’s time to take charge of your “data destiny” before the budgeting and planning season starts. What exactly is your data destiny? No, it’s not the new Netrunner card game where the objective is to control all the data in the Universe.
It’s understanding how you can leverage all your internal and external financial and operational data to give you a strategic advantage. Relevant data is the key to understanding it all, but too often this is disbursed throughout your organization.
In 2017, Globally, 39% of all CFO’s are pursuing a significant upgrade in their company’s information, data, and communications systems (1). This trend is real and I’m already seeing companies moving swiftly to take advantage of new BI trends and hire more data-centric talent into their Finance teams. More than a “trend”, it’s a “shift”.
Why is this Tectonic Shift in Data happening Now?
- Data quality issues - Multiple data sources require manual aggregation & consolidation which are prone to error resulting in a debate about the accuracy of the number and not the insight
- Timing to insight - Low frequency and the length of time it takes to receive the insight, limits the ability of stakeholders to take early corrective actions
- Data is offline – adjustments and data manipulation are done in offline Excel spreadsheets, usually by one person and no one else knows how it’s done
- Data hoarders – Data is power and if no one else has it, it makes one important
Your Data Maturity model
FPA’s data maturity model is a step-by-step process to help you move along the value/maturity curve until you achieve your ultimate goal of game-changing data analytics.
Step 1: Aggregation = Single source
Having all your data in one place is the first major step toward data nirvana. This often requires a lot of IT heavy lifting, but it doesn’t have to be. There is new technology out there that will help, but my advice is to start small. Find the most critical data and focus on that – run through all the steps before on boarding the next set of data. This will enable you to prove out the solution and demonstrate the value quickly – Once you start adding value it will be easier to find more investment.
Step 2: Accuracy = Strong executive support
This step is all about agreeing on terminology and rules. This part is heavily reliant on all the stakeholders agreeing to a single naming convention; methodology and taxonomy – it’s all about standardization. In mature large companies, this can be one of the hardest tasks as it often requires change management. To ensure this part succeeds you will need to have strong executive support. You will also need to validate your data and bring the offline logic into the system. Accuracy is key as there is nothing worse than spending more time debating numbers as opposed to their meaning. You will need everyone bought into the idea that your single source of data is the only source otherwise you will fail in the next steps
Step 3: Access = Mastering dashboards
This is typically the easiest because of the development of powerful BI tools, but unless there is strong governance it can easily get out of hand (see Mastering Dashboards to Build Value). Good dashboards are designed to drive strategic initiatives into the company and to ensure users can identify issues quickly and know what corrective actions to take. Try to avoid dashboard design that results in: confusion; groups competing against each over or more common just being ignored. Security is key at this stage – making sure that the right users have access to the right data at the right time.
Step 4: Actionable = Think!
Building dashboards that keep us informed are interesting but don’t add a whole lot of value. Take revenue for example – this is a typical metric you will see on any dashboard e.g. how much have we booked to date; how are we performing to targets or year over year growth. What we really want is to drive actions into the organization. The best way to do that is to focus on the underlying drivers of revenue e.g. what is your pipeline conversion rate; what pipeline coverage do you have or what is the impact of your marketing promotions.
Step 5: Accountability = Support
The key to driving insight is starting with the business problem. Too often I see people bombarding their stakeholders with data, normally in the form of 70 page PowerPoint decks with detailed tables and 11pt type. That only alienates. Take a step back and take the time to understand your stakeholder and what’s really important to them. Spend time on understanding the drivers behind this and create dashboards that give your stakeholders key insights that help them identify the outcome of their actions. You’ll know when this support is working when they come back and ask for more.
YOU HAVE A DATE WITH DESTINY
This is the time for data leadership. Discerning and communicating it in a meaningful way to the organization is literally the most important job you will ever do! Use FP&A’s Data Maturity Model to accelerate your FP&A transformation. The time to get ahead of this is right now.
1. THE CFO ALLIANCE - 2017 CFO SENTIMENT STUDY: 39% of respondents reported they will be pursuing a significant upgrade in their company’s information, data, and communications systems in 2017, up from 29% in 2016