Project Deliverable 3: Database and Data Warehousing Design Project Deliverable 3: Database and Data Warehousing Design This deliverable is to be written t

Project Deliverable 3: Database and Data Warehousing Design Project Deliverable 3:
Database and Data Warehousing Design This
deliverable is to be written to what you have created what your company does. You may create and / or assume all necessary
assumptions needed for the completion of this assignment.

One of the main functions of any business is to be able to use data to leverage
a strategic competitive advantage. This feat hinges upon a company’s ability to
transform data into quality information. The use of relational databases is a
necessity for contemporary organizations; however, data warehousing has become
a strategic priority due to the enormous amounts of data that must be analyzed
along with the varying sources from which data comes. Since you are now the CIO
of a data-collection company which gathers data by using Web analytics and
operational systems, you must design a solution overview that incorporates data
warehousing. The executive team needs to be clear about what data warehousing
can provide the company.

Section 1: Design Document
Write a four to six (4-6) page design document in which
you:
Thoroughly
Support the need for data
warehousing within your specific company (PSL)
Thoroughly
Elaborate on the best
practices that the (PSL) company will adhere to.
Thoroughly
Create a schema that supports your
specific company’s business and processes.
Thoroughly
Explain and support the
database schema with relevant arguments that support the rationale for
the structure. Note: The requirement for the schema should entail the
tables, fields, relationships, views, and indexes.
Thoroughly
Create an Entity-Relationship
(E-R) Diagram relating the tables of your database schema through the use
of graphical tools in Microsoft Visio.
Thoroughly
Explain your rationale behind
the design of your E-R Diagram.
Thoroughly
Create a Data Flow Diagram
(DFD) relating the tables of your database schema through the use of
graphical tools in Microsoft Visio Thoroughly
Illustrate the flow of data
including both inputs and outputs for the use of a data warehouse. The diagram
must map data between source systems, data warehouses and specified data marts.
The diagram should map data between source systems, data warehouses, and
specified data marts.I have included deliverable 2 as background information to be used for this assignment. BUSINESS REQUIREMENT DELIVERABLE 2
Business Requirement Deliverable 2
1
BUSINESS REQUIREMENTS
Reference number:
2
BUSINESS REQUIREMENT DELIVERABLE 2
Document Control
Change Record
Date
Author
Version
February 1, 2019 Spencer William, CIO
2.0
February 2, 2019 Spencer William, CIO
3.0
Change Reference
Added References
Added project activates on
GANT chart
Included Reference-Database
and Data Warehousing
Design
Revised security, tasks,
subtasks, and a GANT chart
February 3, 2019 Spencer William, CIO
4.0
Included Reference- Cloud
Technology, Analytics, and
Interfaces. Revised security,
tasks, subtasks, and a GANT
chart
February 4, 2019 Spencer William, CIO
5.0
Included Reference on
Infrastructure and Security,
tasks, subtasks, and a GANT
chart
February 5, 2019 Spencer William, CIO
6.0
Included Reference project
plan, revised business
requirements, project plan
presentation, and final project
plan.
Reviewers
Name
Position
Danael Doe
SME
i
Table of Contents
Document Control ……………………………………………………………………………………………….. i
1
Business Requirements ……………………………………………………………………………… 1
1.1 Project Overview ………………………………………………………………………………………… 1
1.2 Background including current process ………………………………………………………… 2
1.3 Scope………………………………………………………………………………………………………….. 3
1.3.1 Scope of Project ……………………………………………………………………………………….. 3
1.3.1 Scope Control ………………………………………………………………………………………….. 4
1.3.2 Constraints and Assumptions …………………………………………………………………… 4
1.3.3 Risks ……………………………………………………………………………………………………….. 5
1.3.4 Relationship to Other Systems/Projects…………………………………………………….. 6
1.3.8. Definition of Terms (if applicable) ……………………………………………………………. 7
ii
BUSINESS REQUIREMENT DELIVERABLE 2
1 Business Requirements
1.1
Project Overview
Process Specification Language (PSL) Corporation is a data analytics firm that provides
high-quality data analysis for decision-making and problem solving to various organizations. The
firms deal in gathering of consumer insights, demographics, and behavior to convert the data into
an analytical language that provides more information for other business. The main data types
collected include the psychographic, demographic, and consumer insights that is converted into
useful information through analysis and processing. PSL Corporation collects web-based data
using various operating systems that create network traffic for online activities of various users
and target customers.
The Company relies on both SP and Panel-based data to track and monitor the trends and
insights of various network users the data collected relates to the contract customer insight and
trends and may include the long-term personnel data and information of the customers. (Devnani,
Slaven, Bosslet, et al., 2017). Other significant data collected are information of the regional
location of customers, specific identifiers of customer devices, user activity, and purchasing
history. The company is therefore concerned with converting specific business data into useful
information that understandable by other business users.
The firm has been in operation for less than two years and has been primarily gathering
and analyzing data. It monitors the traffic on its website to ascertain whether the people who visit
their website went there directly or followed the link that the organization has provided. The
1
company also use web analytics software to measure and analyze the concrete data relating to
whether the website users used the keywords provided to maneuver to the site (Robson, 2015).
With the company’s planned growth of 20% in the next 18 months, there is a need to
redesign the current information system to improve the functionality to the system in line with
the anticipated expansion. However, the fact that the company is relatively new and operates
with limiting technological infrastructure has made it necessary to hire some potential
outsourcing and offshoring to facilitate the system upgrade.
1.2
Background including current process
PSL Corporation is a data analysis firm dealing with online data gathering and analysis to
provide solutions to other organizations. The company is still at is growth phase and has been in
operation for less than two years. Currently, PSL Corporation applies web analytics to analyze
operating system data which it uses to help other organizations in the decision-making process
(Robson, 2015). The project involves the design and development of the current information
system to improve the functionality to the system in line with the anticipated expansion. The
project goal is to facilitate the growth plan that will see the company expand its operations by
60% within the next 18 months. The project will incorporate a cloud computing technology in
the improved IT system while observing security protocols.
The company is planning to redesign its IT infrastructure and use a hybrid solution that
integrates different technologies and best practices in the industry to facilitate a cost-effective IT
system (Krishnan, Bhagwat & Utpat, 2015). The IT role of this project is to leverage the process
of gathering data by implementing an appropriate IT infrastructure with the capacity to support
2
its growth plan. In response to its growth plan. This improvement will enhance the capability of
the web-based tools
1.3
Scope
1.3.1 Scope of Project
Applications
The Application area will ensure that the project meets the target production
date by restricting the current applications to be fully upgraded with the
latest compatible technology available
Sites
These sites are considered part of the implementation:
https://Process Specification Language.com
https://PSL.com
WWW.PSL/cloud.com
For process Re-engineering, the information system will be made userProcess
friendly to the clients, page layout simplified and upgrade cloud software
Re-engineering
platform
Customization
The customizations of the system will be limited to gathering the
requirements, site homepage, page click count, cart history average.
Interfaces
The major interfaces that would be included in this project include:
homepage, cart, secure payment page, subscription page
Architecture
The relevant application and technical architecture of the project will
analyze the data, provide web-enabled applications, cloud server storage
Conversion
Due to the sensitive nature of the project that PSL Corporation will be
undertaking, the data and volume considered for conversion will be
restricted to tasks, deliverables, and goals of the project.
Testing
The functionalities of the project will be tested based on the design of the
system, software compatibility, security and firewall.
Funding
The project funding is limited to $2,200,000.00 USD for warehouse
construction, software and web development, licenses, trademarks and
permits, legal fees, resources and maintenance
Training
The staff and end users will be trained on implementing and testing the
system, password protection and internet safety training
3
Education
The relevant degrees needed will include but not limited to: Cyber security,
Network Engineering, Web development, Business Info Technology,
Project Management
1.3.1 Scope Control
A Change Control Board will be formed to handle the changes to the scope. The Change
Control Board will be made up of technical chiefs and subject matter experts. The board will
make decisions concerning changes affecting funding, schedule and the scope, and the decisions
will be approved by the representative of the project sponsors and key stakeholders. The scope
control will generally involve controlling the project costs, controlling the project schedule,
controlling the risks inherent to the project and implementing quality control procedures.
1.3.2 Constraints and Assumptions
1.3.2.1 Constraints
The following are the possible constraints that have been identified, that have a possibility of
affecting this project:
•
Lack of enough resources especially the financial resources required to purchase the
required equipment and software.
•
Delivering the project on the set schedule. The project is expected to be delivered with a
specified time schedule despite its complexity.
•
Staffing constraints
•
The requirement to adhere to the set budget
•
Delivering the projects within the scope
•
The requirement that the software must comply with the company’s guidelines on the
user interface.
4
1.3.2.2 Assumptions
The following are the possible assumptions that have been identified:
•
The project will be completed within a specified construction schedule
•
The project will be delivered within the set budget
•
All the required resources will be available
•
The sponsors and the key stakeholders will play their part in the project.
•
The project will be delivered within the purview scope
1.3.3 Risks
The following are the possible risks that have been identified, that have a possibility of affecting
this project.
•
Lack of adequate training for the team members
•
Conflicts between the stakeholders and the management
•
Lack of the required resources to complete the project.
•
Inaccurate estimation of costs
•
The team may not understand the needs of the users resulting in a failure of the objectives
of the project
•
The project may not comply with best practices and standards
•
Inability to complete the project in time
•
The available data might be interfered with during the expansion of the data warehouse
and the databases resulting in loss of data, corruption or theft.
•
3rd party dependencies
•
EEF’s and OPA’s
5
1.3.4 Relationship to Other Systems/Projects
PSL aims at upgrading the company’s infrastructure, hardware, systems, and operations.
The process of upgrading will be done to upgrade data analytics which in the company, comes
hand in hand with business intelligence. The department of the IT and the department of
analytics are the departments that will be affected by the project and hence they need to
collaborate to ensure that their day-to-day operations are not stopped by the project. The upgrade
will also involve integration of new technologies that comprise cloud computing and hosted
solutions. The business entity will obtain its software used in the data analysis from software
publishers using the hosted solution which will boost its data analytics business. It will then set
up its visualized servers at the data center within its premises (Kerzner & Kerzner, 2017).
Cloud computing will increase the backup of the data and make them secure, reliable,
available, credible, and of high integrity. With the backup that comes with the cloud computing
package, the system will reduce redundancy and eliminate scalability. The business entity will
also make use of a database and data warehousing technique to enhance its operations, it will use
interfaces to link the coordination and communication between its stakeholders and its databases.
Through the data warehouse, it will be easy to quickly pull any data needed, reduce errors, define
the trends in the market, and the data will be secure. The infrastructure will also be redesigned to
suit the user preference and functionalities of the new development and growth plans. To
maintain the availability, confidentiality, credibility, and integrity of its data and information,
both physical and logical security controls will be implemented in the new system.
1.3.6. Potential Outsourcing and Offshoring Needs
In the field of cloud computing, data analytics, and data warehousing, the company has
limited staff. Of all the employees, only four deal with IT. Due to the limited IT staff, the
6
company will outsource some of the project’s functions. The company that PSL Corporation has
selected is the TechCyt Company. This is a company that deals with cloud-based software and
data warehousing solutions. Through outsourcing, the staff of PSL Corporation will be able to
continue focusing on the company’s core tasks as the contracted company continues with other
tasks (Larson & Gray, 2015). If there will be a need to outsource other functions during the
course of the project, the company will contract another company.
1.3.7. The Necessary Resources and Staffing Required
Currently, PSL Corporation has 20 employees of which only four are IT
employees. The project will result in increased operations and hence the company will
have to hire more personnel. The IT department requires more staff to meet the
functions of the department. Hiring more personal requires training resources to train
new employees. Other necessary requirements.
1.3.8. Definition of Terms (if applicable)
List any definitions that will be used throughout the duration of the project.
Term/Acronym
Definition
Database
The term database refers to a systematically arranged
catalog of information and data which can be gathered,
shared, transmitted, analyzed, processed, retrieved,
updated, and manipulated for the benefit of an organization
Data Warehouse
A data warehouse is a location where an organization
stored its data in an organized manner for future use
Interface
An interface refers to the point of interaction between two
systems
Offshoring
Offshoring is the relocation of organizations processes
from one country to the other
7
Term/Acronym
Definition
Outsourcing
Outsourcing refers to the process of obtaining services and
goods from third parties who aren’t directly involved in the
major project implementation plan
Staffing
Staffing has involved the process of recruiting, selecting,
deploying, appraisal, promoting, training, and retaining a
workforce who have the required skills, knowledge,
experience, and academic qualifications to undertake
specific tasks to the satisfaction of an organization
EEF
Enterprise Environmental Factors
OPA
Organizational Process Assets
8
References
Chan, S. H., Song, Q., Sarker, S., & Plumlee, R. D. (2017). Decision support system (DSS) use
and decision performance: DSS motivation and its antecedents. Information &
Management, 54(7), 934-947.
Devnani R, Slaven JE, Bosslet, et al. How surrogates decide: A secondary data analysis of
decision-making principles used by the surrogates of hospitalized older adults. J Gen
Intern Med. 2017 Aug 24. doi: 10.1007/s11606-017-4158-z.
Fleming, Q. W., & Koppelman, J. M. (2016, December). Earned value project management.
Project Management Institute.
Kerzner, H., & Kerzner, H. R. (2017). Project management: a systems approach to planning,
scheduling, and controlling. John Wiley & Sons.
Krishnan, Y. N., Bhagwat, C. N., & Utpat, A. P. (2015, February). Fog computing—Network
based cloud computing. In Electronics and Communication Systems (ICECS), 2015 2nd
International Conference on (pp. 250-251). IEEE.
Larson, E. W., & Gray, C. F. (2015). A Guide to the Project Management Body of Knowledge:
PMBOK (®) Guide. Project Management Institute.
Robson, W. (2015). Strategic management and information systems. Pearson Higher Ed.
9

Purchase answer to see full
attachment