Tác giả: Phan Le Vinh Thong - Bui Huu Dong - Nguyen Ngoc Tuan

Số trang: 213-223

DOI url:

Tóm tắt:

In today's highly competitive business environment, Data Warehousing (DW) and Online Analytical Processing (OLAP) have become indispensable for organizations seeking to enhance product development and maintain a competitive edge. Efficient data management and analysis are crucial for extracting valuable insights, driving strategic decisions, and improving Business Intelligence (BI). This paper explores how organizations can leverage DW and OLAP to strengthen BI capabilities, focusing on key architectural components, the Extract, Transform, Load (ETL) process, and the advantages of OLAP in handling complex analytical queries. Additionally, the study highlights practical applications and case studies that illustrate the impact of these technologies on business performance. By integrating robust data warehousing solutions with OLAP methodologies, organizations can optimize data analytics processes, uncover emerging trends, and foster sustainable growth.

TÀI LIỆU THAM KHẢO:

Geeksforgeeks (2024). What is Operational Data Stores? [Online] Available at https://www.geeksforgeeks.org/ what-is-operational-data-stores/ M. Mucchetti (2020). BigQuery for Data Warehousing: Managed Data Analysis in the Google Cloud. Springer, USA. P. Bhatia (2019). Data Mining and Data Warehousing Principles and Practical Techniques. Cambridge University Press, UK. S. Bakhshi (2023). Expert Data Modeling with Power BI: Enrich and Optimize Your Data Models to Get the Best Out of Power BI for Reporting and Business Needs. Packt Publishing Limited, USA. Stavros Harizopoulos, Daniel J. Abadi, Samuel Madden, & Michael Stonebraker (2008). OLTP through the looking glass, and what we found there. In Proceedings of the 2008 ACM SIGMOD international conference on Management of data (SIGMOD '08). Association for Computing Machinery, NY, USA, 981-992. U. D. Surajit Chaudhuri (1997). An overview of data warehousing and OLAP technology. ACM SIGMOD Record, 26(1), 65-74. V. S. Thomas Snyder (2018). Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2. MC Press, USA.

Từ khóa:

data warehouse, OLAP, business intelligence, decision-making, data analytic