MODULE HANDBOOK DATA HANDLING & BUSINESS INTELLIGENCE (SBUS5105) LEVEL 5 SCHOOL OF BUSINESS FACULTY OF BUSINESS AND MANAGEMENT 2016-2017 AIM(S) The success of modern information systems is dependent upon the development of the databases upon which modern information systems are built. This module will provide students with a comprehensive understanding of how data systems work, how their benefits can be optimised and how to analyse and evaluate the information in the systems in order to obtain maximum benefit. LEARNING OUTCOMES Upon the successful completion of this module, the student should be able to demonstrate the ability to: 1. Identify and critically evaluate the current trends in data warehousing, business intelligence and data mining. 2. Demonstrate a comprehensive knowledge and systematic understanding of essential concepts and principles by using predicative analytic software. INDICATIVE CONTENT • Knowledge management fundamentals • Database systems and management • Data governance, architecture and analysis • Data security and quality management • Data warehousing and business intelligence • Practical issues in data management • Online Analytic Processing (OLAP) • The Data Mining Cycle • Reporting BIBLIOGRAPHY Essential Sharda, R., Dursun, D. and Turban, E., (2014) Business Intelligence and Analytics, Systems for Decision Support, 10th Ed., Pearson, Boston, MA. Sharda, R., Dursun, D. and Turban, E., (2014) Business Intelligence, A Managerial Perspective, 3rd Ed., Pearson, Boston, MA. Recommended Blenkhorn, D.L. and Fleisher, C.S. (Eds.), (2005) Competitive Intelligence and Global Business, Westport, Conn. Connolly, T. and Begg, C (2014), Database Systems: a Practical Approach to Design, Implementation, and Management, 5th Ed., Pearson, Boston, MA. Collier, K.W., (2011) Agile Analytics: A Value-Driven Approach to Business Intelligence and Data Warehousing: Delivering the Promise of Business Intelligence, Addison-Wesley Han, J., Pei, J., Kamber, M. (2011) Data Mining: Concepts and Techniques, London Howson, C., (2013), Successful Business Intelligence: Secrets to Making BI a Killer App, McGraw-Hill Osborne Ishikawa, A. and Nakagawa, J. (2013) Introduction to Knowledge Information Strategy, An: From Business Intelligence to Knowledge Sciences, World Scientific Publishing Laursen, G.H.N. and Thorlund, J. (2010) Business Analytics for Managers: Taking Business Intelligence Beyond Reporting, Winchester, John Wiley & Sons Raisinghani, M.S (Ed.), (2004 ) Business Intelligence In The Digital Economy: Opportunities, Limitations And Risks, Hershey, Pa. : Idea ; London Refaat, M. (2006) Data Preparation for Data Mining Using SAS, Morgan Kaufmann Sabherwal, R. and Becerra-Fernandez, I. (2010) Business Intelligence, , John Wiley and Sons: Chichester Van der Lans, R. (2012) Data Virtualization for Business Intelligence Systems, Morgan Websites http://www.digitalenterprise.org/ http://www.businessweek.com/ http://www.ecommerceexpo.co.uk/ https://www.gov.uk/government/publications http://ec.europa.eu/internal_market/e-commerce/directive/index_en.htm http://www.ictparliament.org/legislationlibrary/e-Commerce DRAFT - BACHELORS DEGREE ASSIGNMENT SPECIFICATION Student name: Student P number: Programme: BA Business Portfolio Module: Data Handling and Business Information Module Level (4, 5, 6): 5 Module code: SBUS5105 Contribution to Overall Module Assessment (%): 100% Lecturer: Chris Thomas Internal Verifier: Dr Roisin Mullins Assignment Titles: 1. Data Mining Project 2. Current trends in Data Warehousing and BI Assignment No (x of x): 1 & 2 Hand Out Date: October 2016 Submission deadline: 1. 16th December 2016 Feedback by 3th Feb 2017 2. 13th January 2017 Feedback by 10th February 2017 Referencing: In the main body of your submission you must give credit to authors on whose research your work is based. Append to your submission a reference list that indicates the books, articles, etc. that you have read or quoted in order to complete this assignment (e.g. for books: surname of author and initials, year of publication, title of book, edition, publisher: place of publication). Disclosure: I declare that this assignment is all my own work and that I have acknowledged all materials used from the published or unpublished works of other people. All references have been duly cited. Student’s Signature: (Only where hard copies are required) Date: Turnitin: All assignments must be submitted to Turnitin unless otherwise instructed by the Lecturer. Note: the Turnitin version is the primary submission and acts as a receipt for the student. Late submission of the electronic version of the assignment will result in a late penalty mark. Penalties for late submission: Up to four weeks late, maximum mark of 40%. Over four weeks late, Refer. Only the Extenuating Circumstances Panel may grant an extension. Learning Outcomes tested (from module syllabus) Assessment Criteria. To achieve each outcome a student must demonstrate the ability to: Identify and critically evaluate the current trends in data warehousing, business intelligence and data mining. • Effectively communicate information, analysis and argument by way of a written report • Analyse a topical case study and give relevant topical examples. Demonstrate a comprehensive knowledge and systematic understanding of essential concepts and principles of business intelligence and data handling through using predictive analytical software. • • Explore the use of a data mining tool for predicative analysis for various business scenarios. • Produce a written report • Please submit the assignment parts in a suitable report folder– not in polypockets. • This form (ALL PAGES) MUST be at the front of the paper submission. Assignments will not be accepted without this form as it is a requirement that you sign the disclosure regarding referencing convention. • DO NOT put this form into Turnitin or it will match many similarities with other students’ submissions. TASK 1 DESCRIPTION Assessment Component 1 – 75% You are a data analytics assistant, responsible for interpreting data from a company’s website. You use traditional software packages such as Excel for day-to-day analysis and more specialised data for mining the data. Part 1 – 50% Using the Cymru Office Supplies.xls data set provided, critically evaluate the strengths of using Excel for pre-processing the data, analysing the data and visualising the data. You will also need to demonstrate how you can do this practically with the use of Excel functions such as: IF, LOOKUP, PIVOT TABLES, charts and graphs. (1500 words) Part 2 – 50% Using the same data set explain the data mining approaches that might be employed to find out more about customers using more sophisticated environment such as WEKA. (1500 words) Scenario The data analytics company you work for has been approached by ‘Cymru Office Supplies’ an online retailer operating in wales. Over the past few years they have noticed a reduction in profits and are not sure why this should be the case. ‘Cymru Office Supplies’ has engaged your data analytics company to help them to analyse the information that they have and provide recommendations on how they can engage with analytics in the future to better inform their decision making process. ‘Cymru Office Supplies’ are looking for a solution that they can employ using their existing infrastructure which includes Excel records on sales which are populated daily by their sales system. They are prepared to look at data mining systems but cost is an issue. Students should explore the use of excel to assess and analyse the problem and to investigate what WEKA can do for them. The assignment submission must include the report along with the spreadsheet (and any other files prepared) showing your handling of the data, formulae and pivot tables etc. The combination of files should be in a zip file and uploaded to moodle. Submission Deadline 16nd Dec 2016 moodle deadline 23:59 Feedback returned by 3rd February 2017 TASK 2 DESCRIPTION Assessment Component 2 – 25% Written Report (1000 words) You will write a journal review on one current trend in Business Intelligence that you will have covered over the course of the semester which you will need to agree with your tutor. Your tutor is not only interested in the coverage and content of the topic being reviewed but also in your critical assessment of the ideas and argument that are being presented by the author. Instructions on paper format Title: The title must be in Times New Roman 12-point bold type and centered across the top of the page. Author: The name should be centered across the page Abstract: One paragraph (100 words maximum) in Times New Roman 12-point italics type immediately following the names of the author. Keywords: Select two to five keywords that capture the essence of your paper. Length: Papers must be, single-spaced including tables, figures, references, abstract and keywords list. Headings: Must be in Times New Roman 12-point bold type and centered. Tables and Figures: The formatting of tables and figures is left largely up to the author. Tables and figures should be sized and placed within the body of the paper. Care should be taken so that tables and figures are not separated between pages. Generally, tables and figures should be in Times New Roman 9- to 12-point type, and table column headings should be in bold. Suggested Structure • Briefly describe the issue, topic or problem that is the basis of the research. • Briefly describe why this is an important topic. • Explain the basis of the study. • Discuss the implications. • Provide conclusions. Limit to one paragraph. May be combined in a paragraph with implications. • References used or cited. Submission Deadline 13th Jan 2016 moodle deadline 23:59 Feedback by 10th February 2017 GUIDANCE FOR STUDENTS IN THE COMPLETION OF TASKS NOTE: The guidance offered below is linked to the five common assessment criteria overleaf. 1. Research-informed Literature Your work must be informed and supported by scholarly material that is relevant to and focused on the task(s) set. You should provide evidence that you have accessed a wide range of sources, which may be academic, governmental and industrial; these sources may include academic journal articles, textbooks, current news articles, organisational documents, and websites. You should consider the credibility of your sources; academic journals are normally highly credible sources while websites require careful consideration/selection and should be used sparingly. Any sources you use should be current and up-to-date, typically published within the last five years or so, though seminal works in the field may be older. You must provide evidence of your research/own reading throughout your work, using in-text citations in the main body of your work and a reference list that is alphabetical at the end of your work. Please use the Harvard referencing system. Specific to Assignment 1: You need to have a minimum of 5 academic sources, correctly referenced in Harvard style. Specific to Assignment 2: You need to have a minimum of 10 academic sources, correctly referenced in Harvard style. 2. Knowledge and Understanding of Subject Your work must demonstrate the growing extent of your knowledge and understanding of concepts and underlying principles associated with the subject area. Knowledge relates to the facts, information and skills you have acquired through your learning. You demonstrate your understanding by interpreting the meaning of the facts and information (knowledge). This means that you need to select and include in your work the concepts, techniques, models, theories, etc. appropriate to the task(s) set. You should be able to explain the theories, concepts, etc. meaningfully to show your understanding. Your mark/grade will also depend upon the extent to which you demonstrate your knowledge and understanding; ideally each should be complete and detailed, with comprehensive coverage. 3. Analysis Your work must contain evidence of logical, analytical thinking, evaluation and synthesis. For example, to examine and break information down into parts, make inferences, compile, compare and contrast information. This means not just describing What! but also justifying: Why? How? When? Who? Where? At all times, you must provide justification for your arguments and judgements. Evidence that you have reflected upon the ideas of others within the subject area is crucial to you providing a reasoned and informed debate within your work. Furthermore, you should provide evidence that you are able to make sound judgements and convincing arguments using data and concepts. Sound, valid conclusions are necessary and must be derived from the content of your work. There should be no new information presented within your conclusion. Where relevant, alternative solutions and recommendations may be proposed. 4. Practical Application and Deployment You should be able to demonstrate how the subject-related concepts and ideas relate to real world situations or a particular context. How do they work in practice? You will deploy models, methods, techniques, and/or theories, in that context, to assess current situations, perhaps to formulate plans or solutions to solve problems, some of which may be innovative and creative. This is likely to involve, for instance, the use of real world examples and cases, the application of a model within an organisation and/or benchmarking one organisation against others based on stated criteria. You should show awareness of the limitations of concepts and theories when applied in particular contexts. 5. Skills for Professional Practice Your work must provide evidence of the attributes expected in professional practice. This includes demonstrating your individual initiative and/or collaborative working. You must communicate effectively in a suitable format, which may be written and/or oral, for example, essay, management report, presentation. Work should be coherent and well-structured in presentation and organisation. Essential Resources: • Resources listed on the lecture schedule and on Moodle • The student handbook ASSIGNMENT 1: MARKING CRITERIA AND STUDENT FEEDBACK This section details the assessment criteria. The extent to which these are demonstrated by you determines your mark. The marks available for each criterion are shown. Lecturers will use the space provided to comment on the achievement of the task(s), including those areas in which you have performed well and areas that would benefit from development/improvement. Common Assessment Criteria Applied Marks available Marks awarded 1. Research-informed Literature Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions. 20 2. Knowledge and Understanding of Subject Extent of knowledge and understanding of concepts and underlying principles associated with the discipline. 25 3. Analysis Analysis, evaluation and synthesis; logic, argument and judgement; analytical reflection; organisation of ideas and evidence 25 4. Practical Application and Deployment Deployment of methods, materials, tools and techniques; application of concepts; formulation of innovative and creative solutions to solve problems. 20 5. Skills for Professional Practice Attributes in professional practice: individual and collaborative working; deployment of appropriate media; presentation and organisation. 10 Assignment Mark(Assessment marks are subject to ratification at the Exam Board. These comments and marks are to give feedback on module work and are for guidance only until they are confirmed. ) Late Submission Penalties (tick if appropriate) % Up to 4 weeks late 40% Max Over 4 weeks late 0% ASSIGNMENT 2: MARKING CRITERIA AND STUDENT FEEDBACK This section details the assessment criteria. The extent to which these are demonstrated by you determines your mark. The marks available for each criterion are shown. Lecturers will use the space provided to comment on the achievement of the task(s), including those areas in which you have performed well and areas that would benefit from development/improvement. Common Assessment Criteria Applied Marks available Marks awarded 1. Research-informed Literature Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions. 10 2. Knowledge and Understanding of Subject Extent of knowledge and understanding of concepts and underlying principles associated with the discipline. 20 3. Analysis Analysis, evaluation and synthesis; logic, argument and judgement; analytical reflection; organisation of ideas and evidence 25 4. Practical Application and Deployment Deployment of methods, materials, tools and techniques; application of concepts; formulation of innovative and creative solutions to solve problems. 30 5. Skills for Professional Practice Attributes in professional practice: individual and collaborative working; deployment of appropriate media; presentation and organisation. 15 Assignment Mark(Assessment marks are subject to ratification at the Exam Board. These comments and marks are to give feedback on module work and are for guidance only until they are confirmed. ) Late Submission Penalties (tick if appropriate) % Up to 4 weeks late 40% Max Over 4 weeks late 0% COMMON ASSESSMENT AND MARKING CRITERIA OUTRIGHT FAIL UNSATISFACTORY SATISFACTORY GOOD VERY GOOD EXCELLENT EXCEPTIONAL Assessment Criteria 0-29% 30-39%* 40-49% 50-59% 60-69% 70-79% 80-100% 1. Research-informed Literature Extent of research and/or own reading, selection of credible sources, application of appropriate referencing conventions Little or no evidence of reading. Views and findings unsupported and non-authoritative. Referencing conventions largely ignored. Poor evidence of reading and/or of reliance on inappropriate sources, and/or indiscriminate use of sources. Referencing conventions used inconsistently. References to a limited range of mostly relevant sources. Some omissions and minor errors. Referencing conventions evident though not always applied consistently. Inclusion of a range of research-informed literature, including sources retrieved independently. Referencing conventions mostly consistently applied. Inclusion of a wide range of research-informed literature, including sources retrieved independently. Selection of relevant and credible sources. Very good use of referencing conventions, consistently applied. A comprehensive range of research informed literature embedded in the work. Excellent selection of relevant and credible sources. High-level referencing skills, consistently applied. Outstanding knowledge of research-informed literature embedded in the work. Outstanding selection of relevant and credible sources. High-level referencing skills consistently and professionally applied. 2. Knowledge and Understanding of Subject Extent of knowledge and understanding of concepts and underlying principles associated with the discipline. Major gaps in knowledge and understanding of material at this level. Substantial inaccuracies. Gaps in knowledge, with only superficial understanding. Some significant inaccuracies. Evidence of basic knowledge and understanding of the relevant concepts and underlying principles. Knowledge is accurate with a good understanding of the field of study. Knowledge is extensive. Exhibits understanding of the breadth and depth of established views. Excellent knowledge and understanding of the main concepts and key theories. Clear awareness of challenges to established views and the limitations of the knowledge base. Highly detailed knowledge and understanding of the main theories/concepts, and a critical awareness of the ambiguities and limitations of knowledge. 3. Analysis Analysis, evaluation and synthesis; logic, argument and judgement; analytical reflection; organisation of ideas and evidence Unsubstantiated generalisations, made without use of any credible evidence. Lack of logic, leading to unsupportable/ missing conclusions. Lack of any attempt to analyse, synthesise or evaluate. Some evidence of analytical intellectual skills, but for the most part descriptive. Ideas/findings sometimes illogical and contradictory. Generalised statements made with scant evidence. Conclusions lack relevance. Evidence of some logical, analytical thinking and some attempts to synthesise, albeit with some weaknesses. Some evidence to support findings/ views, but evidence not consistently interpreted. Some relevant conclusions and recommendations, where relevant Evidence of some logical, analytical thinking and synthesis. Can analyse new and/or abstract data and situations without guidance. An emerging awareness of different stances and ability to use evidence to support the argument. Valid conclusions and recommendations, where relevant Sound, logical, analytical thinking; synthesis and evaluation. Ability to devise and sustain persuasive arguments, and to review the reliability, validity & significance of evidence. Ability to communicate ideas and evidence accurately and convincingly. Sound, convincing conclusions / recommendations. Thoroughly logical work, supported by evaluated evidence. High quality analysis, developed independently or through effective collaboration. Ability to investigate contradictory information and identify reasons for contradictions. Strong, persuasive, conclusions, justifiable recommendations. Exceptional work; judiciously selected and evaluated evidence. Very high quality analysis, developed independently or through effective collaboration. Ability to investigate contradictory information and identify reasons for contradictions. Highly persuasive conclusions 4. Practical Application and Deployment Effective deployment of appropriate methods, materials, tools and techniques; extent of skill demonstrated in the application of concepts to a variety of processes and/or contexts; formulation of innovative and creative solutions to solve problems. Limited or no use of methods, materials, tools and/or techniques. Little or no appreciation of the context of the application. Rudimentary application of methods, materials, tools and/or techniques but without consideration and competence. Flawed appreciation of the context of the application. An adequate awareness and mostly appropriate application of well established methods, materials, tools and/or techniques. Basic appreciation of the context of the application. A good and appropriate application of standard methods, materials, tools and/or techniques. Good appreciation of the context of the application, with some use of examples, where relevant. A very good application of a range of methods, materials, tools and/or techniques. Very good consideration of the context of the application, with perceptive use of examples, where relevant. Evidence of some innovation and creativity. An advanced application of a range of methods, materials, tools and/or techniques. The context of the application is well considered, with extensive use of relevant examples. Application and deployment extend beyond established conventions. Innovation and creativity evident throughout. Outstanding levels of application and deployment skills. Assimilation and development of cutting edge processes and techniques. 5. Skills for Professional Practice Demonstrates attributes expected in professional practice including: individual initiative and collaborative working; deployment of appropriate media to communicate (including written and oral); clarity and effectiveness in presentation and organisation. Communication media is inappropriate or misapplied. Little or no evidence of autonomy in the completion of tasks. Work is poorly structured and/or largely incoherent. Media is poorly designed and/or not suitable for the audience. Poor independent or collaborative initiative. Work lacks structure, organisation, and/or coherence Can communicate in a suitable format but with some room for improvement. Can work as part of a team, but with limited involvement in group activities. Work lacks coherence in places and could be better structured. Can communicate effectively in a suitable format, but may have minor errors. Can work effectively as part of a team, with clear contribution to group activities. Mostly coherent work and is in a suitable structure. Can communicate well, confidently and consistently in a suitable format. Can work very well as part of a team, with very good contribution to group activities. Work is coherent and fluent and is well structured and organised. Can communicate professionally and, confidently in a suitable format. Can work professionally within a team, showing leadership skills as appropriate, managing conflict and meeting obligations. Work is coherent, very fluent and is presented professionally. Can communicate with an exceptionally high level of professionalism. Can work exceptionally well and professionally within a team, showing advanced leadership skills. Work is exceptionally coherent, very fluent and is presented professionally. Student Self Evaluation Form Student name: Student P number: Programme: Year of programme Assignment Title: This section repeats in brief the common assessment criteria detailed on previous pages. The extent to which these are demonstrated by you determines your mark. Using these criteria, tick the box that best indicates the level of achievement you feel you have achieved with regard to each of Common Assessment Criteria Applied Level of Achievement REFER 3rd 2:2 2:1 1st 1st OUTRIGHT FAIL UNSATISFACTORY SATISFACTORY GOOD VERY GOOD EXCELLENT EXCEPTIONAL 1. Research-informed Literature 0-29% 30-39% 40-49% 50-59% 60-69% 70-79% 80-100%        2. Knowledge and Understanding of Subject 0-29% 30-39% 40-49% 50-59% 60-69% 70-79% 80-100%        3. Analysis 0-29% 30-39% 40-49% 50-59% 60-69% 70-79% 80-100%        4. Practical Application and Deployment 0-29% 30-39% 40-49% 50-59% 60-69% 70-79% 80-100%        5. Skills for Professional Practice 0-29% 30-39% 40-49% 50-59% 60-69% 70-79% 80-100%        PLEASE COMMENT ON AREAS IN WHICH YOU FEEL THAT YOU HAVE PERFORMED WELL PLEASE COMMENT ON AREAS YOU FEEL THAT YOU NEED TO DEVELOP Student’s Name Date Student’s Signature