Norsk Datautsalg A / S (NODAS) has made the decision that they want a data warehouse. Still, there are some forces within the organization, especially in the IT department, who need to be convinced, and who believe that one have not investigated well enough about any mistakes that are common to make. The general manager of NODAS, Lars Gjeks, has on his own initiative set the framework for the project and has set aside one million kroner in the budget and five months to complete the construction of the data warehouse. He has set strict requirements to stay within these limits. He considers it an internal job, ie that it is the IT department that will take responsibility for creating a specification and implementing the development of the data warehouse. He does not want to take any further responsibility and expects you to lead the project and be responsible for delivery and development together with the IT department, which is ultimately the project owner. A professional in the IT department has had extensive experience with data warehouse implementation and has strong expertise in just that the data warehouse to be implemented. He has had weekly meetings with the management confirmed to ensure support for the project, but recommends keeping the sales department and marketing department out of the loop, as these Experience has shown that people do not have the necessary technical insight to do so to understand what is possible and not possible in an implementation process. Several in the sales department are looking forward to having a data warehouse in place where they can pick it up information, as many people think the ERP system that was implemented last year is very cumbersome to use. It has There has been no general acceptance of the system, and therefore the sellers have developed their own individual Excel documents in which they enter the sales they make. Some send this to the IT department for entry into the ERP system, but not all. Some people still use the old sales management system NODAS had before them implemented a full-scale ERP system. This old system is an interface on the web that writes to one database on the web server of NODAS. The database is no longer maintained by the IT department and they know nor that the sales department still uses the old system

Exercise 2.1 NODAS has difficulty understanding the difference between Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP). Therefore, in your own words, examine the main differences for NODAS. What opportunities does OLAP vs. OLTP? Expected Length: Approx. 500 words

Exercise 2.2 Now that the framework for the project has been set, NODAS would like to map out what kind of architecture will suit them best. a) Explain, in your own words, the difference between a Data Mart and a Data Warehouse. b) Present and describe in your own words two types of data warehouse architectures that you think may fit NODAS good, and argue why you mean it. Expected Length: Approx. 700 words

Exercise 2.3 The IT department in NODAS is skeptical about the challenges with the planned the data warehouse implementation has been mapped well enough. a) Based on all the information you have about NODAS, make a structured summary of the challenges they face today. Highlight the literature you have read so far in the subject to discuss why and how it should be resolved before work begins. b) Wixom and Watson mention various success factors in their 2001 article, An empirical investigation of the factors affecting data warehousing success . Discuss the extent to which these The success factors are still relevant today.