Before you start analyzing or reporting on your data, you need to be sure that you're working with good quality data. With the new Data Quality dashboard, you can do just that. From a clearer way to identify anomalies in your data to a progress bar that tracks the review process, we've got you covered. Let's dive into the latest updates.
What's new? 🧐
The Review tab has been around for some time. However, we've recently made some changes to its component parts to make it more intuitive to use. The latest update is to the Data Quality sub-tab, the first place you visit in Review.
Eliminating repetition
Previously, you could access health reports for data and anomalies separately. However, these have now been combined to streamline the process and eliminate any redundancies.
New header cards
At the top of the screen, you will see header cards. By default, these cards will be blank. However you can edit them to highlight specific accounts or transactions to which you may want to pay closer attention. You can also pin any card you want to see to the top or remove irrelevant cards.
Add columns
By default, you'll see the following columns in the table:
Identified - anomalies or potential issues identified
Reviewed - the number of those identified that you have reviewed
Progress - the percentage of items reviewed
However, you can also add a column for importance to rank any of those items as less or more important. And you can add a column for people to allocate certain team members to those items.
Pro Tip 💡: As was the case previously, you can always delete rows that you deem irrelevant. However, if you find you've made an error in deletion, don't worry! You can just click the "Reset" button to return the table to its default setting.
Keep track of your review progress
One of the greatest new additions to the Data Quality tab is the ability to track your progress with the Progress column. Here, you can see what percentage of anomalies or data issues have been reviewed and it changes from red to orange to green to visually show your progress.
Pro tips 💡
What else can you do in Data Quality? Here are a few tips and tricks:
Hide columns: Don't want to see one of your added columns but don't want to delete it? You can hide it by clicking on the eye icon. Just a note that this is only an option for people and importance columns, not your default columns.
Set importance: The importance column comes with drop-down options for color-coded levels of importance from low to critical.
Select the month: You can choose which month to show and you'll see data for the prior 12 months.
Add comments: If you hover over a row in the column, you will see a little square, which gives you the option to add a comment.
Report on your data quality: Last, but certainly not least, you can add this data quality table to a report pack.
Closing thoughts 💭
The power of data lies in its ability to be analyzed, interpreted, and leveraged to improve your business performance in the future. That's why it's so important that you ensure that the data you are working with is accurate before you use it to inform your decisions. With this new Data Quality check, you have the power to review your data quality and ensure its integrity before you start reporting. So, what are you waiting for?