Imagine that you are hired as a CIO of a quickly growing retail chain with an online presence. You have growing transactional databases but want to build a business intelligence infrastructure. You also have various departments within your company with databases such as marketing, customer service, accounts payable, sales, and accounts receivable. What would your proposed business intelligence infrastructure consist of? Justify your decisions. 75 + words
Answer preview
The primary goal of business intelligence infrastructure is to deliver useful and accurate information to decision makers (Laudon & Laudon, 2015). For this reason, I would propose first to have a relational data warehouse that is responsible for storing data that will feed the systems of BI. Use of Data Extract, Transform and Load (ETL) will help in moving data from the retail chain systems to the data warehouse. Metadata layer will help the business users to use and interact with the data, and the consumption layer will promote the delivery of data to the users.
