Have CFOs Changed Their Mindset When It Comes to Data?

Michael Ingemann
Michael Ingemann
2017年8月14日 3 分で読める

In short, no. Thanks for stopping by the blog. See you next time.

But wait! As always, we need to consider whether this is a “glass half empty” or “glass half full” situation.

Most CFOs and their finance departments remain application driven – so whenever a new requirement for reporting and analysis arises, they sit down to develop a specific solution addressing the requirement (i.e. IFRS 15 – Revenue Recognition etc.).

It’s one thing to design/develop the new solution to support the reporting requirement, but the majority of CFOs and their finance departments completely forget the related and additional steps that are necessary to actually deliver the new reporting requirement. The below is by no means and exhaustive list of steps, but it gives you some idea of the scale of the problem:

  1. New data extracts (extract, transform, load)
  2. New data reconciliation steps
  3. New metadata
  4. New business rules
  5. More reconciliation steps
  6. New semantic models (for output)
  7. Review of the data
  8. Increased likelihood for changes (i.e. data looks wrong => new data request or similar)
  9. Final update
  10. Ready for consumption (distributed to relevant stakeholder)

As the observant reader now realises, most of these steps are exactly what finance departments are already doing when preparing other reports and analyses – as you can see from the following graphic:
Now that I’ve complained a bit about the lack of ‘vision’ at CFO level and across the finance department, I must emphasise the fact that a few organizations globally have seen the light, moving away from the application driven mentality. These companies have developed a finance foundation based on enterprise resource planning (ERP) and non-ERP data at the most granular level. It looks something like this:
The benefits of being a data driven finance department are huge, especially in these three areas:

  • Analytics:  Multi-dimensional profitability solutions based on ABC principles become the foundation of every type of report and analysis
  • Data quality: Significantly improved because the establishment of the finance foundation shines a light on the areas in need of improvement when, for example, updating operational systems, issuing a PO or SO etc.
  • Speed: Data for reporting and analyses is available in real-time. Data ‘massaging’ is also automated, with the ability to drill through (of course, aligned with security profiles)

And finally, the killer argument: all reports and analyses reconcile with the general ledger and any other data source that has been used.

Creating a finance foundation begins with re-establishing the joins between ERP and non-ERP data, which have a direct relationship. Those joins, incidentally, were removed  when non-ERP data was converted or transformed into ERP data. You may wonder how that could possibly be the case, and the simple and sorry answer is this: if the two weren’t linked, the ERP system would crash. ERP systems are meant for automating manual processes related to Purchase-to-Pay, Order-to-Cash, Make-to-Order, etc., not for detailed reporting and analyses.

Activity based costing principles for revenue/cost data should be dynamically applied via identified cost/value drivers.

The result is a finance foundation capable of addressing all reporting and analytical needs in and around the CFO department – making it possible to view and analyze any relevant dimension related to profitability (i.e. customer, product, service, event etc.) – and in parallel use the same data for other types of reporting and analytics.

Glass half full

Because some CFOs and their finance departments are actually moving in the right direction; shifting from the application driven mentality, and instead becoming data driven, the metaphorical transformation glass, it would seem, is very much half full and slowly filling.

Bookmark this blog to keep up with future topics including: tangible and intangible benefits; how to start your analytics journey; what not to do with data; and why CFOs have been slow to adopt a data driven approach.

会社情報 Michael Ingemann

Michael Ingemann is the Practice Partner for Financial Management at Teradata International. Michael started out as an auditor in Coopers & Lybrand (now PwC) in the early ‘90s and has ever since worked in a variety of senior finance positions in different industries (Oil & Gas and Airline). Since 2002, he has been working as a senior management consultant delivering all kinds of finance transformation projects for companies in Europe and Asia, where optimization of the Finance department and enhancing their analytical capabilities, via usage of all data, have been the key elements. At Copenhagen Business School, Michael has earned an HD in management/financial accounting (HD(R)). In addition, also from Copenhagen Business School, he has also earned an Executive MBA in General Management.

すべての投稿の表示 Michael Ingemann



テラデータはソリューションやセミナーに関する最新情報をメールにてご案内する場合があります。 なお、お送りするメールにあるリンクからいつでも配信停止できます。 以上をご理解・ご同意いただける場合には「はい」を選択ください。

テラデータはお客様の個人情報を、Teradata Global Privacy Policyに従って適切に管理します。