Book Image

Managing Data Integrity for Finance

By : Jane Sarah Lat
Book Image

Managing Data Integrity for Finance

By: Jane Sarah Lat

Overview of this book

Data integrity management plays a critical role in the success and effectiveness of organizations trying to use financial and operational data to make business decisions. Unfortunately, there is a big gap between the analysis and management of finance data along with the proper implementation of complex data systems across various organizations. The first part of this book covers the important concepts for data quality and data integrity relevant to finance, data, and tech professionals. The second part then focuses on having you use several data tools and platforms to manage and resolve data integrity issues on financial data. The last part of this the book covers intermediate and advanced solutions, including managed cloud-based ledger databases, database locks, and artificial intelligence, to manage the integrity of financial data in systems and databases. After finishing this hands-on book, you will be able to solve various data integrity issues experienced by organizations globally.
Table of Contents (16 chapters)
1
Part 1: Foundational Concepts for Data Quality and Data Integrity for Finance
5
Part 2: Pragmatic Solutions to Manage Financial Data Quality and Data Integrity
10
Part 3: Modern Strategies to Manage the Data Integrity of Finance Systems

Conventions used

There are a number of text conventions used throughout this book.

Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: “Using the SELECT FOR UPDATE statement applies a row-level lock on that row and waits for the previous instance to complete before going to the next.”

A block of code is set as follows:

INSERT INTO Accounts (AccountID, Balance)
VALUES (1, 100.00);

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

CREATE TABLE Accounts (
    AccountID int,
    CustomerName varchar(100),
    Balance decimal(10, 2) CHECK (Balance >= 0)
);

Bold: Indicates a new term, an important word, or words that you see onscreen. For instance, words in menus or dialog boxes appear in bold. Here is an example: “To access the Data Analysis GPT, click on Explore in the sidebar and select Data Analysis from the list of GPTs available.”

Tips or important notes

Appear like this.