Testing BI and ETL Applications with manual and automation approach: A comprehensive guide for Business Intelligence project evaluation By Shanthi Vemulapalli Kindle Edition Testing BI and ETL Applications with manual and automation approach: A comprehensive guide for Business Intelligence project evaluation Please read this before buying Also look for this book video before buying then decide Background on writing this book: The BI Projects are heart of the any business organization. The IT departments need to struggle a lot to bring them into a good shape by spending thousands of man days efforts towards data validation, cleansing, transforming, consolidating and presenting to the users. At the same time the BI Project evaluation for its implementation is a challenge to any IT organization. The resources should be well understood on its activities by collecting latest information. They also need to work in collaboration with the technical teams by understanding the latest design and development requirements. At the same time they need to confirm with the users on their understanding of the latest requirements before stepping into the evaluation process. This activity denotes lot of resource education is required for BI Projects evaluation. One might get the following questions also into their mind: What kind of techniques can be used for data transformation? Why do you need to evaluate thoroughly the BI applications? Why do you need a Big Bang kind of test coverage for BI Projects? Why do you need different environments for BI Projects? What kind of testing is involved? Is there any test automation process involved for BI projects? If you are nominated as a business representative to certify the ETL/BI Application; you might ask some of the following questions. i) Is the appropriate data being extracted? ii) If the source data element is split into multiple columns, is it done correctly during the transformation process? iii) If some data elements are merged together did any integrity problems result from this transformation process? iv) Is the data loaded correctly into the appropriate BI target databases and the appropriate BI tables? v) Can the data in the BI target databases be reconciled with the source files and source databases? Where are the reconciliation totals stored? vi) Are data values correctly transformed and cleansed? Is bad data slipping through without notice? vii) Is the load performance adequate? And is the BI data available to the business people when they expect it? For all the above test scenarios; this Book can denote the solutions to follow. By considering the above clarifications or questions; with my past 10 plus years of work experiences on these kind of projects, I have made this detailed E Book to understand the Data warehouse concepts in depth, the development activities and the feasible testing methodology need to be used for applying the evaluation procedure. After going through this E Book with clear understanding on it, any BI professional can be ready to step into the BI project evaluation confidently with self motivation. Table of contents Chapter1 Introduction Chapter2 ETL Chapter3 Data warehousing Chapter4 Data Mart (DM) Chapter5 Business Intelligence Chapter6 Technologies and tools Chapter7 SDLC activities Chapter8 ETL development activities Chapter9 BI application development activities Chapter10 Predicted issues Chapter11 Testing methodology Chapter12 Checklists for ETL test planning Chapter13 Test Automation activities Chapter14: Test cases and requirements analysis Chapter15:Analyze for Test Automation I have made a book video and is available on:

PDF Testing BI and ETL Applications with manual and automation approach pdf

Consolidating and presenting to the users At the same time the BI Project evaluation for its implementation is a challenge to any IT organization The resources should be well understood on its activities by collecting latest information They also need to work in collaboration with the technical teams by understanding the latest design and development requirements At the same time they need to confirm with the users on their understanding of the latest requirements before stepping into the evaluation process This activity denotes lot of resource education is required for BI Projects evaluation One might get the following questions also into their mind What kind of techniques can be used for data transformation Why do you need to evaluate thoroughly the BI applications Why do you need a Big Bang kind of test coverage for BI Projects Why do you need different environments for BI Projects What kind of testing is involved Is there any test automation process involved for BI projects If you are nominated as a business representative to certify the ETL BI Application you might ask some of the following questions i Is the appropriate data being extracted ii If the source data element is split into multiple columns.

#heading[2]

Is it done correctly during the transformation process iii If some data elements are merged together did any integrity problems result from this transformation process iv Is the data loaded correctly into the appropriate BI target databases and the appropriate BI tables v Can the data in the BI target databases be reconciled with the source files and source databases Where are the reconciliation totals stored vi Are data values correctly transformed and cleansed Is bad data slipping through without notice vii Is the load performance adequate And is the BI data available to the business people when they expect it For all the above test scenarios this Book can denote the solutions to follow By considering the above clarifications or questions with my past 10 plus years of work experiences on these kind of projects.

#heading[3]

Any BI professional can be ready to step into the BI project evaluation confidently with self motivation Table of contents Chapter1 Introduction Chapter2 ETL Chapter3 Data warehousing Chapter4 Data Mart DM Chapter5 Business Intelligence Chapter6 Technologies and tools Chapter7 SDLC activities Chapter8 ETL development activities Chapter9 BI application development activities Chapter10 Predicted issues Chapter11 Testing methodology Chapter12 Checklists for ETL test planning Chapter13 Test Automation activities Chapter14 Test cases and requirements analysis Chapter15 Analyze for Test Automation I have made a book video and is available on Testing BI and ETL Applications with manual and automation approach A comprehensive guide for Business Intelligence project evaluation

Testing BI and ETL Applications with manual and automation approach: A comprehensive guide for Business Intelligence project evaluation By Shanthi Vemulapalli

42

Kindle Edition

Book Testing BI and ETL Applications with manual and automation approach

Book Testing BI and ETL Applications with manual and automation approach synonym

Book Testing BI and ETL Applications with manual and automation approaching

Book Testing BI and ETL Applications with manual and automation approachable

Book Testing BI and ETL Applications with manual and automation approached

Book Testing BI and ETL Applications with manual and automation approach wedge

Book Testing BI and ETL Applications with manual and automation approach-avoidance

Testing BI and ETL Applications with manual and automation approach book

Testing BI and ETL Applications with manual and automation approach booking

Testing BI and ETL Applications with manual and automation approach booklet

Testing BI and ETL Applications with manual and automation approach booker

Testing BI and ETL Applications with manual and automation approach bookworm

Testing BI and ETL Applications with manual and automation approach bookkeeping

PDF Testing BI and ETL Applications with manual and automation approach pdf

PDF Testing BI and ETL Applications with manual and automation approach

.

#heading[4]

Please read this before buying Also look for this book video before buying then decide Background on writing this book The BI Projects are heart of the any business organization The IT departments need to struggle a lot to bring them into a good shape by spending thousands of man days efforts towards data validation cleansing transforming I have made this detailed E Book to understand the Data warehouse concepts in depth the development activities and the feasible testing methodology need to be used for applying the evaluation procedure After going through this E Book with clear understanding on it.