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
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
Microsoft Journey: Becoming Next-Gen Finance Business Partners
July 21, 2021

By Takeshi Murakami, Group Finance Manager at Microsoft

FP&A Tags
Digital FP&A Events Insights

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

Event Calendar

Pagination

  • Previous
  • May 2025
  • Next
Su Mo Tu We Th Fr Sa
27
28
29
30
1
2
3
 
 
 
 
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Transforming FP&A Together: Human & AI Synergy
 
18
19
20
21
22
23
24
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Five Critical Roles for Building a World-Class FP&A Team
 
25
26
27
28
29
30
31
FP&A Business Partnering and AI: A New Era
 
All events for the year

Future Meetings

The Face-to-Face Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Transforming FP&A Together: Human & AI Synergy

May 15, 2025

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

The Face-to-Face London FP&A Board: Data Management & Analytics: Unlocking FP&A Value
The Face-to-Face London FP&A Board Mastering Data in FP&A: Smarter Analytics, Better Decisions

June 5, 2025

FP&A Trends Webinar The Evolving Role of FP&A: From Number Cruncher to Strategic Advisor
The FP&A Trends Webinar Making FP&A Teams Fit for the Future

June 11, 2025

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

AI/ML FP&A
AI/ML FP&A
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

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
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

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

0