No More Firedrills Guide to Business Intelligence Testing
This Free eBook shares the Experience of Data Quality Experts
See how top-notch experts get business intelligence systems delivering trustful and reliable data by applying a proper testing strategy. This 5-star rated guide from the "No more firedrills" series, shows you how to automate testing, to make it more efficient and put developers out of the misery of performing poor testing tasks.
In this guide you will discover:
Testing is often underestimated because the subject raises some important questions. We often hear, for example, that people want to test their data warehouse "only later", or "why should I test it at all"? Or "we have built our own testing framework".
We are taking a closer look and correcting these statements.
We use a state-of-the-art BI-architecture to show you the topic of testing. This includes components like staging area, ETL- or ELT process, data loading and data cleansing as well as data marts and analytical models.
Loading data from different sources with different behavior and specifications, means that many things can go wrong. The eBook shows you some tactics to ensure nothing bad happens with your data.
A staging area is a good point to start abstracting, cleaning and transforming data by your ETL-process. But ETL-processes need the right data at the right point in time to run successfully. That's why we show you some practical ideas how to ensure that everything happens at the right time.
Whether you collect and combine your data in a Kimball-based dimensional data warehouse, in an Inmon-based 3NF data warehouse or even in a data vault by Linsted, quality is king.