How to make Quality Assurance and unit tests for a DW/BI project?

View previous topic View next topic Go down

How to make Quality Assurance and unit tests for a DW/BI project?

Post  aderic on Tue Mar 10, 2009 12:51 pm

Hi,
How to write a Quality Assurance (QA) tests documents for a DW/BI project. Who are involved, what do we need and what are the steps to follow? What do we really have to test?
How do developpers make the unit tests for the ETL process or BI applications? Do they also have to follow or write any documents?
Can you help me to get QA and unit tests document samples for DW/BI projects.

Thank you
(sorry for my bad english)

aderic

Posts : 1
Join date : 2009-03-10

View user profile

Back to top Go down

ssisUnit for Microsoft SSIS

Post  Todd McDermid on Thu Mar 12, 2009 2:03 pm

There is a unit testing tool developed for Microsoft's ETL environment - it's ssisUnit, and it's free on CodePlex. That might help with part of your request...
avatar
Todd McDermid

Posts : 11
Join date : 2009-02-04
Location : Nanaimo, BC

View user profile http://toddmcdermid.blogspot.com

Back to top Go down

QA/Unit test examples...

Post  krisdecker on Wed May 13, 2009 6:23 pm

I am curious, from a best practices perspective, where people lie in terms of formalized testing of DW projects.

I mean, a software project if fairly straightforward (IMHO) from a testing perspective... What about DW? We constantly debate where DEV/unit testing ends and INTG begins, etc. We also tend to focus 90% in the ETL space (probably appropriate)....

Thoughts?

krisdecker

Posts : 7
Join date : 2009-05-13

View user profile

Back to top Go down

Re: How to make Quality Assurance and unit tests for a DW/BI project?

Post  BoxesAndLines on Thu May 14, 2009 8:36 am

Having worked at multiple clients, I can tell you there is no consistent approach on testing DW applications. In theory, DW's should be held to the same standard as any other software application. I see two general areas of interest in testing DW's. The first you already mentioned, ETL. Source to target transformations should be tested for correctness. This is only possible if you actually maintain source to target mappings. These mappings are the coding specifications for the ETL developers. I've known many a developer that misinterpreted a mapping rule. The second area is reporting. Do the metrics reconcile to the source system(s)? Do the dimensions manage change correctly? If your group is also responsible for the BI Tool then this must also be included in the test plan.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: How to make Quality Assurance and unit tests for a DW/BI project?

Post  krisdecker on Thu May 14, 2009 9:06 am

thanks, BoxesAndLines...

Yeah, this seems pretty consistent with what I am seeing....

krisdecker

Posts : 7
Join date : 2009-05-13

View user profile

Back to top Go down

Re: How to make Quality Assurance and unit tests for a DW/BI project?

Post  dhoom on Fri Oct 24, 2014 3:16 am

You may want to have a look at Cindi Howson's BIScorecard.com for an evaluation of OBIEE and other BI products.

dhoom

Posts : 1
Join date : 2014-10-24

View user profile

Back to top Go down

Re: How to make Quality Assurance and unit tests for a DW/BI project?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum