Testing BI and ETL Applications with manual and automation approach: A comprehensive guide for Business Intelligence project evaluation - Softcover

Vemulapalli, Mr. Shanthi Kumar

Softcover

ISBN 10: 1519539789 ISBN 13: 9781519539786

Publisher: CreateSpace Independent Publishing Platform, 2015

Synopsis

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 educations 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. I have made a video and available on: https://youtu.be/R-krH66K3xs

About this title

About the Author

I am an Indian and currently stay in India. I have worked in the IT Industry for more than 25 years internationally. My work experienced countries are; India, Saudi Arabia, USA, CANADA, HK, UK and Australia through different IT services companies. I burnt lot of my hours in keep learning in the IT industry and also in general skills to cope up with the Job competencies at different levels and locations. For your kind information, there were no coachers or guiders for me. Hence it was very hard to build my competencies. With my past experience and the knowledge gained, I would like to utilize it to share through writing the books and distribute them internationally. So that the readers could save some of their by using those experiences and techniques. Hopefully my books can bring up their skills groomed well for their regular and work life. I would like to bring up the Non-IT topics related books also from my experiences. I am so glad to meet all of you through the international electronic publishers to reach different geographical locations in the globe. If you read and find any improvements for my books, I would highly appreciate it. Nice meeting you all and good luck for your future endeavors.

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2015
• ISBN 10: 1519539789
• ISBN 13: 9781519539786
• Binding: Paperback
• Language: English
• Number of pages: 42