|
AUTHOR(S): Varun Bitkuri, Sunil Jacob Enokkaren, Avinash Attipalli, Raghuvaran Kendyala, Jagan Kurma, Jaya Vardhani Mamidala
|
TITLE Survey on Data Warehouse-Based Business Intelligence (BI) Systems for Strategic Decision Making |
 PDF |
ABSTRACT The increase in the volume of data in the organization has led to more issues like poor consistency in data quality, disjointed analytical process, and delay in extracting insights into actionable process, which has weakened strategic decision-making in any sector. To mitigate these challenges, the current paper explores the architecture and operation of data warehouse-based Business Intelligence (BI) systems with an emphasis on the contribution of ETL processes, data integration processes, OLAP processes, as well as analytical instruments that transform unprocessed data into credible and useful information. The paper discusses the development of the BI technologies, evaluates their existing strengths and weaknesses in industries such as retail, finance, healthcare, and manufacturing. The constant issues associated with lack of scalability, low interoperability, dependence on batch-based ETL workloads, and limitations on real-time analytics are pointed out. The new research hypothesizes a Conceptual BI Evolution and Cross Industry Integration Framework, a new framework that brings together data collection and transformation, data storage, analytics, and decision-support layers in a unified and scalable framework applicable to the various industries. The framework shows the maturity of BI systems and interaction within sectors as a roadmap towards improving real-time responsiveness, adaptability and cross-industry usability. The results indicate that contemporary businesses need agile, real-time and business-friendly BI architecture to enhance operational efficiency, organizational intelligence, and strategic decision-making that is futuristic. |
KEYWORDS Business Intelligence, Data Warehousing, ETL Process, OLAP, Data Mining, Predictive Analytics, BI Evolution |
|
Cite this paper Varun Bitkuri, Sunil Jacob Enokkaren, Avinash Attipalli, Raghuvaran Kendyala, Jagan Kurma, Jaya Vardhani Mamidala . (2025) Survey on Data Warehouse-Based Business Intelligence (BI) Systems for Strategic Decision Making. International Journal of Computers, 10, 337-347 |
|
