- (a) Identify the main functional areas of a typical manufacturing company and briefly
describe the main activities in each area. [4 marks]
- Briefly explain how and why an ERP system improves efficiencies and productivity in a company that previously did not have an ERP system.
- Explain how SAP captures and (internally) represents nearly all aspects of a company’s functional areas. Note that this is a question about the static aspects of a company and so your answer must focus on organisational structures and company data.
Diagrams, graphs or charts can be added but only if they are used to support your explanations and are fully explained. Inserting inappropriate or irrelevant diagrams will result in a loss of marks. Your answer for Q1 should be about 1.5 to 2 pages depending on whether you insert diagraphs, charts or tables.
- (a) Explain what is meant by the term “Master Data” and how does it differ from
- Explain how a SAP Master Data Record is structured using organisational levels and views (screens). Why are Master Data Records structured in this way? Use the example of a Customer Master to support your explanation. [5 marks]
- Outline the difference between a Customer Master and a Material Master Data Record and explain why a Material Master is more complex than a Customer Master? [3 marks]
Diagrams or SAP screens can be added but only if they are used to support your explanations and are fully explained. Your answer for Q2 should be about 1.5 to 2 pages depending on whether you insert diagraphs and/or screens.
[INSERT YOUR ANSWER HERE]
This is an open-ended question designed to test your ability to apply your knowledge of information technology or your knowledge of how enterprises work in the real world. Chapters 3 and 11 in the Supplementary Lectures Folder as well as the information on SAP HANA found in the Additional Lecture Material folder are required reading for this question. Very good answers will be awarded BONUS MARKS.
- (a) Business Intelligence is a rapidly developing component of all ERP system. Explain
what business intelligence is, and why it is an important business tool.
- Traditional Business Intelligence is very closely linked to how data is organised, stored and how it is managed. Can we derive Business Intelligence directly from a database or do we need to implement a data mart or a data warehouse? Explain your conclusion(s).
- Explain the difference between a database and a data warehouse. Briefly explain what the terms OLTP and OLAP mean and why these terms are important when discussing the difference between a database and a data warehouse.
- An important measure of any database management system is how effectively related data can be collected, organized and presented as reports, and also for business intelligence. What techniques from data warehousing and data mining would be used to facilitate this.
- Technical advances in memory chips (see SAP HANA) have enabled “real-time” (operational) Business Intelligence. Explain how this works and why it is a very valuable tool for employees at all levels and for the company as a whole.