In Part 1 of this series, I introduced my methods for Test Driven Development for a Business Intelligence project, starting with a simple test or two. In Part 2, we went further and created methods to export the report into the format needed to compare its output to data retrieved via a SQL query. We then compared the total that is produced in the report to the total produced from a straight SQL query.
In Part 3, I’ll wrap this up to test to the scenario. We’ll modify the report to generate totals by sales rep as well as filter the data by a given time period. And we’ll begin with a test for this. Happy Coding!