Presented By Ron Moore
Thorough testing, reconciliation, and data validation can consume a lot of time and can be a painful process. Not doing it thoroughly can be even more so. But it doesn’t have to be. With a little ingenuity and a few tricks, you can get control of the validation process rather than letting it get control of you.
In this session, we start with a few design principles, examine the tools available, and discuss some of the most common challenges. Then using some examples from real-world projects, we will examine a range of techniques from automated, synchronized audit sheets, to pivot tables, to difference cubes. Lastly, we will talk about how a few fairly recent features have extended the possibilities and made the process easier.
Recorded on: Friday, October 7th