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.

 

 

 

  • The Future of CPA Licensing: TXCPA Members in Action at the State Capitol

    With the profession facing a talent shortage, legislative efforts are underway to introduce alternative pathways to licensure. Additionally, bills have been introduced to address CPA mobility and practicing accounting across state lines. TXCPA members took action at the Texas Capitol to address and emphasize the importance of these initiatives in strengthening the profession.
    View Article
  • CPE: Corporate Codes of Conduct - Similarities and Differences, and Implementation and Communication Strategies

    Codes of conduct serve as essential guidance for organizations, ensuring ethical behavior, regulatory compliance and corporate integrity. This article examines the significance of codes of conduct, highlighting examples from Fortune 500 companies. Effective implementation involves executive endorsement, ongoing communication and integration, and reinforcing accountability.
    View Article
  • Build on Our Momentum

    During TXCPA's 2025 Advocacy Day at the state Capitol, CPA professionals met with legislators to discuss proposed legislation on alternative CPA pathways and mobility. These efforts strengthened relationships with lawmakers, positioning CPAs as trusted advocates for the profession. The positive feedback from legislators reflects the impact of these advocacy efforts.
    View Article
  • Assessing AI From a Tax Perspective, Part 2

    In part 2 of a series, this article examines the risks and limitations of using AI in tax preparation. While AI tools like ChatGPT, Copilot, Perplexity, and TaxGPT can assist with tax research, their accuracy depends on precise prompts and professional oversight. Responses are often outdated, misleading or incorrect, posing risks to professionals who rely on them without verification.
    View Article
  • Understanding Sustainability Accounting Standards Board Standards

    The Sustainability Accounting Standards Board (SASB) provides industry-specific guidelines for companies to report on ESG factors that impact financial performance. Companies use SASB metrics to enhance investor transparency and manage ESG risks. While SEC regulations on sustainability remain pending, over 3,000 companies worldwide have voluntarily adopted the standards to improve corporate performance.
    View Article
  • What’s Happening Around Texas - March-April 2025

    TXCPA chapters across Texas hosted various events to engage members and support future CPAs. TXCPA Dallas held a Coffee & Connections event, while TXCPA East Texas members inspired students at UT Tyler’s Beta Alpha Psi meeting. TXCPA Fort Worth welcomed new licensees at a luncheon and in San Antonio, members celebrated new iDEAL graduates and elected the 2025-2026 Officers and Directors.
    View Article
  • Navigating Timekeeping Compliance in Government Contracting

    Texas contractors receiving government funding must maintain rigorous accounting practices, particularly in timekeeping and labor distribution, to ensure they are adhering to federal regulations. CPAs and finance professionals play a crucial role in enforcing applicable standards. Mastering timekeeping is essential to help meet federal standards and uphold the integrity of taxpayer-funded projects.
    View Article
  • Spotlight on CPAs: Shilpa Boggram Sathyamurthy, CPA-Houston, CA

    Shilpa Boggram Sathyamurthy is an accounting profession leader with experience in both public and industry accounting. In this Spotlight on CPAs article, she discusses the differences in their focus, workload and learning opportunities. She also actively contributes to TXCPA through committee service, valuing collaboration and professional development.
    View Article
  • Do New SEC Disclosure Requirements for Share Repurchases Dilute Their Benefit?

    The SEC introduced new disclosure requirements for share repurchases, aiming to increase transparency. Under the updated rules, companies must now disclose daily repurchase data in quarterly reports. Companies must also disclose whether insiders traded in the four days before or after announcing a buyback. The rules do not specifically address accelerated share repurchase programs.
    View Article
  • Custom Reporting Solutions for ASC 842 Lease Accounting

    ASC 842 compliance remains challenging as organizations manage complex lease portfolios and multiple accounting systems. While standard software offers reporting features, many require custom solutions to integrate specific accounting attributes and enhance internal controls. Using a structured approach to developing custom reports can help improve efficiency and support the decision-making process.
    View Article
  • 2024-2025 Accounting Education Foundation Scholarship Recipients

    The TXCPA Accounting Education Foundation (AEF) awards scholarships to outstanding students, providing not only financial aid but also connections to a supportive community of experienced professionals. Congratulations to these exceptional students for their dedication and commitment to excellence!
    View Article
  • Take Note

    In this edition of Take Note: How to Get the Latest Updates on BOI Reporting; Safeguard What Matters Most; Accountants Confidential Assistance Network; Advocacy Day and Midyear Leadership Council Meeting; TXCPA Career Center; CGMA® Designation
    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; Holly McCauley; Craig Nauta; Kari Owen; John Ross; Lani Shepherd; Patty Wyatt

 

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