6

Implementing Best Practices When Using Business Intelligence Tools

In the previous chapter, we learned how to use business intelligence (BI) tools to fix data integrity issues. We also covered the various data profiling features available and how to remove empty cells, remove duplicates, manage relationships in data models, identify data outliers, and deal with large financial datasets using data validation.

In this chapter, we will discuss the best practices when using Power BI Desktop, Tableau, and Alteryx Designer for data quality and integrity. By the end of this chapter, you will have a better understanding of how to leverage best practices when using these BI tools to ensure data integrity in finance.

We’ll cover the following in this ...

Get Managing Data Integrity for Finance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.