Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • Contributors
    • FP&A Trends Digest
    • FP&A Trends Research
  • FP&A Board
    • Amsterdam
    • Austin
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • Miami
    • New York
    • Paris
    • Perth
    • San Francisco
    • Seattle
    • Shanghai
    • Singapore
    • Stockholm
    • Sydney
    • Tokyo
    • Toronto
    • Washington D.C.
    • Zurich
  • AI/ML Committee
    • Introduction
    • Meetings
    • Members
    • Resources
  • Video Content
    • Digital FP&A Boards
    • FP&A Webinars
    • Short Videos
  • Contact Us
  • About Us
    • Ambassadors
    • Privacy Policy
    • Company Policy
    • Editorial Guidelines
    • Our Sponsors & Partners
image

FP&A Trends Survey 2023: Define the future of FP&A 

Click here to view details

 

Microsoft Journey: Becoming Next-Gen Finance Business Partners
New
July 21, 2021

By Takeshi Murakami, Group Finance Manager at Microsoft

FP&A Tags
FP&A Business Partnering
FP&A Transformation
FP&A Technology
FP&A Case Studies
AI/ML FP&A
FP&A Strategic Planning

fp&aOur business environment is changing dramatically. Smart devices, smart offices, and autonomous vehicles are boosting and creating avalanches of data every day. Big data will benefit a business. It enables businesses with greater insights and new opportunities, but only if you are able to manage it well.

Modern Finance: Main challenges and four focus areas 

Today we face challenges such as surging data, legacy systems, inadequate tools to anticipate growing business complexity, manual work which will eventually lead to error-prone processes, generate even bigger problems, risks and threats. 
 
To overcome these difficulties, these are examples of the modern technologies which we leverage at Microsoft. 

There are 4 categories.
 
fp&a

  • The “Financial analysis and reporting” section is about creating data consistencies and how we leverage business intelligence (BI) tool and automate reporting to be more agile in the business decision-making process. Moving away from manual excel work.
  • The “Strategy and forecasting” section is primarily about artificial intelligence (AI) and machine learning (ML), where we leverage it for forecasting, prediction and capacity planning and what not.
  • In the “Business process automation”, one example is to leverage chatbot for basic Q&As to improve agility and efficiency.
  • In the “Risk Management” section, taking "compliance predictive analytics" as an example, this is where AI captures unusual transactions automatically, flag them, and inform finance controllers what they need to do, to follow up. We are now in the stage where machines can provide recommendations and tell you what to do.

Microsoft Finance journey: Four stages towards automation

Of course, these changes did not happen in one day. Before we moved to Modern Finance where we leverage technology, we spent a huge amount of time to cleanse the data. Unless the data is clean, we cannot put the data and run an AI or ML model.

This journey started from the shared services centre (SSC) around the year 2000, where we consolidated our global routine task to three central hubs – in America, Europe and Asia.

Next comes the business process outsourcing (BPO) project, we call these stages "One finance" and "Core finance". At this stages, the main goal was to simplify, standardise and centralise the report and data that existed worldwide. During this BPO journey, the definition and taxonomies of the data are streamlined and standardised, and much cleaner at a worldwide level. This enabled the company to consolidate the data and review the data holistically across countries and vertically by-products and segments.

fp&a

To accelerate centralisation and standardisation across the company, we discouraged each country to create their own local reports and encouraged them to use the one that is "centralised", or use the BI report that HQ centrally created. For example, at our quarterly business review, the data and metrics in the deck are based on the reports from BI created by HQ. We are not allowed to add any locally created metrics in the deck. It was a journey of trial and error and took time, but it enabled us to drive automation and, thus, move on to the next step we started around 2014 to the stage which we call “Modern Finance”.

Practical recommendations: turning data into actions

Step 1: Prepare your data

At first, you need to clean up the data and create a single source of truth. Many companies are still in this data cleansing phase. Once data is clean and easily available, the company can start utilising business intelligence (BI) and advanced analytics. 

Step 2: Utilise business intelligence tools 

Excel is about static reports that could only tell what happened. They do not allow the drill-down capability and do not produce insights for the Business. Furthermore, the amount of manual process and work that the finance team has to put together to build these reports and then produce insights is huge and time-consuming.

On the contrary, Power BI is an interactive report. It makes meetings much more dynamic and helps understand why it happened on the spot and reduces the amount of manual processes in the daily reporting and analytics. In Japan, the Microsoft finance team follows the motto: "Don't bring back any homework". The BI tools help the team solve the problems within the meeting. In the past, if we were reviewing numbers from Segment A and the management asked about the same numbers in Segment B and Segment C, we did not have the data right away and needed to take time to prepare it in a couple of days. This delayed the decision-making process. The BI tool helped us immediately respond to such ad-hoc requests and drive business discussion with agility. 

Step 3: Explore capabilities of advanced analytics 

Although we achieved a lot of efficiency improvements with BI tools, we still could only look at the past and were not able to predict the future. Therefore, our next step was to leverage technologies and start looking at the future with advanced analytics:

  • Machine learning (ML) enabled us to learn from the past to predict the future. We can know what will happen. The distance between data and action is shorter, the amount of manual processes and human errors is lower. If you are interested to learn more about the use of ML in Microsoft, check out one of the FP&A Trends videos.
  • Machine learning combined with bots helped us understand what to do and move really fast from data to decision. For example, in compliance predictive analytics, AI/ML flags the unusual sales transaction and notifies the finance controller to check the detailed information on these transactions. 

The below chart summarises the Microsoft transformation journey. The key message here is “Clean your data and turn it into action”. Being a modern finance professionals means adding value to the business in the fastest and most relevant way.

fp&a

Step 4: Ensure that your team has the right skillset

Technology can automate things and accelerate your decision-making process, but you need a strong leader to drive this change, a process to run it and a team to make this change. The way we do business at Microsoft and how we interact with business partners is changing, so is the average skillset. Technology has freed up our time, but we now need to use this time wisely.

In the past, requirements for finance professionals were about operational thinking, expertise in handling transaction and task management. Now modern technologies have automated these tasks for you. Today’s skillset is about having deep analytical and strategic thinking, ability to influence business and negotiate. Finance professionals are expected to spend time on higher ROI tasks, provide a greater impact and, thus, drive business. 

fp&a

In summary

With modern technology, imagine just how big of role finance can play in business discussions and driving business with actionable insights. I am really excited about all the great changes coming for finance professionals.

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Related articles

planning
A CFO’s Capital Planning Journey: Partnership, Data and the Pursuit of Growth
July 15, 2021

CEOs that are more strategically oriented and less numbers-oriented tend to want to partner with a...

Read more
partnering
4 Key Steps to Become a Trusted FP&A Business Partner
April 28, 2021

Every FP&A professional has an active role to play in business partnering, supporting the leadership team...

Read more
fp&a
A Guide for Big Data and the Transformation of FP&A
May 26, 2021

FP&A teams are skilled at pulling data from various information systems, manipulating it, and gathering insights...

Read more
Artificial Intelligence
Making Artificial Intelligence Real for FP&A Professionals
May 5, 2021

In today’s world, companies need more than ever fast insights to make the appropriate critical moves...

Read more
fp&a
Financial Planning: Sources of Soft Data
July 5, 2021

The financial numbers only show one side of the story. When FP&A professionals are presenting the...

Read more
Sourcing, Managing and Using Information in FP&A
Sourcing, Managing and Using Information in FP&A
August 20, 2020

Today’s finance and accounting professionals face ever-growing challenges when it comes to data. The simplest analyses...

Read more
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

The FP&A Trends Webinar: The Winning Formula for Integrated FP&A

Click here to view details and register

Pagination

  • ‹‹ Previous
  • January 2023
  • Next ››
Su Mo Tu We Th Fr Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Inside the Crystal Ball: Top 7 Trends Shaping FP&A in 2023 and Beyond
 
22
23
24
25
26
27
28
Five Critical Roles for Building a World-Class FP&A Team
 
29
30
31
1
2
3
4
 
 
 
 
All events for the year
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Future Meetings

Geneva FP&A Board
The Face-to-Face Geneva FP&A Board Five Critical Roles for Building a World-Class FP&A Team
February 7, 2023
The FP&A Paris Board
The Face-to-Face Paris FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
February 9, 2023
Zurich FP&A Board
The Face-to-Face Zurich FP&A Board Five Critical Roles for Building a World-Class FP&A Team
February 9, 2023
Moving from FP&A to Extended Planning and Analysis (xP&A)
The Face-to-Face Dubai FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
February 15, 2023
FPA Integration
The FP&A Trends Webinar The Winning Formula for Integrated FP&A
February 22, 2023
Five Critical Roles for Building a World-Class FP&A Team
The Face-to-Face San Francisco FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 7, 2023
The Face-to-Face Houston FP&A Board
The Face-to-Face Houston FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 14, 2023
New York FP&A Board
The Face-to-Face New York FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 16, 2023

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • Miami
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2023 fpa-trends.com. All rights reserved.

0