Main Article Content
Now days, the world technologies are an increasing development and observed in the usage of computer networking, social media and Internet of things (IoT). Research experiments generate large amounts of data that need to be collected, analyzed and managed. Researchers have found an increase in data containing useful and ineffective entities. The data warehouse finds difficulties in extracting useful information and increasing the amount of data generated. The data warehouse analysis developed as promising area in research which supports business organization like decision making. Also data mining supports information detection by determining associations, hidden patterns, building analytical models, and performing prediction and classification. Hence, this article gives the comprehensive review of data warehouse techniques, data warehouse demerits, and data mining approaches. Furthermore, it also explains the data warehouse appeared in decision making perspective and research problems in data warehouse and data mining.