Is your DataWarehouse a success?

How do you measure Datawarehouse (DW) effectiveness? How do you know your DW is a success? What are metrics to measure a DW? This post outlines my thoughts around answers to above question: There are two components to DW or also commonly called as Business Intelligence (BI) teams. 1) DW/BI Platform ( RDBMS, MPP systems,…

1

BI Metrics effectiveness without next steps

I have been testing the Business Intelligence (BI) applications since 2007 now and in last 7 year, with every assignment comes across new metrics. Simple Imaginary examples of Metrics to set context are: Percentage of Revenue by Region Distribution of Sales by Region No. of defects per release Ever wondered what leadership or business teams would do…

0

Datawarehouse testing using MiniDBs for IT

In Business Intelligence(BI) applications there are Datawarehouse(DW) which holds data in Tera Bytes and sometimes go up to as many as 50-100 data sources. Testing such applications requires huge test servers and longer data testing cycles. The risk of source systems being down or in restore mode when ETL was running is not in team’s…

0

Data Dictionary based Testing (DDbT) for Business Intelligence Applications

This Paper  tries to present a new  test methodology which can help us better test Business Intelligence (BI) or Data warehouse (DW) with more coverage, more data centric approach and with less time. The horizon’s to cover with this idea are endless to explore. Assume that we want to test a Business Intelligence (BI) or Data…

0