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
Sourcing, Managing and Using Information in FP&A
August 20, 2020

By John Sanchez, Keynote Speaker, Corporate Trainer and Author

FP&A Tags
Digital FP&A
FP&A Analytics

data management in finance (FP&A)Today’s finance and accounting professionals face ever-growing challenges when it comes to data.

The simplest analyses can be complicated by the wrong data or bad data and too much data can even be a problem. Effectively sourcing, managing, and using data are key skills.

Data Collection Basics

When it comes to collecting data, keeping three V's in mind goes a long way towards ensuring you collect high-quality data.

Volume, variety, and velocity are attributes of data you should consider when collecting data.

VOLUME
How much data you collect should be a function of the relative value you can wring out of that data. Collecting every piece of data you can get your hands on might seem like the way to go at first glance, but many constraints make it wise to consider the potential value of data before you collect it. Time and cost are two big considerations when determining what data to collect. It’s not just the time and cost to collect the data you need to consider, but also the time and cost of managing it.

VARIETY
Variety is an attribute that helps an analyst by adding context. This helps whoever is analyzing data better understand how the data fits into the big picture. For example, data about what platforms your customers use can help provide context to make better sense of usage data. It could uncover the fact that mobile users in certain locations don’t spend as much time on your website, which might be due to poor cellular coverage in that area, which could prevent someone to jumping to false conclusions about website statistics.

VELOCITY
From batch to real-time, there is a wide spectrum of velocity with which data is processed. More and more data is processed in real-time than ever before and there are even some users, like high-frequency traders, who have gone so far as to shorten the distance between themselves and their data source. Author Michael Lewis writes about this in his book Flash Boys. 

Data Quality 

Using data to enhance decision making is smart, but the quality of the data you use will impact the quality of your decisions. What exactly makes good data?

In his book, Data Driven: Profiting from Your Most Important Business Asset, Dr. Thomas C. Redman describes high-quality data as suited for the intended use. Specific criteria used to measure data quality include accuracy, completeness, consistency, timeliness and uniqueness.

Much has been written about each of these data characteristics and your criteria for each aspect of data quality may differ from someone else’s. For example, if company A’s criteria for validity is accuracy to two decimal places, but department B’s criteria is accuracy to three decimal places, you may have data that is valid for one department, but not the other. Carefully consider how you establish your data quality criteria and then be consistent in applying it.

Should We Go Self-Service

Are you considering using some type of self-service analysis or reporting tool? Effective use of self-service tools requires some basic knowledge of data access procedures from a variety of data sources and file types. It also requires an understanding of how to manipulate data filters, drill-down menus, and basic user interfaces. Knowledge of basic security concepts used in self-service tools is also important. 

Extracting, Transforming, Loading (ETL): The Basics

Another skillset you should have if you’re going to use self-service data analysis tools, a basic understanding of the extracting, transforming, and loading (ETL) processes. 

EXTRACTING

Extracting data is the process of acquiring the data from its source and it requires basic knowledge about how to access and extract the data out of the source system or dataset. What is required to accomplish the extraction will vary depending on the data source and other factors, so some flexibility and resourcefulness on your part may be required.

TRANSFORMING

Now you have the data in the file format you need, but it may not be organized the way you want it. For example, you may have data items that include dates in text format, but you need to perform calculations on dates, so the data will need to be transformed before you can do calculations. This will involved some data manipulation, which may be done in the data source or in the destination application. This is the transformation phase of the process.

LOADING

Once data transformation is complete, you can then load your data into its destination. You may have data you’re moving from Excel to a data visualization or reporting tool, for example. This loading step may involve several steps, but this process is getting easier as tools are being designed to be more and more user-friendly.

With the right foundation, moving to self-service tools can be a great move, just make sure you approach the idea with care.


 

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

Related articles

The Real World
Life in The Real World – FP&A and Business Intelligence
June 16, 2020

When talking about performance, FP&A should be putting things into perspective by considering industry, competitors, consumer...

Read more
Business thinking
Going from Data to Insight
April 30, 2020

A recent Accenture study showed that 79% of large company executives think that companies that don’t...

Read more
Data Analytics – an Opportunity or a Threat for FP&A?
April 2, 2020

The explosion in computing and data processing power has led to an exponential increase in data...

Read more
How to Improve the Quality of Your Data in 4 Steps
February 11, 2020

According to a recent survey by Prophix and FP&A trends, 88% of companies claim they have...

Read more
Data Visualisation and Storytelling in FP&A
January 14, 2020

The purpose of Financial Planning and Analysis is not to build perfect forecasts and financial solutions...

Read more
Communicating Insights, Not Just Data
November 21, 2018

According to a 2017 IBM report, "Every day, we create 2.5 quintillion bytes of data. To...

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