Using information technology to make data useful is as old as the Information Age. The difference today is that the volume and variety of available data has grown enormously. Big data gets almost all of the attention, but there’s also cryptic data. Both are difficult to harness using basic tools and require new technology to help organizations glean actionable information from the large and chaotic mass of data. “Big data” refers to extremely large data sets that may be analyzed computationally to reveal patterns, trends and associations, especially those related to human behavior and interaction. The challenges in dealing with big data include having the computational power that can scale to the processing requirements for the volumes involved; analytical tools to work with the large data sets; and governance necessary to manage the large data sets to ensure that the results of the analysis are accurate and meaningful. But that’s not all organizations have to deal with now. I’ve coined the term “cryptic data” to focus on a different, less well known sort of data challenge that many companies and individuals face.
Topics: Big Data, data science, Planning, Predictive Analytics, Social Media, forecasting, FP&A, Office of Finance, Operational Performance Management (OPM), Budgeting, Connotate, cryptic, equity research, Finance Analytics, Human Capital, Kofax, Statistics, Analytics, Business Analytics, Hadoop, Business Intelligence (BI), Customer Performance Management (CPM), Data, Datawatch, Financial Performance Management (FPM), Kapow, Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), import.io
Workday Financial Management (which belongs in the broader ERP software category) appears to be gaining traction in the market, having matured sufficiently to be attractive to a large audience of buyers. It was built from the ground up as a cloud application. While that gives it the advantage of a fresh approach to structuring its data and process models for the cloud, the product has had to catch up to its rivals in functionality. The company’s ERP offering has matured considerably over the past three years and now is better positioned to grow its installed base. Workday recently added Aon, the insurance and professional services company, to its customer list (becoming its largest customer to date) and reported that its annual contract value (ACV – the annualized aggregate revenue value of all subscription contracts as of the end of a quarter) has doubled since the second quarter of this year, albeit from a low base. This is an important milestone because for years the company’s growth has come from the human capital management (HCM) portion of the business, not financials. Workday has around 160 customers for its financials (more than 90 of which are live) compared to more than 1,000 customers for HCM.
Topics: Microsoft, SAP, ERP, FP&A, NetSuite, Operational Performance Management (OPM), Reporting, close, closing, Controller, dashboard, Human Capital, Reconciliation, report, Tax, Analytics, Business Intelligence, Cloud Computing, Collaboration, IBM, Oracle, Uncategorized, Accounting, Business Performance Management (BPM), CFO, Data, finance, Financial Performance Management (FPM), Amazon, BI, Financial Performance Management, FPM, Intacct, scorecard, spreadsheet, treasury
The enterprise resource planning (ERP) system is a pillar of nearly every company’s record-keeping and management of business processes. It is essential to the smooth functioning of the accounting and finance functions. In manufacturing and distribution, ERP also can help plan and manage inventory and logistics. Some companies use it to handle human resources functions such as tracking employees, payroll and related costs. Yet despite their ubiquity, ERP systems have evolved little since their introduction a quarter of a century ago. The technologies shaping their design, functions and features had been largely unchanged. As a measure of this stability, our Office of Finance benchmark research found that in 2014 companies on average were keeping their ERP systems one year longer than they had in 2005.
Topics: Big Data, Microsoft, SAP, Social Media, ERP, FP&A, Mobile Technology, NetSuite, Operational Performance Management (OPM), Reporting, close, closing, Controller, dashboard, Human Capital, Reconciliation, report, Analytics, Business Intelligence, Cloud, Cloud Computing, Collaboration, IBM, Oracle, Uncategorized, Accounting, Business Performance Management (BPM), CFO, Data, finance, Financial Performance Management (FPM), Supply Chain Performance Management (SCPM), BI, Financial Performance Management, FPM, Intacct, scorecard
Whatever Oracle’s cloud strategy had been the past, this year’s OpenWorld conference and trade show made it clear that the company is now all in. In his keynote address, co-CEO Mark Hurd presented predictions for the world of information technology in 2025, when the cloud will be central to companies’ IT environments. While his forecast that two (unnamed) companies will account for 80 percent of the cloud software market 10 years from now is highly improbable, it’s likely that there will be relentless consolidation, marginalization and extinction within the IT industry sector driven by cloud disruptions and the maturing of the software business. In practice, though, we expect the transition to the cloud to be slow and uneven.
Topics: Microsoft, SAP, ERP, FP&A, Mobile Technology, NetSuite, Operational Performance Management (OPM), Reporting, close, closing, Controller, dashboard, Human Capital, reconciliations, report, Tax, Analytics, Business Collaboration, Business Intelligence, Cloud, Cloud Computing, Collaboration, IBM, Oracle, Accounting, Business Performance Management (BPM), CFO, Customer Performance Management (CPM), Data, finance, Financial Performance Management (FPM), Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), Amazon, BI, Financial Performance Management, FPM, Intacct, Predictive Analytics, scorecard, Spreadsheets, treasury
Many senior finance executives say they want their department to play a more strategic role in the management and operations of their company. They want Finance to shift its focus from processing transactions to higher-value functions in order to make more substantial contributions to the success of the organization. I use the term “continuous accounting” to represent an approach to managing the accounting cycle that can facilitate the shift by improving the performance of the accounting function. Continuous accounting embraces three main principles:
Topics: ERP, FP&A, Reporting, close, closing, Controller, dashboard, reconciliations, report, Tax, Analytics, Business Intelligence, Cloud, Collaboration, Accounting, Business Performance Management (BPM), CFO, Data, finance, Financial Performance Management (FPM), BI, Financial Performance Management, FPM, scorecard, Spreadsheets, treasury
In our benchmark research at least half of participants that use spreadsheets to support a business process routinely say that these tools make it difficult for them to do their job. Yet spreadsheets continue to dominate in a range of business functions and processes. For example, our recent next-generation business planning research finds that this is the most common software used for performing 11 of the most common types of planning. At the heart of the problem is a disconnect between what spreadsheets were originally designed to do and how they are actually used today in corporations. Desktop spreadsheets were intended to be a personal productivity tool used, for example, for prototyping models, creating ad hoc reports and performing one-off analyses using simple models and storing small amounts of data. They were not built for collaborative, repetitive enterprise-wide tasks, and this is the root cause of most of the issues that organizations encounter when they use them in such business processes. Software vendors and IT departments have been trying – mainly in vain – to get users to switch from spreadsheets to a variety of dedicated applications. They’ve failed to make much of a dent because, although these applications have substantial advantages over spreadsheets when used in repetitive collaborative enterprise tasks, these advantages are mainly realized after the model, process or report is put to use in the “production” phase (to borrow an IT term). To date most dedicated applications have been far more difficult than spreadsheets for the average business user to use in the design and test phases. To convince people to switch to their dedicated application, a vendor must offer an alternative that lets users model, create reports, collect data and create dedicated data stores as easily as they can do it in a desktop spreadsheet. Spreadsheets are seductive for most business users because, even with a minimum amount of training and experience, it’s possible to create a useful model, do analysis and create reports. Individuals can immediately translate what they know about their business or how to present their ideas into a form and format that makes sense to them. They can update and modify it whenever they wish, and the change will occur instantly. For these business users ease of use and control trump putting up with the issues that routinely occur when spreadsheets are used in collaborative enterprise processes. Moreover, it’s hard to persuade “spreadsheet jockeys” who have strong command of spreadsheet features and functions that they should start over and learn how to use a new application. Those who have spent their careers working with spreadsheets often find it difficult to work with formal applications because those applications work in ways that aren’t intuitive. Personally these diehards may resist because not having control over analyses and data would diminish their standing in the organization. Nevertheless, there are compelling reasons for vendors to keep trying to devise dedicated software that an average business user would find as easy and intuitive as a desktop spreadsheet in the design, test and update phases. Such an application would eliminate the single most important obstacle that keeps organizations from switching. The disadvantages of using spreadsheets are clear and measurable. One of the most significant is that spreadsheets can waste large amounts of time when used inappropriately. After more than a few people become involved and a file is used and reused, issues begin to mount such as errors in data or formulas, broken links and inconsistencies. Changes to even moderately complex models are time-consuming. Soon, much of the time spent with the file is devoted to finding the sources of errors and discrepancies and fixing the mistakes. Our research confirms this. When it comes to important spreadsheets that people use over and over again to collaborate with colleagues, on average people spend about 12 hours per month consolidating, modifying and correcting the spreadsheets. That’s about a day and a half per month – or five to 10 percent of their time – just maintaining these spreadsheets. Business applications vendors started to address business users’ reluctance to use their software more than a decade ago when they began to use Microsoft Excel as the user interface (UI). This provides a familiar environment for those who mainly need to enter data or want to do some “sandbox” modeling and analysis. Since the software behind the UI is a program that uses some sort of database, companies avoid the issues that almost arise when spreadsheets are used in enterprise applications. There also are products that address some of the inherent issues with such as the difficulty of consolidating data from multiple individual spreadsheets as well as keeping data consistent. Visualization software, a relatively new category, greatly simplifies the process of collecting data from one or more enterprise data sources and creating reports and dashboards. As the enterprise software applications business evolves to meet the needs of a new generation of users, as I mentioned recently, it’s imperative that vendors find a way to provide users with software that is a real alternative to desktop spreadsheets. By this I mean enterprise software that provides business users with the same ability to model, create reports and work with data the way they do in a desktop spreadsheet as well as update and modify these by themselves without any IT resources. At the same time, this software has to eliminate all of the problems that are inevitable when spreadsheets are used. Only at that point will a dedicated application become a real alternative to using a spreadsheet for a key business process. Regards, Robert Kugel – SVP Research
Topics: Planning, ERP, Forecast, GRC, Operational Performance Management (OPM), Reporting, closing, dashboard, enterprise spreadsheet, Excel, plan, Analytics, Business Analytics, Business Collaboration, Accounting, Business Intelligence (BI), Business Performance Management (BPM), Customer Performance Management (CPM), Data, Financial Performance Management (FPM), Risk, Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), application, benchmark, Financial Performance Management, spreadsheet
Our recently published Office of Finance benchmark research assesses a broad set of functions and capabilities of finance organizations. We asked research participants to identify the most important issues for a finance department to address in a dozen functional areas: accounting, budgeting, cost accounting, customer profitability management, external financial reporting, financial analysis, financial governance and internal audit, management accounting, product profitability management, strategic and long-range planning, tax management and treasury and cash management. Among the key findings is this: Not using the most capable software is an underlying cause, often unrecognized, of process, analytics and data issues.
Topics: Mobile, Planning, Predictive Analytics, ERP, FP&A, Reporting, Self-service, Budgeting, close, closing, computing, Controller, dashboard, planning and budgeting, report, Tax, Analytics, Business Intelligence, Cloud, Collaboration, Accounting, Business Performance Management (BPM), CFO, Data, finance, Financial Performance Management (FPM), BI, Financial Performance Management, FPM, Microsoft Excel, scorecard, Spreadsheets, treasury
Our recent Office of Finance benchmark research demonstrates the importance of using automation to execute finance department functions. Information technology systems do at least two things very well that make better use of people’s time, and both of them can substantially improve organizational performance. First, they eliminate the need for people to do repetitive tasks, which frees them to spend time on more valuable work that requires judgment and skill. IT systems also can be programmed to focus only on relevant information while eliminating the need to get immersed in detail. The latter capability supports a “management by exception” approach, which enables executives and managers to better allocate how and where they spend their time.
Topics: Big Data, Mobile, Planning, ERP, FP&A, Reporting, Self-service, Budgeting, close, closing, computing, Controller, dashboard, planning and budgeting, reconciliations, report, Tax, Analytics, Business Analytics, Business Collaboration, Business Intelligence, Cloud, Collaboration, Accounting, Business Performance Management (BPM), CFO, Data, finance, Financial Performance Management (FPM), BI, Financial Performance Management, FPM, Microsoft Excel, scorecard, Spreadsheets, treasury
A company’s enterprise resource planning (ERP) system is one of the pillars of its record-keeping and process management architecture and is central to many of its critical functions. It is the heart of its accounting and financial record-keeping processes. In manufacturing and distribution, ERP manages inventory and some elements of logistics. Companies also may use it to handle core human resources record-keeping and to store product and customer master data. Often, companies bolt other functionality onto the core ERP system or extensively modify it to address limitations in the system. Because of the breadth of its functionality, those unfamiliar with the details of information technology may perceive ERP as a black box that controls just about everything. So it’s not surprising that when a company’s information technology becomes more of an issue than a solution, many assume that the ERP system needs replacing. This may or may not be true, so it’s important for a company to assess its existing ERP system in the context of its business requirements (as they are now and will be in the immediate future) and evaluate options for it.
Topics: ERP, Operational Performance Management (OPM), Analytics, CIO, Business Performance Management (BPM), CFO, Customer Performance Management (CPM), Data, Financial Performance Management (FPM), HR, Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), Workforce Performance Management (WPM), order-to-cash
When applying information technology to drive better business performance, companies and the systems integrators that assist them often underestimate the importance of organizing data management around processes. For example, companies that do not execute their quote-to-cash cycle as an end-to-end process often experience a related set of issues in their sales, marketing, operations, accounting and finance functions that stem from entering the same data into multiple systems. The inability to automate passing of data from one functional group to the next forces people to spend time re-entering data and leads to fragmented and disconnected data stores. The absence of a single authoritative data source also creates conflicts about whose numbers are “right.” Even when the actual figures recorded are identical, discrepancies can crop up because of issues in synchronization and data definition. Lacking an authoritative source, organizations may need to check for and resolve errors and inconsistencies between systems to ensure, for example, that what customers purchased was what they received and were billed for. The negative impact of this lack of automation is multiplied when transactions are complex or involve contracts for recurring services.
Topics: Big Data, Mobile, ERP, Operational Performance Management (OPM), Operations, Management, close, closing, computing, end-to-end, quote-to-cash, requisition-to-pay, Analytics, Cloud, Data Management, Accounting, Business Performance Management (BPM), CRM, Data, finance, Information Applications (IA), Information Management (IM), Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), FPM