Canadian Tires

1543 Words Sep 30th, 2012 7 Pages
1. What is BI and how can it help Canadian Tire? In the case there are 10 common challenges of BI implementations, which of these would you rate as most important for Eubanks and Wnek at CTC, and why? How would you address them? Business Intelligence (BI) is the consolidation and analysis of internal data and / or external data for the purpose of effective decision-making. At the core of all BI initiatives is a data warehouse to hold the data and analytics software. The data warehouse stores data from operational systems in the organization and restructures it to enable queries and models to extract decision support reports. The primary objective of BI was to support and enable business and IT strategies at CTC. In the …show more content…
CTC IT was largely seen as a hardware provider and manager but not as a strategic business partner.

3. Compare the exhibits that depict the current versus the future desired BI infrastructure. What challenges exist for the implementation of the BI initiative?

Fig: Current BI Environment In this figure, there are two sources of information for business: 1). Information from IW, which has passed through the ETL process before it goes to the end users. 2.) Information from independent data sources, which is processed by different standards. This is counter to the strategic goal of eliminating duplication of analysis, reporting and ad hoc analysis. This environment consumes more time for business users to understand end-user data, and more money for the firm which is wasted on different and possibly conflicting results.

Fig: Future BI Environment
This figure illustrates the future of BI for CTC. Independent data sources have been incorporated into a single BI system, within a global data model. All data will be loaded into corporate EDW via ETL. The EDW will feed the financial data mart for enterprise performance management, so business users will be able to conduct planning and budgeting functions. On the right side of the EDW, BI specialists will assist in organizing data marts into four categories: Supply Chain, Vendor,
Open Document