Data Warehousing role on Information Systems - Interim Project Report

XXXX XXXX UNIVERSITY – COLLEGE OF INFORMATION TECHNOLOGY

CAPSTONE PROJECT PLAN Supervisor: XXX Unit Coordinator: XXX

TOPIC - DATA WAREHOUSING: WHAT ROLE DOES IT PLAY ON INFORMATION SYSTEMS?

Page 1 of 7

IT Project Outline: 2021, Semester 2

Project Name: Data Warehousing: What role does it play on Information Systems?

Contact Details: XXXX

XXXX

Duration: 1 semester

Assumed knowledge:

Business Intelligence and Data Mining

Enterprise IT Management

Project Management

Database Concepts

Supervisor: XXXX

Project Details

Description

• Provide an outline for the context of the project.

Data warehousing is extensively used in business intelligence which is a part of information systems.

The content of this project will discuss data warehousing, the importance of it in information systems,

specifically when it comes to business intelligence. The project will focus on what data warehousing

is, what family does it belong to, issues and importance of data warehousing by giving examples and

why they are preferred more in comparison to databases these days. The reasons why data

warehousing are created will be very important in this project. The project will discuss by giving

examples of companies where data warehousing are used, focusing on their reasons and benefits.

Goals of the project

• What will the project accomplish?

• What are the objectives and are they measurable?

The project objectives are measurable due to improved business agility and performance outcomes.

Similarly, the objectives accommodate specific, measurable, achievable, relevant, and time-bound

criteria on a real-time and integrated platform to support information systems in business strategic IT

initiatives and, measurable on how big data problems are manageable via data warehousing on

information systems and business intelligence.

Page 2 of 7

Relationship to your IT Stream

• How does it relate to the stream you are specialising in?

• Will it require learning new skills?

• What are the major skills required for this project?

Our team members’ career goals are to become ICT Business Analyst. As we have already completed

Business Intelligence and Data Mining, Enterprise IT Management, Project Management & Database

Concepts. Therefore, to successfully complete this project, will not require learning any new skills for

us apart from the guidance from our supervisor.

Project Deliverables

• What are the projects deliverables?

• What values and benefits of this project?

• What is its relevance to your work context?

• What is its relevance to you?

• What will you gain by completing this project?

The project's main objective is to find out the role of data warehousing on information systems,

accommodating business intelligence. Significantly, information technology advancement is geared

towards improved applications in business organizations to support efficiency, agility, profitability,

and continuation at a cost-effective platform. Similarly, the project identifies technologies such as data

warehousing projects in information technology systems, resonating with fundamental IT projects in

improving business performance efficiently and cost-effectively.

At a personal level, the project provides fundamental relevance with our ambition and need to apply

information technologies to improve business in a real-world situation, accommodating business

intelligence concepts. Similarly, accommodating detailed literature in data warehousing would

improve our knowledge and understanding of data warehousing on information systems and business

intelligence. Thus, the project accommodates general and personal relevance towards improved

performance in business enterprises.

Project Scope

• How broad is the project?

• What are the potential challenges and complications?

• How feasible is it?

• Will it require one or two semesters?

• Is it related to current or past studies?

The project will require one semester. Notably, the project is limited to finding out the role of data

warehousing on information systems, accommodating business intelligence, and improvement of

business agility. The project accommodates concepts of business intelligence and data warehousing

on how information systems are achievable. However, there are notable limitations, including the

Page 3 of 7

need to evaluate how emergent technologies, accommodating real-time and integrated data

warehousing impacts the future of DW and applications in basslines intelligence. Noteworthy,

accommodating data mining, data warehouse, and business intelligence in information system the

project is feasible because there is a fundamental framework to achieve project objectives and goals.

Therefore, the project will operate within the praxis of data warehousing concepts to improve

business intelligence as an IT strategy in a business organization.

Table of Contents:

PROJECT DEFINATION & SCOPE .............................................................................................................. 3

Introduction: ....................................................................................................................................... 3

Background/description of context/need/benefits: ........................................................................... 4

Aims & Objectives: .............................................................................................................................. 4

Scope: .................................................................................................................................................. 4

PROJECT ACTIVITIES, DELIVERABLES & RISK ........................................................................................... 5

Project timeline, deliverables: ............................................................................................................ 5

Risk: ..................................................................................................................................................... 5

RESOURCES ............................................................................................................................................. 6

Materials & Budget: ............................................................................................................................ 6

Appendix: ............................................................................................................................................ 6

PROJECT DEFINATION & SCOPE

Introduction: 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.

Page 4 of 7

Background/description of context/need/benefits: 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.

Aims & Objectives: • 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.

Scope: 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

Page 5 of 7

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.

PROJECT ACTIVITIES, DELIVERABLES & RISK

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

project successfully :

Risk: 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.

Week Team Tasks - XXXX, XXXX Time Required Deliverables

1 Project Topic Research & EOI. 2 days Expression of Interest

2 Understanding the tasks according to supervisor’s guideline. 1st Meeting with supervisor for project plan.

4 days Event 1

3 Research on the topic using resources. Team & Supervisor meetings.

4 days Event 2 Project plan submission

4 Processing information for analysis. Team & Supervisor meetings.

3 days Project diary

5 Interim draft report finalise. Team & Supervisor meetings.

5 days Event 3

6 Research and implementation. 3 days Draft report submission

7 Project methodologies. Team & Supervisor meetings.

2 days Template final report

8 Project evaluation and discussion. Team & Supervisor meetings.

4 days Event 4

9 Research on IT-specific presentations. Team & Supervisor meetings.

4 days Event 5

10 Project output analysis. Team & Supervisor meetings.

5 days Event 6

11 Content presentation preparation. Team & Supervisor meetings.

5 days Event 7

12 Briefing for final report. Team & Supervisor meetings.

5 days Event 8

13 Final submission – Project completed 6 days Final Report submission & Presentation

Page 6 of 7

RESOURCES

Materials & Budget: 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.

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

Project Formatting Guidelines Checklist

Format issue Details Checked

Format All assessment tasks (except the journal) should be submitted as a Word document

All documentation should be a single word-processed document unless special circumstances are required.

Project Title A title of not more than 16 words should be provided.

Title Page A Title Page should be submitted with each individual project submission. Title page should have the following information:

• Assignment Title

• Author Details

• Abstract (Lit Review and the final Report)

• Keywords (Lit Review and the final Report)

Author Details Details should be supplied on the Title Page including: • Full name of the author

• E-mail address of the author

Abstract • A structured abstract should be included on the Title Page,

Abstract should address the following:

• Motivation or Problem Statement

• Objective of the project

• Methodology/Approach

• Results/Findings

• Implications

• Limitation Please note -the list is suggestive and not mandatory

• Maximum 250 words in total (including keywords).

Keywords • Provide no more than 5 keywords on the Title Page,

• Keywords should encapsulate the principal topics of your project

Project Topic • Include the original project topic outline that you chose for your

project

• This should be the second page of your document.

Headings • Headings must be 7 words or less • There should be a clear indication of the distinction between the

hierarchies of headings.

• Headings should have a numbering system that matches the heading levels.

• First level headings to be presented in bold format 18 pt. • Subsequent sub-headings to be presented in medium italics 14 pt. • Further headings (level 3) should be bold 12pt • Writing should be presented in clear, concise English.

Page 7 of 7

Presentation • Fonts should be Calibri or Helvetica, 11-point font • Spacing should be double or 1.5-line spacing throughout • Margins: use standard margins • Page numbers: All pages of your documents must be numbered

consecutively, including appendices and references

• Page numbers should appear in a footer on the right of each page.

Notes/Endnotes • No notes or endnotes

Table of Contents • Table of Contents should be automatically generated based on your Word headings.

Figures • All Figures (charts, diagrams, line drawings, web

pages/screenshots, and photographic images) should be included in the body of your documents.

• Ensure that all images are of reasonable quality and easily understood

• All figures should be labelled appropriately and referred to in the body of the document.

Tables • Tables should be included in the main body of the article.

• All Tables should be labelled appropriately and referred to in the

body of the document.

• Ensure that any superscripts or asterisks are shown next to the relevant items

References • References to all publications must be in Harvard style and

carefully checked for completeness, accuracy, and consistency.

• In-text citations : Cite publications in the text: • Citing one author- use the first named author's name and date

(Adams, 2006) Make sure you use the family name

• Citing two authors, (Adams and Brown, 2006) • Citing three or more authors (Adams et al., 2006). • Reference list should be at the end of each project document

before any appendices

• Reference list should be in alphabetical order