Canadian Tire's Current Data Warehouse

1381 Words6 Pages
Overview of Canadian Tire’s Current Data Warehouse Gathering requirements from end users was an important step in resolving the issues that currently exist at Canadian Tire. “Gathering requirements for a data warehouse is not the same as defining the requirements for an operational system” (Ponniah, pg. 121). When you research and then develop any system, it is critical that the system produces exactly what the users need to perform their specific tasks. CTC did not have this production for their end users. These users typically do not understand the big picture workings of a data warehousing process. Therefore, the help of a business analyst is critical. From the results provided in the case study, we can agree that these requirements must be addressed: • Capacity constraints • User query times • Defined data model • Full enabling of access to enterprise data Overview of Canadian Tire’s Business Intelligence The current process for CTC to acquire BI is a broken system. Much of the information derived, from the current data in the warehouse, was done by FRAG, individual user groups and hired business analysts who extracted data and created reports. This was creating a serious misallocation of resources and responsibilities throughout the company. Shadow groups, created to complete some of the required BI tasks, were not only less efficient than an organized strategy, but were also a security risk to CTC. With small groups taking over the responsibility of creating BI, the

    More about Canadian Tire's Current Data Warehouse

      Open Document