Capstone Project Report on Data Warehousing role on Information Systems ‘ Inbox

Access database project- Urgent
January 31, 2023
Equifax in data collection
January 31, 2023

Capstone Project Report on Data Warehousing role on Information Systems ‘ Inbox

Table of Contents:Table of Contents: 1Abstract: 3• Objective of the project: 4• Implications and limitation. 5Project Topic outline: 7Lists of Symbols: 7Body: 81. Introduction including any relevant background information. 8Scope: 92. A description of the aim of the project. 103. Background research/literature review/requirements analysis. 114. Literature Review.. 12Data Warehousing Definition. 12Example of Data Warehousing. 14Relevance of Data Warehouse. 14Data Warehousing: Process 16Data Warehouse: Architecture. 175. A description of the methods/approach used to implement your project  176. Results /Implementation, discuss the outcomes of the method used. 197. Analysis and discussion of the project outcomes. 208. Conclusions:  219. Recommendations: 22Execution & Results or Analysis & Discussion: 22Implications & Limitations: 24Lessons Learned: 25o Meaningfully synthesize connections among experiences from the project (including life experiences and academic experiences) to deepen understanding of fields of study and to broaden own points of view. 25o Did the project meet scope, time, and cost goals?. 26o Were the IT practices used in your project conducted ethically (use the ACS Code of Ethics to respond) 26o Regarding managing the project, what were the main lessons you learned?. 27o Describe one example of what went right on this project. 27o Describe one example of what went wrong on this project. 28o Outline what will you do differently on the next project based on your experience working on this project? 28References: 28Appendices: 341. Detailed theoretical analyses. 342. Tabulated records of results, with reference to instruments or sources as appropriate. 35Abstract:• Summary: Write a summary of the reportOne of the major advancements involved in information systems is defined as being data warehousing. The key aim regarding this research is to offer a comprehensive as well as systematic research data to elaborate on the key roles regarding data warehouse in the concept of information systems. The information offered in this research paper is on the manner in which data Warehouses can alter an organization as well as the meaning of data warehouse and even information systems with the use of peer reviewed resources on writing and in the presentation of the data. There is an elaboration on the concept of business intelligence which is a famous concept associated with data Warehousing.The current era is one which is filled with numerous developments especially in the concept of information technology. Data Warehousing has become a common household name in most of the firms that are dealing with IT as well as data analytics. Large corporations are now dealing with high amounts of data which has forced them to look for alternatives on storage and management of data for safety purposes. Business intelligence has helped in the management of data in organizations (Ariyachandra and Watson, 2010). This has been a good way of helping these organizations to attain efficiency and feasibility in the data management. The following research final paper focuses on understanding the concept of data warehouse by elaborating on the key features associated with data warehousing and the role it plays in information systems with a key focus on business intelligence.• Purpose/Motivation or Problem Statement: research questions, relevance & context of the projectData warehousing is considered to be extensively utilized in information technology systems as well as business intelligence which is also a key part regarding information systems. The content regarding this project is to discuss the concept of data warehousing as well as its significance on information systems with a key focus on business intelligence.• Objective of the project:The identified project objectives are considered to be measurable because of the enhanced business agility as well as performance outcomes. The objectives in this research paper accommodate specific as well as measurable, achievable and time bound aspects on the actual time along with the integrated Platform with a key aim of offering support to the information systems in the identified business strategic IT initiatives as well as measurable on the manner in which big data issues are easily manageable through the concept of data warehousing on information systems as well as business intelligence. The following are key objectives associated with the project:· Supporting decision making within the given information system as well as the business intelligence platforms. Data warehousing as well as information systems are usually utilized collaboratively to help in the creation of specific insights into the given business operations and this offers robust arguments in supporting business decisions (Köksal and Ticonderoga, 2019).· The accomplishment of the identification regarding the contribution to the identified data warehousing in the concept of information systems accommodating the business intelligence as well as in the improvement of business agility.· Management of the highlighting of the manner in which the modern data warehousing contribution has effectively accommodated basic and essential features like real time as well as integrated platforms to help in the supporting of the information system in the identified business strategic IT kind of initiatives.· Achievement of the illustration of the manner in which data warehousing as a key process for the electronic data collection as well as accommodating the trove historical information for the key analysis as well as decision making in the given big data era happens to help in the management of essential data in the company operation systems (Reddy & Suneetha, 2021).• Design/Methodology/Approach: Explain the methods used for the data collection in your project (this includes literature; and other analyses your project requires)Design Methodology is associated with stressing the utility of brainstorming to help in the encouragement of innovative ideas as well as collaborative thinking to work via each of the proposed idea as well as in arriving at the most appropriate solution. The following project uses external sources, specifically the secondary data sources that is literature reviews and other published sources to attain the information which is needed in the achievement of the project objectives (Yao & Chakraborti,2021).• Results/Findings: Briefly outline the results of your systematic search; the consistent themes, any gaps if appropriate (one or two sentences).In the current years, the identified database community has been associated with witnessing the emergence regarding a current form of technology which is called data warehousing. With the many and key developments in information systems and in data management, data warehousing is a key emerging concept that needs to be understood comprehensively so as to understand the benefits and the future of data warehousing in not only the large corporations but also in the small businesses.• Implications and limitation.The project is highly vital in enhancing the knowledge and skills of students in this field and other related fields. Nonetheless, it will also help in offering information along with knowledge needed by firms to understand how data warehousing operates and the benefits it brings about to the information systems of such companies and businesses. Notably, the identified project is one which is Limited to seeking the key role regarding the concept of data warehousing on the information systems as well as in the accommodation of the business intelligence concept and enhancement of the aspect of business agility.  This project is highly feasible in the accommodation of the key concepts regarding business intelligence as well as data warehousing on the manner in which information systems are usually attainable. However, it is vital to note the notable and evident limitations that are present in the given project (Voronkova et al., 2017).First and foremost, there is the key need to effectively evaluate the manner in which emergency technologies, accommodation of the actual time as well as integrated data warehousing has an impact on the future regarding data warehousing as well as applications in information systems and business intelligence. Accommodation of data mining as well as data warehousing and even business intelligence in the identified information system the given project is considered to be highly feasible due to the fact that there is a basic kind of framework to attain project goals. Therefore, it is vital to note that the given project will effectively operate within the given praxis regarding data warehousing concepts to enhance business intelligence as a key IY strategy in firms.• Conclusion of abstract: final assessment of the overall evidence and how it helped you to finish this project (one or two sentences).A data warehouse is considered as being a global repository which is associated with the storage of the pre processed kind of queries on data which is associated with residing in a variety, probably heterogeneous as well as operational or even legacy kinds of sources. The identified information that is usually stored on the given data warehouse can be efficiently as well as easily accessed for enhanced decision making. The current research has been associated with causing current forms of developments in all the given aspects associated with data warehousing, however it is vital to note that there are numerous kinds of issues which need to be handled in the most appropriate manner for enhancing the efficiency of data warehousing. In the following research, there is a discussion of data warehousing as a concept in in depth for increased knowledge and understanding of the concept and the key role it plays in information systems (Ariyachandra and Watson, 2010).Project Topic outline:Include the original project topic outline that you chose for your project. This is helpful for the second marking understanding what your project is about. Prepare a final report that concisely details the work completed during your project. (Use your project plan)Data warehousing is highly utilized in the concept of business intelligence which is identified as being a part of the information systems. The identified content regarding this project will help in the discussion of the data warehousing concept as well as the key concepts associated with it and the key significance of data warehousing in relation to information systems with a key focus on business intelligence. The given project will highly focus on what data warehousing as a concept it is as well as the issues and the significance associated with data warehousing and the kind of industries that have benefited from the use of data warehousing in the information systems. The key reasons as to why data warehousing are usually created is very vital to understand in this project. The project will highly elaborate on the examples of industries that are using data warehousing with a key focus on the key reasons as well as the benefits on the same (Raza et al., 2020).Lists of Symbols:Your final report mush includes – Tables; Figures; Abbreviations; Charts; Graphs, Pie Charts.Figure 1Data WarehouseFigure 2Data Warehouse ArchitectureFigure 3Characteristic of Data WarehouseFigure 4Analysis of Data WarehouseSymbolsMeaningITInformation TechnologyACS codeAustralian Computer Society Code of EthicsBody:The actual report consists of sections arranged to suit the individual needs of each project, and should include the following:1. Introduction including any relevant background information.Write an exceptional introduction that grabs interest of reader and states topic clearly. Write an excellent description of research question, problem (including statement of purpose and relevance). The scope should include context, boundaries and assumptions.The concept of technology is one that is associated with being a leading factor in the world and thus the management of data efficiently along with effectively plays a key role in any company’s activities. Most of the IT departments in companies utilized excel function for the key budgeting strategy but that is associated with coming with numerous issues such as the issue of flexibility and complexities in the preparation of the budget strategy, issues in the identified consolidation regarding the specified budget and in most of the cases the deployment of the budget associated plans. The current era is one that is highly technological and this has added another layer of complexities in the IT industries and the related industries who rely on IT activities and processes.To effectively solve these issues, it is important to note that data warehousing is associated with playing a key role in any information systems sector for any firm. Such as centralized kind of data warehouse ought to be highly capable in the management of all the financial expenses, whether this is planned earlier in time or it came about unplanned and promptly. In the key aim and attempt to facilitate the evaluation of the manner in which the strategic business IT kind of initiatives like the data warehouse as well as support on the information systems within a given business organization, it is vital to note that there is an essential need for the accommodation of data warehouse as a form of a data repository as well as data warehousing as an entire kind of process which is associated with the facilitating of the use of data gathering formed to offer support to decision making within the given business intelligence kinds of platforms.Scope:Data warehousing is considered as being the vast collection regarding business data, which is associated with helping firms in the making of effective along with efficient business decision. To help in the revelation of business intelligence an appropriate decision making support kind of system is needed which is essential in facilitating the transition of data. The identified concept regarding data warehousing is one which was effectively introduced in the year 1980. Data usually comes from distinct kinds of sources which usually range from the internal applications well as the external applications. Data from the distinct kinds of sources is one that is usually extracted in the effective format as well as is then effectively imported to an effective kind of format which is regraded as being highly supportive in regard to the increment of business intelligence.There is an identified scope as well as are substantial benefits and advantages that are usually added to the given data warehouse which is associated with helping to make effective and highly efficient presentation regarding data. To attain highly essential data from the distinct sources, it is vital to note that there is the need to utilize analytical kinds of tools as well as data warehousing helps in the storage of data with effective quality as well as integrity. The faster decision is associated with helping to attain higher level of productivity as well as increment in revenue which is considered to be probable with the utility of the concept of data warehousing.2. A description of the aim of the project.The key aim of the project is finding out the key role regarding data warehousing on the concept of information systems as well as the accommodation of business intelligence. Essentially, information technology developments is usually associated with being geared towards enhanced applications in the business organizations to help in offering higher level of efficiency and effectiveness as well as agility in the business process, higher level of profitability and even continuation at a cost efficient kind of Platform. In the same manner, the given project usually is associated with the identification of the technologies like data warehousing kinds of projects in information technology kinds of systems as well as resonating with the basic IY projects on the enhancement of business performance effectively as well as cost efficiently.At the personal level, the given project is essential in offering the basic and essential relevance with the ambition as well as the key need to effectively apply information technologies to help in the improvement of the businesses in the actual world situation as well as in the accommodation of the business intelligence concepts. Moreover, accommodation of a detailed along with a comprehensive literature in the concept of data warehousing would help in enhancing human knowledge as well as comprehensive understanding regarding data warehousing on the information systems as well as business intelligence. Therefore, the given project is highly vital in the accommodation of general as well as personal relevance towards enhanced performance on the business enterprises.3. Background research/literature review/requirements analysis. This should be based on the work you completed in the interim report and the heading used needs to reflect the project type undertaken.Management of big data as well as information within the given business organization is associated with having proven to be an issue as well as a key challenge with the increment as well as the development on the information technology adaptation by the given business firms, unavailing the key need for an identified business strategy as well as IT initiative to help in the solving of such kind of issues. In an aim to help in the finding of the most appropriate solutions to such kinds of issues within the business organization, the key objective regarding this given project is considered to be seeking the key roles regarding data warehousing on the information systems as well as in the accommodation of the business Intelligence concept.In this given project, there is the laid out plan to operate on researching on the issues as well as significance regarding data warehousing, from the research on what data warehousing is, through offering relevant examples associated with data warehousing as well as to the key reasons as to why they are used , to the key reasons as why organizations and businesses do not depend on databases and why they use  warehousing for assistance. Through the effective completion of this project, it will help on offering knowledge as well as understanding needed in offering in depth as well as comprehensive research on the key roles regarding data warehousing on the concept of information systems.4. Literature Review.Choose a variety of information sources appropriate to the scope and discipline of the research question. Select sources after considering the importance (to the researched topic) of all criteria used (such as relevance to the research question, currency, authority, audience, and bias or point of view). Synthesize in-depth information from relevant sources representing various points of view/approaches.Data Warehousing DefinitionData warehouse is Considered as being a repository regarding enterprise or even the business databases which offers a comprehensive picture regarding the current as well as the historical operations associated with a firm. Since it is associated with offering a coherent as well as a comprehensive kind of picture associated with the business conditions at a specific time, it is usually utilized for the effective as well as efficient decision making kind of process. It is associated with entailing the advancement of systems which usually assists in the extraction regarding the given data in a manner that is highly flexible. Data mining is associated with the description of the process associated with the designing of the manner in which the given data which is usually stored so as to help in the improvement of the reporting as well as the analysis process.Data warehousing professionals are associated with putting into consideration that the various kinds of stores regarding data are usually linked as well as associated to one another conceptually and even physically. The data of any business is often considered to be stored across a variety of databases. However, it is essential to note that to be highly capable to analyse the widest range regarding data, each of the given databases is associated with being linked in some manner. This is used to mean that the given data which is within them requires a key way of being associated to other essential data as well as that the identified physical databases themselves usually have a link so their given data can be looked at collaboratively for the purpose of reporting (De Mul et al., 2012).Fig 1: Data WarehouseIt is essential to note that a variety of the data stores are usually integrated by the identified Data Warehouses as well as this information is often utilized but the key leaders as well as managers for enhancing improved decision making. Data warehousing kinds of environments is associated with the inclusion of extraction regarding the regional databases that is the Transformation as well as Loading and the Online Analytical Processing. As any business grows and expands globally, the identified parameters as well as the complexities entailed in the analysis process as well as decision making usually become highly complex (Özcan & Peker, 2021).Data access portion which is considered to be available in the key form regarding products is Considered as being the most visible part regarding a data warehouse project. Data Warehousing process is associated with the transformation regarding data from the original format to the dimensional data store which is associated with the consumption of a higher level percentage regarding effort as well as time and even expenses. Since the identified implementation regarding the data Warehousing is considered as being costly as well as essential, there are numerous data extraction as well as data cleaning tools and even load and fresh utilities that are usually available for the same. It is vital to understand that one of the most essential features regarding the data warehouse is data integration.Example of Data WarehousingFacebook is considered as being a great example of data Warehousing since it is associated with doing that on its daily operations. Facebook is a famous social media Company which is associated with the gathering of AI data like friends as well as likes and groups among others. All these kind of data that is gathered by the company are usually stored into a single kind of central repository. Although the company of Facebook is involved in the storage of all these kind of information into separate forms of databases, usually they store the most essential as well as vital information into a single central aggregated kind of databases. This is due to numerous reasons such as making sure that individuals perceive the most essential ads which are highly likely to click on or even friends that they suggest are usually the most vital to an individual (Drake, 2021).Relevance of Data WarehouseData warehouse is considered to be a subject oriented as well as time variant, integrated and even non volatile gathering of data. Data cleansing as well as data integration and even Online Analytical Processing are all considered as being part of the data Warehousing technology. It is associated with offering a whole as well as consistent data store from the numerous sources which can be effectively understood as well as utilized in the business applications. Some of the given application areas entail the integration of the data across the entire firm as well as quick and efficient decisions on the current and even historical data, management and the control of Businesses among others (Liu et al., 2021).Data Warehousing is considered to be an highly essential business intelligence tool which allows firms to be efficient and feasible in different ways. First and foremost it is associated with facilitating high level consistency. Data Warehouses are usually effectively programmed to effectively apply a uniform format to all the gathered data. This is associated with making it easier for the corporate decision makers to efficiently as well as effectively analyse as well as share the data insights with their given colleagues globally. The standardizing of data from the distinct sources is also associated with the reduction of the risk regarding error in the interpretation as well as in the enhancement of overall accuracy (Neamah, 2021).Moreover, it is associated with enhancing the business decisions. The successful business leaders usually are involved in the development of the data driven technique as well as rarely come up with decisions without in any way consulting the given facts. Data Warehousing is associated with the improvement of the speed as well as the efficiency regarding the accessing of the distinct kinds of data sets as well as it makes it easier and more efficient for the corporate decision makers to derive effective insights that will help in guiding the identified business as well as the marketing techniques that usually are involved in setting them apart from their identified competitors.Nonetheless, it is associated with improvement of their identified bottom line. The data warehouse kind of platform usually allow the business leaders to efficiently as well as effectively access their historical Activities of the firm. It also helps in the evaluation of the initiatives which have been highly efficient or even not efficient in the previous times. This is associated with allowing the executives and the leaders to perceive where they can effectively adjust their identified strategy to facilitate the decrement of costs along with the maximizing of the level of efficiency and in the increment of sales to help in the improvement of their identified bottom line (Friedrichs, 2021).Data Warehousing is also associated with the delivery of improved business intelligence. Through having effective access to information from a variety of sources from a single kind of platform, decision makers will no longer be required to be dependent on the limited data or even their instincts. Moreover, it is vital to note that the data warehouse can effortlessly and effectively be applied to any kind of business process such as the market segmentation as well as IT management and so forth. It also helps in saving time (Gladić & Petrovački, 2021).  A data warehouse is associated with the standardizing as well as the preservation and even the storage of data from the distinct sources, helping in the identified consolidation and even in the integration regarding all the given data. Since the critical data is considered to be available to the users, it is associated with allowing them to come up with highly informed decisions on the key aspects (Sylvestre et al., 2018).It is also associated with improving data quality along with consistency. A data warehouse is associated with the conversion of data from numerous sources into a consistent kind of format. Since the given data from across the entire organization is considered to be standardized, each kind of department will be involved in the production of outcomes which are consistent. This is associated with causing more accuracy of data which will help in decision making. Furthermore, it is associated with the streamlining of the flow regarding information via a network that connects all the related as well as the non related parties (Chang et al., 2021).Data Warehousing: ProcessData warehousing is defined as being the key process regarding the centralizing or even the aggregation of data from Numerous sources into a single common kind of repository. Data warehousing is associated with taking place prior to data mining taking place. Data warehousing is associated with involving a strict engineering kind of phase whereby no any form of business users are entailed. In the data warehousing, data stored in the distinct databases are usually combined into a single comprehensive as well as efficiently understood and accessible database. This is usually considered to be available to the business professionals or even the managers who are associated with the utility of the data for the purpose of data mining and in the creation of forecasts. Data is usually fed from numerous disparate sources into the given data warehouse which is usually again converted as well as reformatted, summarised and utilized for the managerial decision making purposes (Arora & Gosain, 2021).Data Warehouse: ArchitectureData warehouse architecture is usually on the basis of a variety of Business processes related with any business. Some other kinds of considerations while going for the identified architecture associated with a data warehouse entails data modelling as well as enough security, metadata management, extent regarding query requirements and the use of full technology. Metadata is considered as being the type of data which is usually stored either as a form of unstructured or even in the semi structured manner (Alkraiji, 2021). These kind of summary data are usually highly essential in the given data warehouse. For instance, simple kinds of data warehouse query can be utilized in the retrieval of the sales made in the month of January. Data Warehousing type of architecture can be revealed with the given materialized view in the famous Oracle 9i as depicted below.Fig 2: Data Warehouse Architecture5. A description of the methods/approach used to implement your project (including justification of the choices made where appropriate). All elements of the methodology or theoretical framework should be skilfully developed. Appropriate methodology or theoretical frameworks may be synthesised from across disciplines or from relevant sub disciplines.Methods as well as approaches used in the implementation of a project are key to any project and need to be understood in the best way possible for enhanced efficiency and effectiveness. The following project used external sources and to be precise the secondary data sources. When the data is usually gathered from outside an organization, it is usually referred to as external sources of data. Secondary data is used to define the second hand information. It is usually considered to be not originally gathered as well as it is instead attained from the already published or even the unpublished sources. The following project used published Secondary data for enhanced efficiency as well as feasibility of the information offered. There was the use of numerous published sources inclusive of journals as well as the periodicals that are published by various kinds of governments globally (Hemler et al., 2021).There are numerous precautions which were undertaken in the use of the secondary data to ensure efficiency in the whole research process. First and foremost, there was the confirmation on the reliability of the agency to help in having reliable published data. Moreover there was the suitability regarding the given aim associated with enquiry whereby there was the investigation of the data prior to its use to ensure that the given data is highly suitable for the key aim regarding the present enquiry and this was done via the investigation of the nature along with objectives and even time regarding the collection (Hasselbring, 2000).There was the consideration of the adequacy as well as the accuracy levels to avoid impact regarding bias. It is vital to utilize adequate data to avoid any kind of biased as well as prejudices causing inappropriate conclusions (Baran, 2021). There is also the method regrading the collection of the data utilized. For this consideration, there was the ascertaining as to the kind of method to use in the collection of the data for enhanced efficiency and feasibility. In overall this helped in attaining updated and feasible data for use in the whole process (Seneviratne et al., 2018).6. Results /Implementation, discuss the outcomes of the method used. For this project report, it is expected that some tabular data that shows the results of your project activities/methodological approach will be included.Figure 3: Characteristics of Data WarehouseData warehouse is Considered as being a repository regarding enterprise or even the business databases which offers a comprehensive picture regarding the current as well as the historical operations associated with a firm (Dahaoui et al., 2021). Since it is associated with offering a coherent as well as a comprehensive kind of picture associated with the business conditions at a specific time, it is usually utilized for the effective as well as efficient decision making kind of p

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.