Connect with us

Global Banking and Finance Review is an online platform offering news, analysis, and opinion on the latest trends, developments, and innovations in the banking and finance industry worldwide. The platform covers a diverse range of topics, including banking, insurance, investment, wealth management, fintech, and regulatory issues. The website publishes news, press releases, opinion and advertorials on various financial organizations, products and services which are commissioned from various Companies, Organizations, PR agencies, Bloggers etc. These commissioned articles are commercial in nature. This is not to be considered as financial advice and should be considered only for information purposes. It does not reflect the views or opinion of our website and is not to be considered an endorsement or a recommendation. We cannot guarantee the accuracy or applicability of any information provided with respect to your individual or personal circumstances. Please seek Professional advice from a qualified professional before making any financial decisions. We link to various third-party websites, affiliate sales networks, and to our advertising partners websites. When you view or click on certain links available on our articles, our partners may compensate us for displaying the content to you or make a purchase or fill a form. This will not incur any additional charges to you. To make things simpler for you to identity or distinguish advertised or sponsored articles or links, you may consider all articles or links hosted on our site as a commercial article placement. We will not be responsible for any loss you may suffer as a result of any omission or inaccuracy on the website. .

Finance

WHY SELF-SERVICE DATA PREPARATION ADDS UP FOR ACCOUNTANTS

WHY SELF-SERVICE DATA PREPARATION ADDS UP FOR ACCOUNTANTS

By Thomas Tuchscherer, CFO & VP of Corporate Development, Talend

Self-service data preparation, defined as the process of collecting, cleaning, and consolidating data into one file or data table for use in analysis, is often referred to as the next big thing. In fact, Gartner recently predicted that “by 2017 most business users and analysts in organisations will have access to self-service tools to prepare data for analysis”.

The most positive news about the new focus on self-service data preparation is that it goes beyond the office of the CIO. It represents a significant step forward for data-driven organisations as a whole. If done well, it will allow everyday business analysts to put data to work in their operational context whether they are in sales, marketing HR or indeed in finance, where its benefits are perhaps most compelling of all.

Most finance departments would concur with the views of Philip Howard, research director at Bloor, who states: “Extracting value from data has historically involved a lot of time and effort – especially when it is disparate and from multiple sources. And far too much time and effort has been spent just getting the data ready to be analysed rather than in the analysis process itself.”

Liberating the Finance Team

The tasks for hard-pressed finance and accounting teams are seemingly endless: formulating income and cash flow statements; extracting trial balances; adjusting the nominal ledger, preparing full sets of management accounts, maintaining accurate sales and purchase ledger databases.  It all represents a major burden on these departments who today often face hours of work cleaning up data in excel or ensuring everything is in the right format.

This is of course, a typically a cumbersome, complex and unwieldy process and can also be error-prone which is a serious problem for any business. Mistakes in an income statement will have a severe impact on the balance sheet and cash flow statement. A simple transposition error can lead to a serious misstatement of the accounts as a whole, if not identified and rectified quickly.  Moreover, if you chuck high volumes of bad data, such as incomplete contact information, into your purchase ledger database, for example, you’ll end up gaining a reputation for late payments and putting your business’s reputation at risk.

Working Together

Fortunately, with the advent of self-service, data preparation applications, this burden is now being alleviated. The ability to explore, cleanse, enrich and combine data in minutes, instead of hours, allows accounts and finance staff to apply their own unique domain expertise and work directly with the data that’s relevant to their own specific objectives.

By simplifying the whole process, this capability represents a huge step forward from using traditional spreadsheets within accounts and finance departments, helping empower business analysts, even those with no IT background, to get data into the format they can effectively use to generate business insights. Even without an IT skillset, finance and accounting teams can start working on their data while avoiding having to create complicated formulas, write code or complete the same tasks over and over again.

That does not mean that the IT department no longer has a role to play as a support function or that accounts and finance departments should always work in isolation, however. The best self-service tools should foster collaboration, effectively providing a sound way to reconcile IT and finance and accounts so that they can unlock data collaboratively.

Yet, being able to use the latest technology to streamline the whole process and reduce the time taken to prepare data from hours to minutes will clearly help finance departments wrest back time from the laborious process of cleaning and crunching data and allow them to spend it instead on driving critical strategic tasks like financial planning and analysis and risk management.

In short, the ability to help finance staff access, cleanse and prepare their data quickly, enables those workers to spend more time on the high-value task of extracting insight from the data and sharing that back with the business. This is critically important because analytics can be the driver for competitive differentiation for an entire company and the ability for finance to act on data quickly will increasingly be the key determinant for success for many businesses.

Global Banking & Finance Review

 

Why waste money on news and opinions when you can access them for free?

Take advantage of our newsletter subscription and stay informed on the go!


By submitting this form, you are consenting to receive marketing emails from: Global Banking & Finance Review │ Banking │ Finance │ Technology. You can revoke your consent to receive emails at any time by using the SafeUnsubscribe® link, found at the bottom of every email. Emails are serviced by Constant Contact

Recent Post