6000 Words - Capstone Project Report on Data Warehousing role on Information Systems

Technology is leading the world and therefore managing data efficiently plays a big role in any organisation’s IT activities. Most organization’s IT departments used excel for budgeting strategy but that comes with lots of challenges, like flexibility in preparing budget strategy, difficulty in consolidation of the specified budget, and mostly deployment of budget plans.

To solve these problems, data warehousing plays an important role in any organization’s information systems sector. Such as centralized data warehouse should be able to manage all financial expenses, whether this it is planned earlier or came in place all sudden.

In an attempt to evaluate how strategic business IT initiatives such as data warehouse and support on information systems within a business organization, there is a significant need to accommodate data warehouse as a data repository and data warehousing as an entire process that facilitates utilization of data collection created to support decision-making within business intelligence platforms.

Managing big data and information within the business organizations has proven challenging with increased and advancement in information technology adaptation by business organizations, unavailing the need for a business strategy and IT initiative to solve such problems. In an attempt to solve such issues within a business organization, the objective of this project is to find out the roles of Data Warehousing on Information Systems, accommodating business intelligence.

In this project, we, as a team, plan to work on researching about the issues and importance of data warehousing, from researching what data warehousing is, by giving examples of data warehousing, to why are they used, to why don’t organisations rely on databases and why they have to come data warehousing for help, the extensive use of data warehousing in business intelligence, also the reason why data warehousing are created will be a focused on this project. By the completion of this project, we will be able to provide an in-depth research about the role of data warehousing on information systems.

· Support decision-making within business intelligence platforms. Data warehousing and business intelligence are used together to create specific insight into business operations, and this provides strong arguments in the support of business decisions.

· Accomplish identification of the contribution to data warehousing in information system accommodating business intelligence, and improvement of business agility.

· Manage highlighting how modern data warehousing contribution has accommodated fundamental characteristics such as a real-time and integrated platform to support information system in business strategic IT initiative.

· Achieve describing how data warehousing as a process for electronic data gathering, accommodating trove historical data for analysis and decision-making in the big data era to manage significant data in organization operation systems.

Data warehousing is the vast collection of business data, which helps make a business decision. To reveal business intelligence an effective decision support system is required which is helpful in the transition of data. The concept of data warehousing was introduced in 1980. Data comes from different sources which range from internal applications and external applications. Data from different sources is extracted in the appropriate format and is then imported to an appropriate format that is supportive of increasing business intelligence. There is a scope and are substantial benefits that help increase business analytics and several business benefits. Data sources should be added to the data warehouse which helps to make a better presentation of data. To obtain relevant data from different sources there is a need to use analytics tools and data warehousing helps to store data with appropriate quality and integrity. The faster decision helps to get more productivity and increased revenue and that is possible with the use of data warehousing.

Below is our project timeline and plan for next weeks which we have made as team to deliver this project successfully :

One of the risks is a lack of mission and objectives. To handle this risk, the objective should be first identified. Security and privacy issues in deploying data warehouse projects is high which can result to cyber security concerns if privacy mechanisms are not wisely chosen by developers.

Materials required would be access to peer reviewed journals, published articles and papers which is accessible freely for XXX students so, no cost is involved to complete this project.

Please see below Project Formatting Guidelines Checklist completed as per instructions.

Page 2 of 2