Analytics and Big Data for Accountants
By Jim Lindell
()
About this ebook
Analytics is the new force driving business. Tools have been created to measure program impacts and ROI, visualize data and business processes, and uncover the relationship between key performance indicators, many using the unprecedented amount of data now flowing into organizations. Featuring updated examples and surveys, this dynamic book covers leading-edge topics in analytics and finance. It is packed with useful tips and practical guidance you can apply immediately.
This book prepares accountants to:
- Deal with major trends in predictive analytics, optimization, correlation of metrics, and big data.
- Interpret and manage new trends in analytics techniques affecting your organization.
- Use new tools for data analytics.
- Critically interpret analytics reports and advise decision makers.
Related to Analytics and Big Data for Accountants
Related ebooks
Pro Microsoft Power BI Administration: Creating a Consistent, Compliant, and Secure Corporate Platform for Business Intelligence Rating: 0 out of 5 stars0 ratingsBig Data Analytics: Turning Big Data into Big Money Rating: 0 out of 5 stars0 ratingsAWS Data Analytics: Unleashing the Power of Data: Insights and Solutions with AWS Analytics Rating: 0 out of 5 stars0 ratingsPractical DataOps: Delivering Agile Data Science at Scale Rating: 0 out of 5 stars0 ratingsData Warehousing Fundamentals for IT Professionals Rating: 3 out of 5 stars3/5Analytics in a Business Context: Practical guidance on establishing a fact-based culture Rating: 0 out of 5 stars0 ratingsCIO Best Practices: Enabling Strategic Value With Information Technology Rating: 4 out of 5 stars4/5Spreadsheets To Cubes (Advanced Data Analytics for Small Medium Business): Data Science Rating: 0 out of 5 stars0 ratingsData Cleaning: The Ultimate Practical Guide Rating: 0 out of 5 stars0 ratingsPlanning NetSuite A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsDemand Forecasting A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsData Governance and Data Management: Contextualizing Data Governance Drivers, Technologies, and Tools Rating: 0 out of 5 stars0 ratingsSelf-Service AI with Power BI Desktop: Machine Learning Insights for Business Rating: 0 out of 5 stars0 ratingsWiley CMAexcel Learning System Exam Review 2017: Part 2, Financial Decision Making (1-year access) Rating: 0 out of 5 stars0 ratingsA Manager's Guide to Data Warehousing Rating: 2 out of 5 stars2/5Customer Data and Analysis Second Edition Rating: 0 out of 5 stars0 ratingsBeginning Entity Framework Core 5: From Novice to Professional Rating: 0 out of 5 stars0 ratingsSolving the Technology Challenge for IT Managers: Technologies That IT Managers Can Use In Order to Make Their Teams More Productive Rating: 0 out of 5 stars0 ratingsSelf-Service Data & Analytics Third Edition Rating: 0 out of 5 stars0 ratingsBusiness Dashboards A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsWiley CMAexcel Learning System Exam Review 2017: Part 1, Financial Reporting, Planning, Performance, and Control (1-year access) Rating: 0 out of 5 stars0 ratingsAnalytics and Business Intelligence A Complete Guide Rating: 0 out of 5 stars0 ratingsBusiness Analysis with QuickBooks Rating: 0 out of 5 stars0 ratingsThe Business Of Being A CIO: How CIOs Can Use Their Technical Skills To Help Their Company Solve Real-World Business Problems Rating: 0 out of 5 stars0 ratingsData Strategy A Clear and Concise Reference Rating: 1 out of 5 stars1/5Data Management Strategy A Complete Guide - 2019 Edition Rating: 0 out of 5 stars0 ratingsMicrosoft Dynamics NAV 7 Programming Cookbook Rating: 0 out of 5 stars0 ratingsOracle Business Intelligence Enterprise Edition 12c - Second Edition Rating: 0 out of 5 stars0 ratings
Computers For You
The Innovators: How a Group of Hackers, Geniuses, and Geeks Created the Digital Revolution Rating: 4 out of 5 stars4/5Standard Deviations: Flawed Assumptions, Tortured Data, and Other Ways to Lie with Statistics Rating: 4 out of 5 stars4/5Elon Musk Rating: 4 out of 5 stars4/5Mastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 5 out of 5 stars5/5The Invisible Rainbow: A History of Electricity and Life Rating: 5 out of 5 stars5/5Slenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5The Hacker Crackdown: Law and Disorder on the Electronic Frontier Rating: 4 out of 5 stars4/5101 Awesome Builds: Minecraft® Secrets from the World's Greatest Crafters Rating: 4 out of 5 stars4/5CompTIA Security+ Get Certified Get Ahead: SY0-701 Study Guide Rating: 5 out of 5 stars5/5Uncanny Valley: A Memoir Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Ultimate Guide to Mastering Command Blocks!: Minecraft Keys to Unlocking Secret Commands Rating: 5 out of 5 stars5/5Deep Search: How to Explore the Internet More Effectively Rating: 5 out of 5 stars5/5Procreate for Beginners: Introduction to Procreate for Drawing and Illustrating on the iPad Rating: 0 out of 5 stars0 ratingsHow to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5The ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 4 out of 5 stars4/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Dark Aeon: Transhumanism and the War Against Humanity Rating: 5 out of 5 stars5/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsThe Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5
Reviews for Analytics and Big Data for Accountants
0 ratings0 reviews
Book preview
Analytics and Big Data for Accountants - Jim Lindell
Chapter 1
WHAT ARE BIG DATA AND ANALYTICS?
LEARNING OBJECTIVES
After completing this chapter, you should be able to do the following:
•
Identify the three different types of data.
•
Recall what type of data volume Big Data represents.
•
Recognize Big Data terminology.
INTRODUCTION
In the early 20th century, businesses kept track of financial and operational results using paper and ink. It was difficult enough just to record the date of the transactions, let alone summarize information with financial statements. The main form of automation that helped improve the efficiency of accounting clerks was limited to innovations in carbon copy paper, mimeograph machines, copy machines, and the like. When computers finally were available for operational and financial use, the systems were based on a batch recording of transactions. Again the focus was on capturing internal data to help an organization understand its financial and operational results. As computers advanced and became more powerful, the focus increased in obtaining more internally generated operational and financial information as well as analyzing the myriad information as a result of increased computing power, increased data, and more user-friendly tools.
Prior to the advent of the Internet, an organization worked mainly with its internal data. With the subsequent advances in Internet use in the latter half of the 20th century and the beginning of the 21st century, external information became accessible that could be integrated with internal data. Companies moved from producing batch information to employees generating information (on both the corporate and personal level), to sensors producing data about all aspects of our lives. This last point can be frightening because appliances, sensors, and different apparatuses are generating more data in shorter periods of time than ever before. This has resulted in a flood of information, the concept of Big Data, and predictive analytics.
DEFINITION—WHAT IS BIG DATA?
What is Big Data? Big Data is a set of high-volume, high-velocity, and high-variety information that demands cost-effective, innovative forms of information processing for enhanced insight and decision making.1
The end goal of Big Data should be to leverage the information resulting in increased value to the customer and an organization.
HOW BIG IS BIG? VOLUME LEVELS IN BIG DATA
In addition to transactional data and user-created data, the advent of the Internet opened the floodgates to new databases, new forms of data, and data that no longer needed to be created by human intervention.
DOMO.com created an analysis of the amount of data that is processed or created every minute over the Internet.2 Consider the following by-the-minute volumes:
•
YouTube users upload 400 hours of new video.
•
Snapchat users watch 6,944,444 videos.
•
Facebook messenger shares 216,302 photos.
•
Amazon makes $222,283 in sales.
•
Instagram users like 2,430,555 posts.
•
Siri answers 99,206 requests.
•
Dropbox users upload 833,333 new files.
From Internet Stats Live3
•
Email users send 160,000,000 messages.4
•
Twitter users tweet 450,793 times.
•
Internet users in the world: 3,588,643,537
•
Facebook active users: 1,867,648,665
•
Pinterest active users: 203,925,085
•
Websites hacked: 63,3455
Just a couple of years ago, the number of global Internet users was estimated to be in excess of 2.4 billion people. Internet Stats Live estimates that there are now 3.6 billion global users.
The amount of data continues to grow exponentially. There’s nothing on the horizon that suggests this increase of information will not continue. The challenge for the accountant is managing the expansion of information in terms of collecting, archiving, accessing, and interpreting. The growth in structured data, unstructured data, streaming data, and the like will only continue.
Why has everyone become so interested in the explosion of data that has become known as Big Data? The McKinsey Global Institute published research in 2011 in which it estimated that retailers exploiting data analytics at scale across their organizations could increase their operating margins by more than 60 percent and that the U.S. healthcare sector could reduce costs by 8 percent through data-analytics efficiency and quality improvements.
6
KNOWLEDGE CHECK
1.
How can Big Data best be described?
a.
Large systems in multi-national companies.
b.
Structured data, unstructured data, and streaming data.
c.
Enterprise resource planning (ERP) systems with all software applications in the organization.
d.
Data processed with serial processing.
2.
It is estimated that Snapchat users watch how many videos every minute of the day?
a.
Nearly 1 million.
b.
Nearly 4 million.
c.
Nearly 7 million
d.
Nearly 10 million.
EXAMPLES OF VOLUME
What type of data volumes does Big Data involve?
MEGABYTES, GIGABYTES, TERABYTES … WHAT ARE THEY?
How much data could be contained in the preceding measurements? We turned to WhatsAByte.com to find out.7
Byte: 100 bytes equates to an average sentence like this one.
Kilobyte: 100 kilobytes equals a page of words like the one you’re reading now.
Megabyte: 100 megabytes equals a couple volumes of encyclopedias. 600 megabytes is about the amount of data that will fit on a CD-ROM disk.
Gigabyte: 100 gigabytes could contain an entire library floor of academic journals.
Terabyte: A terabyte could hold 1,000 copies of the Encyclopedia Britannica. Ten terabytes could hold the printed collection of the Library of Congress.
Petabyte: A petabyte could hold approximately 20 million four-door filing cabinets full of text. It could contain 500 billion pages of standard printed text.
Exabyte: It’s estimated that five exabytes would be equal to all of the words ever spoken by mankind.
Zettabyte: 1 ZB is equivalent to approximately 152 million years of high-definition video.8
KNOWLEDGE CHECK
3.
A petabyte could contain how many billion pages of standard text?
a.
100.
b.
500.
c.
900.
d.
750.
THE ACCOUNTANT AND BIG DATA
Although many organizations have sought to leverage Big Data applications and resources, they have not had the time or resources to pursue the dream fully. The American Productivity and Quality Center (APQC) conducted a study sponsored by Grant Thornton entitled Financial Planning and Analysis: Influencing Corporate Performance with Stellar Processes, People, and Technology.
9 One of the study’s conclusions was that the finance staff has not been at the forefront of the battle of Big Data. Two-thirds of survey respondents indicated that they spent too much time on basic financial management duties to improve financial planning and analysis. When asked what the most significant barriers to improving financial planning and analysis value to the business were, they responded as follows (see table 1-2):10
Table 1-2
According to the study, financial planning and analysis departments are consumed by the basics: data management, process administration, managing the machinery of periodic forecasting and variance analysis and working with the accounting staff to correct posting errors.
Having limited time to focus on data analysis, what were the major areas the financial planning and analysis group could focus on?
ACCOUNTING’S BIG DATA PROBLEM
11
According to CFO.com, unless accountants and finance executives work for companies in businesses that provide or deliver data products and services, they may not be participants in the Big Data trend because most of them have been trained almost exclusively on structured data (data that fits into tables, Excel spreadsheets, databases, and the like) rather than unstructured data.
Keep in mind that unstructured data represents the most significant segment of existing data and will probably yield the largest benefit.
One such example of the unstructured data comes from Trax—a Singapore-based firm that provides an image-recognition app to gather data from photos taken of shelves at retail stores. The photos allow an organization to better manage inventories.
Another example of unstructured data can be found in corporations’ published text in the following sources:
•
10-Ks and 10-Qs Management’s Discussion and Analysis
•
Press releases
•
Interviews with corporate executives
BIG DATA TERMINOLOGY
As in any new field, Big Data has some terms that must be mastered. The following list is not meant to be all-inclusive, but it identifies many of the terms related to Big Data, analytics, and business intelligence.
Business intelligence (BI). The integration of data, technology, analytics, and human knowledge to optimize business decisions and ultimately drive an enterprise’s success. BI programs usually combine an enterprise data warehouse and a BI platform or toolset to transform data into usable, actionable business information.12
Data analytics (DA). The science of examining raw data with the purpose of drawing conclusions from that information. Data analytics is used in many industries to allow companies and organizations to make better business decisions, and in the sciences to verify or disprove existing models or theories.13
Cloud computing. A model for delivering information technology services in which resources are retrieved from the Internet through web-based tools and applications rather than a direct connection to a server. Data and software packages are stored in servers. However, cloud computing allows access to information as long as an electronic device has access to the web. This type of system allows employees to work remotely.14
Dashboards. A business intelligence dashboard (BI dashboard) is a BI software interface that provides preconfigured or customer-defined metrics, statistics, insights, and visualization into current data. It allows the end and power users of BI software to view instant results into the live performance state of business or data analytics.15
Data mining. The practice of searching through large amounts of computerized data to find useful patterns or trends.16
Data scientist. An employee or BI consultant who excels at analyzing data, particularly large amounts of data, to help a business gain a competitive edge.17
Data visualization. The presentation of data in a pictorial or graphic format.
Hadoop. A free, java-based programming framework that supports the processing of large data sets in a distributed computing environment. It is part of the Apache project, sponsored by the Apache Software Foundation.18
OLAP. (OnLine Analytical Processing). OLAP is a powerful technology for data discovery, including capabilities for limitless report viewing, complex analytical calculations, and predictive "what-if’ scenario (budget, forecast) planning.19
Predictive analytics. The practice of extracting information from existing data sets to determine patterns and predict future outcomes and trends. Predictive analytics does not tell you what will happen in the future. It forecasts what might happen in the future with an acceptable level of reliability, and includes what-if scenarios and risk assessment.20
Prescriptive analytics. A type of business analytics that focuses on finding the best course of action for a given situation and belongs to a portfolio of analytic capabilities that include descriptive and predictive analytics.21
Semi-structured data. Data that has not been organized into a specialized repository, such as a database, but that nevertheless has associated information, such as metadata, that makes it more amenable to processing than raw or unstructured data. For example, a Word document contains metadata or tagging that allows for keyword searches, but it does not have as much relational structure or utility as the information in a database.22
Structured data. Data that resides in a fixed field within a record or file. This includes data contained in relational databases and spreadsheets.23
Unstructured data. Information that doesn’t reside in a traditional row-column database. It often includes text and multimedia. Examples include email messages, word processing documents, videos, photos, audio files, presentations, web pages, and many other kinds of business documents. Although these files may have an internal structure, they are considered unstructured
because the data is not contained in a database. Experts estimate that 80 percent to 90 percent of the data in any organization is unstructured.24
FOUR TYPES OF DATA ANALYTICS
Adding to the examples and sources of Big Data, let’s examine how some of the definitions and related terminology we’ve just learned fit into processes used to examine data. Different types of analytics can be used to analyze Big Data for different purposes.
Descriptive Analytics
Descriptive analytics is information that has happened in the past. From an accounting perspective, this would represent traditional historical financial information. Consider the following examples:
•
An assessment of customer credit risk can be predicted based on that company’s past financial performance.
•
A prediction of sales results can be created from customers’ product preferences and sales cycle.
•
Current product reviews can be used to predict future sales.
•
Employee evaluation can be used to predict turnover.
Diagnostic Analytics
Diagnostic analysis describes the reason for the historical results. It attempts to answer the question Why did this happen?
as in the following examples:
•
In traditional finance, variance analysis uncovers the underlying reasons for differences in budgeted and actual results.
•
Causal analysis can be used to describe why certain results occurred.
•
Analytic dashboards can be used to describe why something happened. For example, during the Ebola outbreak in Africa, it was possible to view the daily spread of the virus as it occurred in different geographic regions.
•
Tracking the increase in views, posts, fans, followers, and so forth, as a result of purchasing additional views on Facebook to increase the exposure of a particular post, video, or picture.
Discovery Analysis (Insight)
Although not technically one of the four types of data analytics, the step of discovery analysis could be inserted between diagnostic and predictive analytics. During discovery analysis or insight, research and analysis can be undertaken to identify whether there is a relationship between the historical information and another database.
Predictive Analytics
Predictive analytics attempts to determine what will happen by analyzing historical data and trends. Consider the following examples of predictive analytics:
•
An accounting department prepares a cash flow projection report.
•
Preparing an estimate of inventory levels
•
Predicting an outcome based on changed assumptions. The revenue will increase by a specific percentage if an additional 5 percent is spent on the marketing budget.
•
The issuance of additional coupons or promotions for a retail organization is projected to result in a 10 percent increase in