I’ve been in our MI/BI team a while now, and it is all around data warehouses, databases and SQL. No web pages, no HTTPS, no APIs, just lots of SQL queries.
And it got me thinking, if you were put onto a project/team where you were testing data had been put into your database correctly, and that when reports are made to query that data, it was built correctly…
How would you test it?
Would you know where to start? Would you ask other testers in your team how they do it? What if you’re the only tester and don’t have that luxury?
Would you Google it, to try and understand, only to be confused by terms such as ETL, EDW, dimensional models, OLAP, data marts?
It then got me thinking, would a guide (or even course) onto what a data warehouse is, SQL fundamentals (as if you have never needed to query a database before, would you know how?), how you might test the report from the back-end compared to the front end and looking at the output, and so on.
For those of you who do MI/BI testing with a data warehouse, how did you get into it, and what keeps you with it? I know it is a niche area, but with data and reports on that data continuing to grow, it’s something I feel as testers we should be aware of, even if not able to use every day.