Technical requirements
Before we dive into our discussion, we must have the following in place:
- Microsoft Excel 2016 or later (in case you do not have this installed on your machine, you may access Microsoft 365 for free on the web through this link: https://www.microsoft.com/en-au/microsoft-365/free-office-online-for-the-web)
- A web browser to access Google Sheets
- A Google account to access Sheets (free version)
The sample data quality scorecard in Microsoft Excel is saved in the Packt GitHub repository and can be accessed at this link: https://github.com/PacktPublishing/Managing-Data-Integrity-for-Finance/tree/main/ch03.
Note
The scorecard for Google Sheets can be accessed here: https://docs.google.com/spreadsheets/d/1wD759gINukpu9VJOJWECdG0PwcrWX_C-2DfsASZBxAc/edit?usp=drive_link.
Once these are ready, you can proceed to the following steps.