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:
https://youtu.be/R-krH66K3xs
For paperback visit CreateSpace eStore: https://www.createspace.com/5897610
The author also coaches for ISTQB certifications; foundation and advanced.
