CHAPTER 5

Chapter Overview

  • Focus: Data Storage & Analysis

  • Authors: Savage, Brannock, Foksinska

Chapter Preview

  • Types of Data: Categorization of data based on its structure and usage.

  • Data Storage Methods: Techniques utilized for data preservation.

  • Characteristics of Data: Fundamental features that define data types.

  • Data Usage: Applications of data analytics in accounting.

Learning Objectives

  • 5.1: Distinguish between data elements and data types.

  • 5.2: Explain storage mechanisms for data.

  • 5.3: Summarize the five characteristics of big data.

  • 5.4: Apply data analytics techniques to tackle accounting problems.

5.1: Data Elements vs. Data Types

  • Definition of Data: Comprises facts and statistics related to persons or objects, collected for reference or analysis.

  • Types of Data:

    • Data Elements: Basic units of data that make up information systems.

      • Key Data Elements:

        • Bit: Smallest unit of data.

        • Byte: Group of bits (usually 8 bits).

        • Field: Individual entry within a record.

        • Record: Collection of related fields.

        • File: A collection of records.

        • Database: Organized collection of files.

Hierarchy of Data Elements

  • Databases consist of files.

  • Files are made up of records.

  • Records consist of fields.

  • Fields consist of bytes.

  • Bytes consist of bits.

Data Types

  • Structured Data:

    • Defined data types (numbers, text, dates).

    • Easy to manage and store, displayed in tables.

  • Unstructured Data:

    • Includes images, audio, video, etc.

    • More challenging to manage; requires more storage.

Structured vs. Unstructured Data

  • Key Differences:

    • Structured Data: Easily organized into tables (e.g., spreadsheets).

    • Unstructured Data: Does not fit traditional data models, posing challenges for analytics.

Web 2.0 and Data Growth

  • Web 2.0: Marked by user engagement and content generation, transforming the internet from a read-only to a read-and-write platform.

  • Data Growth: Unstructured data growth outpaces that of structured data.

Static vs. Dynamic Data

  • Static Data: Remains unchanged after creation.

  • Dynamic Data: Subject to change and must be regularly updated.

5.2: Data Storage

  • Databases: Organized collections of data that improve accessibility.

    • Relational Databases: Structure data in interconnected tables.

    • Database Management Systems (DBMS): Software that manages databases, facilitates data queries.

    • Database Scalability: Ability to grow in size with user demand.

Types of Data Storage

  • Data Lake: Central repository for all forms of data (structured and unstructured).

  • Data Warehouse: Optimized for reporting and analysis, housing processed data.

5.3: Characteristics of Big Data

  • Big Data Definition: Encompasses large, complex datasets processed with advanced technological tools due to limitations of traditional approaches.

  • The 5 Vs of Big Data:

    • Volume: Scale of data.

    • Velocity: Speed of data generation.

    • Variety: Diversity of data types.

    • Veracity: Accuracy of data.

    • Value: Importance of turning data into actionable insights.

5.4: Data Analytics in Accounting

  • Categories of Data Analysis:

    • Descriptive Analytics: Insight into what has happened.

    • Diagnostic Analytics: Investigation of why something occurred.

    • Predictive Analytics: Forecasting what might happen.

    • Prescriptive Analytics: Guidance on how to respond.

Dashboards and Visualizations

  • Dashboards: Interactive tools for real-time data reporting.

  • Visualizations: Graphical representations aiding data comprehension.

Applications of Data Analytics in Various Accounting Fields

  • Audit & Compliance: Using data to match purchase orders and invoices for accuracy.

  • Financial Accounting: Analysis of financial data including ratios for informed decision-making.

  • Managerial Accounting: Developing metrics for performance monitoring.

  • Tax Accounting: Identifying trends in tax payments and advising clients on tax implications.

Conclusion

  • Understanding data structure and analytics is crucial for modern accounting practice, enabling professionals to derive actionable insights from vast amounts of data.