Learning the Language of Data Analytics

VIEW AS PDF

By Don Carpenter

The article “Is Accounting a Stem Field? Why it Matters” in the March/April 2023 issue of Today’s CPA magazine considered the implications to the profession of STEM classification. Support for STEM categorization is supported by the increased emphasis on data analytics for informed decision making that CPAs now provide to the larger business community. This article explores some of the basics of this ever-growing part of the profession.

It is often said that accounting is the “language of business.” The ability to navigate financial statements and understand the impact of decisions on an operation’s financial results is critical to a successful business career. But if accounting is the king’s English, then the language of data analytics is quickly becoming the Esperanto of commerce. As the ability to access, manage and analyze information has increased exponentially, the mystique of the process has been buttressed by terminology that even the most seasoned professionals may find bewildering.

Becoming familiar with some of the basic phrases in the rapidly growing field is a good first step to capitalizing on the potential it brings to decision making. Let’s delve into some of the most common vocabulary with the goal of making the world of “big data” a little less intimidating.

To begin, there is often a misunderstanding of just what data analytics, data science or even data mining entails. All three terms refer to accessing large amounts of data and often at a very granular level. For instance, advanced computing technologies now allow even the largest organizations to amass data and analyze it at the transactional level even though millions of transactions occur regularly. This is reflected in the fact that the growth in data is no longer measured in gigabytes but in zettabytes (trillion gigabytes).

Simplistically, data mining can be thought of as the somewhat indiscriminate process of combing through data in an effort to identify a meaning, interpretation or pattern.

Data analytics or data science may also follow this exploratory approach but can be more deductive, attempting to support a hypothesis with the available data. Some purists go even further by making a distinction between data analytics and data science based on the qualifications of the individual performing the work. Data scientists generally have more advanced statistical and mathematical credentials when compared to data analysts.

The use of data analytics in decision making generally can be segregated into four categories: predictive modeling, descriptive modeling, diagnostic modeling and prescriptive modeling.

Predictive modeling uses incidents (often transactions) where an outcome is known to predict an unknown outcome. This is often applied in marketing and customer behavior. For example, analysis of customer buying patterns can help a retailer target certain items to customers who buy other products based on the historical purchasing patterns of its existing customer base.

Descriptive modeling uses a full range of data points to yield a better understanding of a key business variable, such as data points that provide a better understanding of the customer base.

Diagnostic modeling seeks to determine the “why” or “how” behind a fact pattern. This approach could be very useful in fraud detection for example. Comparative analysis of costs across various sites could be used to isolate outliers to aid in detecting billing irregularities.

Finally, prescriptive modeling seeks to analyze the available data to determine how an outcome might be influenced and by its nature, it is less well defined.

The objective of any data analysis effort will determine the appropriate data to use. Organizations maintain business-critical information deemed necessary for analysis in a repository known as a data warehouse or data lake. A data warehouse might contain such diverse information as general ledger downloads, human resource records and environmental reports. The process of data analysis will “slice and dice” this information to draw out the relevant data and produce meaningful interpretation.

A clickstream database records the web traffic or sites visited within a search engine and would be useful in a predictive modeling analysis of customer behavior. A text database is a database of unstructured, continuous text such as the narrative in earnings’ releases, financial statement footnotes or even tweets that can be searched and sorted to determine frequency of phrases or other recurring word patterns. And the more common numerical database is a collection of values representing a given variable (i.e., revenue, headcount) that can be compared or correlated to inform business decisions.

Once the appropriate database has been developed or accessed, a query is the mechanism used to extract a subgroup from the data set. The population is the entire data set that would be relevant to a particular analytical project. This subgroup should not be confused with a typical sample used in audit procedures for example. The strength of data analytics is its ability to process large volumes of data.

If all transactions in a general ledger comprised a population, the query might extract all transactions that increase expense accounts by greater than $1,000,000. This subset can then be manipulated and analyzed with computer logic often referred to as bots. These threads of computer logic or algorithms can be quite complex and might be thought of as “turbo-charged macros.”

Data visualization refers to the method used to communicate the product of an analytical project in pictorial format such as bar/pie charts or linear graphs to allow for quick interpretation. The goal of data visualization is to succinctly convey the results without losing the message in the details.

Speaking the language of data analytics is critical to unlocking its full potential for anyone wanting to understand and use it to make informed business decisions.

About the Author: Don Carpenter is clinical professor of accounting at Baylor University. Contact him at Don_Carpenter@baylor.edu.

 

 

 

  • TXCPA’s 2024-2025 Year in Review

    TXCPA addressed key challenges in the accounting profession through strategic initiatives focused on the CPA talent shortage, advocating for licensure flexibility, expanding student outreach, and enhancing member services. Key achievements included support for legislation introducing additional CPA pathways, strong participation in advocacy efforts and impressive engagement in CPE programs.
    View Article
  • CPE: The Significance of Codes of Conduct in Professional Organizations - Standards for Ethical Practice

    This article examines the ethical codes of four major professional organizations - AICPA, ACFE, CFA Institute, and IIA - highlighting their shared values of integrity, objectivity, confidentiality, and competence. While all emphasize ethical behavior and professional standards, each code is tailored to the unique responsibilities of its field.
    View Article
  • 89th Legislative Session Review: New House Leader, Rule Changes and a Productive Session for TXCPA

    The 89th session of the Texas Legislature began on January 14, 2025. TXCPA has been hard at work advocating its legislative agenda and has had a very productive session. Texas is one of the state leaders in addressing CPA pipeline issues.
    View Article
  • Special Report: The Digital Transformation of Accounting

    Digital transformation is reshaping accounting, making technology adoption essential for firms to stay competitive. Automation streamlines reporting, while document management systems improve organization and compliance. Embracing innovation allows firms to boost efficiency, deliver deeper client value and lead in a rapidly evolving profession.
    View Article
  • Key Considerations for Financial Statement Auditors Before Leveraging Artificial Intelligence in Their Audits

    There is a growing role for generative AI tools to be used in financial statement audits. The tools offer numerous advantages, including enhanced data analysis, continuous learning, predictive insights, audit automation, and cost savings. However, challenges remain, such as data privacy risks, bias in training data and the inability to verify source data. Learn more in this article.
    View Article
  • How Accountants Can Embrace an Entrepreneurial Spirit

    The use of AI-driven technologies has resulted in numerous tools that threaten the existence of many professionals. Accountants are not immune to the threat since many of their tasks can be automated. To stay relevant, accountants can upskill or start their own business. Despite low risk tolerance, their financial expertise makes them strong entrepreneurial candidates.
    View Article
  • Maximizing Audits: Key Elements for Efficient and Successful Financial Assessments

    Audits provide stakeholders with reliable financial insights, but the process can be daunting for companies. To prepare effectively, businesses should focus on strong internal controls, accurate transaction records and clear, compliant financial statements. Internal controls help prevent fraud and ensure accurate reporting, while well-organized documentation streamlines auditor reviews.
    View Article
  • Spotlight on the Accounting Profession: Jessica Rodriguez Reyes

    Jessica Rodriguez Reyes, an outstanding undergraduate in the BS/MS accounting program at the University of North Texas, shares her journey as a first-generation college student. With internship experiences in small and large firms, Jessica emphasizes the value of hands-on learning and her dedication to mentoring other students is making a noticeable impact.
    View Article
  • A Year of Progress and Impact

    As the 2024–2025 membership year ends, we reflect on a year of progress driven by the dedication of leadership, volunteers and, most importantly, our members. Together, we advanced initiatives, strengthened our community and expanded our reach. Looking forward, even greater opportunities lie ahead to build on this success.
    View Article
  • What’s Happening Around Texas - May-June 2025

    Members in Austin, Dallas and San Antonio participated in community service activities and professional networking events. Fort Worth hosted a successful masquerade ball to fund scholarships, while TXCPA South Plains introduced its new board. Southeast Texas engaged students at a career expo, Victoria hosted a student-CPA coffee meet-up, and Wichita Falls organized an educational event at Midwestern State University.
    View Article
  • Accounting Firms Continue to Innovate in Response to Rapidly Changing Market Conditions

    There is a growing trend of private equity investments in CPA firms amid declining CPA Exam participation, talent shortages and rising reliance on AI. While offering growth opportunities, the deals raise concerns about maintaining professional independence in a profit-driven model.
    View Article
  • Take Note

    In this edition of Take Note: Renew Your TXCPA Membership Today; TXCPA Passport is On-Demand CPE at Your Fingertips; Tips to Reduce Digital Overload; Get Published in Today’s CPA Magazine
    View Article
  • Classifieds

    The classified ad section features listings for practice owners looking to sell, professionals seeking firms to purchase and a variety of specialized services. Whether you're looking to expand, sell or explore niche opportunities, these classified ads can connect you to valuable business prospects and resources.
    View Article

CHAIR
Mohan Kuruvilla, Ph.D., CPA

PRESIDENT/CEO
Jodi Ann Ray, CAE, CCE, IOM

CHIEF OPERATING OFFICER
Melinda Bentley, CAE

EDITORIAL BOARD CHAIR
Jennifer Johnson, CPA

MANAGER, MARKETING AND COMMUNICATIONS
Peggy Foley
pfoley@tx.cpa

MANAGING EDITOR
DeLynn Deakins
ddeakins@tx.cpa

COLUMN EDITOR
Don Carpenter, MSAcc/CPA

DIGITAL MARKETING SPECIALIST
Wayne Hardin, CDMP, PCM®

CLASSIFIEDS
DeLynn Deakins

Texas Society of CPAs
14131 Midway Rd., Suite 850
Addison, TX 75001
972-687-8550
ddeakins@tx.cpa

 

Editorial Board
Derrick Bonyuet-Lee, CPA-Austin;
Aaron Borden, CPA-Dallas;
Don Carpenter, CPA-Central Texas;
Rhonda Fronk, CPA-Houston;
Aaron Harris, CPA-Dallas;
Baria Jaroudi, CPA-Houston;
Elle Kathryn Johnson, CPA-Houston;
Jennifer Johnson, CPA-Dallas;
Lucas LaChance, CPA-Dallas, CIA;
Nicholas Larson, CPA-Fort Worth;
Anne-Marie Lelkes, CPA-Corpus Christi;
Bryan Morgan, Jr, CPA-Austin;
Stephanie Morgan, CPA-East Texas;
Kamala Raghavan, CPA-Houston;
Amber Louise Rourke, CPA-Brazos Valley;
Shilpa Boggram Sathyamurthy, CPA-Houston, CA
Nikki Lee Shoemaker, CPA-East Texas, CGMA;
Natasha Winn, CPA-Houston.

CONTRIBUTORS
Melinda Bentley; Kenneth Besserman; Barry Kaplan; Holly McCauley; Shicoyia Morgan; Craig Nauta; Kari Owen; Dipesh Patel, CPA, CGMA; John Ross; Lani Shepherd; Patty Wyatt

 

Your TXCPA membership has not been renewed for 2025 -2026. Renew now.