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

Managing data integrity issues with BI tools

BI tools have a powerful suite of capabilities, one of which is the ability to extract, transform, and load (ETL) data from multiple sources. We will discuss first the ETL capabilities of Microsoft Power BI Desktop in reviewing the data type format used for an Excel file prior to loading the information for further analysis, and then we will cover how to do this in Tableau Desktop. Let’s dive into the topics!

First, we load the data into Power BI by clicking on Get data under the Home tab and selecting Excel workbook, as highlighted in Figure 5.1:

Figure 5.1 – Getting data from Excel workbook

Figure 5.1 – Getting data from Excel workbook

We can see from this figure that from Get data, we can load various common data sources, such as an Excel workbook, Power BI datasets, SQL Server, or even data from the web. You can also click on More… to extract the data from other sources, such as a PDF file, a SharePoint folder, and online services...