I would like to know QA process set up for this ETL testing and PowerBi testing.
Don’t know if these are helpful. If it doesn’t make sense, please let me know.
Random Tech Thoughts – 6 Apr 22
Testing a data pipeline
There are several approaches to testing a data pipeline – e.g. one built using an ETL tool such as SSIS or Azure Data Factory. In this article I will go through three, plus refer to another (…
Random Tech Thoughts – 23 Apr 22
Improving testability and observability of look-ups in data pipelines
Often in data pipelines (ETL or ELT pipelines for feeding a data warehouse, data science model etc.) we need to look up reference data that relates to the main flow of data through the pipeline. If…
Random Tech Thoughts – 24 Apr 22
Staging input data to improve testability in data pipelines
In a data pipeline (and ETL or ELT pipeline, to feed a data warehouse, data science model etc.) it is often a good idea to copy input data to storage that you control as soon as possible after you …
I think it’s similar to web testing - the front end bit (the report / web GUI) is harder to test than the back end (ETL / API).