Impact of Data Warehousing and OLAP Models on Management Accounting Dissertation

Impact of Data Warehousing and OLAP Models on Management Accounting - Dissertation Example The questions were categorised into seven sections that cover the aspects of familiarity of the organisation with these tools, historical data for planning the implementation, changes and compatibility of people in various departments, contribution of OLAP to management accountant and other departments. The data collected were analysed in Excel and by SWOT analyses. The strengths, weaknesses, opportunities and threats in implementing OLAP and data warehouses for the organisation and the management accountant have been analysed. It has been identified that the strengths are more and the threats are less. Hence the impact of the OLAP and data warehouses on management accountant is positive and their overall benefits it that the data analysis and reporting is easy and efficient. Table of Contents Chapter 1 - Introduction 1.1. Research scenario 1.2. Identification of research problem 1.3. Main research question and Assumptions 1.4. Aim and Objectives of the Research 1.5. Methodology of r esearch 1.6. Structure of the research Chapter 2 – Literature Review 2.1. The Traditional Accountant 2.2. Challenges faced by The Traditional Accountant 2.3. Transition of role 2.4. The Data Marts 2.5. Introduction to OLAP 2.6. OLAP models 2.6.1. Data analysis in OLAP 2.6.2. OLAP components 2.7. The role of OLAP 2.8. Mapping the BI 2.9. Database Design 2.10. Warehouse Management 2.11. Challenges and implications of BI tools Chapter 3 - Methodology of Research 3.1. Research Methodologies 3.2. Qualitative survey method 3.3. Data collecting instrument 3.4. Sample space and sample size 3.5. Validity, Originality and Limitation of the research Chapter 4 – Data Presentation and Analysis 4.1. Qualitative Data representation 4.1.1. Section I Questions – Data Representation 4.1.2. Section II Questions – Data Representation 4.2. Preliminary data analysis in EXCEL 4.2.1. Analysis of section I questions 4.2.2. Analysis of section II questions 4.2.3. Analysis of secti on III questions 4.2.4. Analysis of section IV questions 4.2.5. Analysis of section V questions 4.2.6. Analysis of section VI questions 4.2.7. Analysis of section VII questions 4.3. SWOT analysis method 4.4. SWOT analysis of research data Chapter 5 – Research Recommendations 5.1. Strengths 5.2. Weaknesses 5.3. Opportunities 5.4. Threats 5.5. Research Recommendations Chapter 6 – Research Conclusion References Appendices Appendix A – Questionnaire Appendix B – Data Collected from First Participant Appendix C – Data Collected from Second Participant List of Figures Fig.2.1. The cube architecture of OLAP system. Fig.2.2. Database segregation in Business Intelligence using OLAP. Fig.4.1. Analysis of first question in section I. Fig.4.2. Analysis of second question in section I. Fig.4.3. Analysis of third question in section I. Fig.4.3. Analysis of third question in section I. Fig.4.5. Analysis of fifth question in section I. Fig.4.6. Analysis of sixth q uestion in section I. Fig.4.7. Analysis of seventh question in section I. Fig.4.8. Analysis of eighth question in section I. Fig.4.9. Analysis of first question in section II. Fig.4.10. Analysis of second question in section II Fig.4.11. Analysis of third question in section II Fig.4.12. Analysis of fourth question in section II Fig.4.13. Analysis of fifth question in section II. Fig.4.14. Analysis of sixt