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

Reviewing the most popular BI tools and how to get started with them

In the previous section, we explored the common data quality management capabilities of BI tools. In this section, we will discuss some of the most popular BI tools at the moment and how to set them up on your local machine or personal computer/laptop. We will also cover the relevant features of these tools to improve data integrity.

Microsoft Power BI

Microsoft Power BI is a powerful BI tool that allows users to visualize, analyze, and share data insights across an organization. The tool offers a broad spectrum of features, ranging from basic data visualizations to advanced analytics capabilities.

Figure 4.1 – Sample visualization in Microsoft Power BI

Figure 4.1 – Sample visualization in Microsoft Power BI

Figure 4.1 shows a sample visualization in Power BI Desktop. Here, we make use of a scatter chart to visualize the data to more easily identify any potential outliers.

Given that we will use Power BI in the following chapter...