Assignment No:03
2. Suppose an organization has initiated a project to build a data warehouse, according to the proposal submitted to the management, the investment is a few dozens of millions of rupees. a.) Draw a suitable diagram that depicts a data warehouse architecture. b.) State 2 advantages of data warehouse to an organization. Enables organizations to forecast with confidence. Improves the decision making process. c.) Data warehouse projects are large IT investments that are susceptible to fail. Briefly explain 3 possible factors that effect the success or failure of large IT investments taking data warehousing as an example. Identify your existing bottlenecks that are slowing down the flow of information. Performance optimization won’t matter if that is not done first. The design should always focus on ease of use and speed. Design is very important because users can be distracted by making their data warehouse into an intricate design...