In light of high cost and higher rate of failure of data warehousing projects, it becomes imperative to study software processes being followed for data warehousing. In this paper, the authors present a survey of literature for data warehousing requirement gathering and testing. This paper has analyzed drawbacks of traditional techniques for requirement gathering and testing of data warehouse. They have reported areas where more research needs to be focused. Using text analytics technique called “Word cloud”, they have analyzed main areas being researched and shown areas that need more focus.