Reference no: EM13778847

1. Executive Summary
This particular section of the project plan offers an overview of the scope, objectives and the purpose of the project for which it entails a written plan, the project constraints, and assumptions, detailed summary of the project budget and schedule, a list of project deliverables, and the layout plan for the developing the project management plan.

XYZ Company assets are valued at $25 million dollar data collection and Analysis Company that has been operating less than two (2) years. The company is expected to grow by 60% over the next eighteen (18) months. XYZ Company currently collects data using Web analytics and combines it with operational systems data. Web analytics is an increasingly important part of most business marketing plans. XYZ Company is looking for ways to leverage the collected data but wants to ensure that the information technology infrastructure will support the expected growth that the company is anticipating.

In this project it mainly deals with the improvement of the current data base data warehouse and data transfer and data retrieving. XYZ Company's project proposes to provide best quality services regarding data collection and database for our clients beyond the standard of the contemporary age. The company's project proposes to increase the current ten terabyte data by twenty per cent annually. It also describes the relationship and integration between systems and infrastructure. Database and Data Warehousing, Analytics, Interfaces and Cloud Technology, and Infrastructure and Security should be considered.

The project aims at expanding the storage of data due to the research expansion that is aimed at being achieved. With an expected duration of a going concern, the lifespan of the project is expected to be endless ceteris paribus. However, it is to be subdivided into sections of the years to help in achieving of the goals and objectives. Objectives include covering more research beyond into operational units for companies and advising them based on the results of the research(Yin, 2003).

Companies that deals with data collection, usually have a gigantic collection of information that more commonly goes up to terabytes. Data Warehouse is the only one choice though not as structured as the relational databases, but when used consistent with them data storage turns out to be a giant support. Every moment, a single page visit generates numerous of records to be saved. The information may get outdated, but it can't be deleted because a few months down the line, it is going to be used for evaluation of the company. This assessment of the future possibilities of the given industry depends on - how the info is collected and how efficiently it be organized to provide a clear snapshot for analysis.
Being the CIO of the company I had to search for the data warehouse vendor that can improve our analytics operations.
The Project deals with the improvement of the current data base data warehouse and data transfer and data retrieving. The project proposes to provide best quality services regarding data collection and database for our clients beyond the standard of the contemporary age. The project proposes to increase the current ten terabyte data by twenty per cent annually.

Describe the relationship and integration between systems and infrastructure. Note: Database and Data Warehousing, Analytics, Interfaces and Cloud Technology, and Infrastructure and Security should be considered.
Business Analytics refers to practices, skills and technologies for continuous iterative investigation and exploration of past enterprise performance to gain drive and insight business planning. It also refers to the practice of methodological and iterative examination of business's historical information with the individual essence of statistic making. This Business Analytics can to an extent assist companies optimize and automate their business approaches. Companies whereby information data plays a crucial role acts on its statistical data as a corporate strength and controls it advantage competitive gaining.

A business analytics which is successful would typically rely on experienced and highly skillful professionals and data quality who have well understanding of technologies, comprehends the firms processes in details and knows how work with it. Also, the organization must have proper infrastructure sustain and support the procedures of business analytics.
A network infrastructure is termed as the interconnection of a group of computer systems that are joined by numerous sections of telecommunications architecture.

And to be more specific, this network infrastructure is meant to represent the organization of its various configuration and their parts for example, computers networked individually to cables, switches, network access methodologies, routers, wireless access points, network protocols and backbones. Infrastructure can exist in two forms either closed or opened, in such that a closed architecture of private intranet or the open architecture of the internet.

This can be performed as a combination of both or over a wireless network or wired connections.
The network infrastructure can be represented typically in the simplest form in which is to be made up of a hub to both join the computer machines to the grid connection, one or many computers, internet or network connection and link numerous systems together. The hub usually enters the computers and does not determine the data flow from or to any particular systems. To limit or control access to machines and manage information movement, the switch substitutes the hub to come up with network protocols which determine how the systems interact with one another.

To permit the formed network by the systems to communicate with others, through the network connection, router is an essential requirement, which links the networks and typically offers data exchange of common language, depending on the particular regulations of each network.

1.1 Scope, Objective, and Purpose

• Define the scope and the purpose of the project.
The key goal of this kind of project is to offer software security, infrastructure and demonstrate the software projects being carried out in the course of the development of business requirements.

The aim of the project is to offer:

-Basic environment project plan development

- General scientific database and data warehousing design

- Software development tools

- Demonstrate the Analytics, Interfaces, and Cloud Technology

- Document templates and documentation tools and the support activity essential to guarantee that universal grid-enabled surrounding is

available.

• Describe any considerations of the objectives or scope to be excluded from the deliverables and the project.

the project plan should adopt or use the existing where possible the software tools. Tools are emerging from Microsoft Visio, open software, software security, database, data warehousing and any other communities that can be utilized.

The core goal of the project plan is to develop and define an infrastructure and a process. The later maintenance of the software infrastructure beyond the inspection and business requirement will need a separate resources and planning.

• Ensure that the scope statement is steady and consistent with similar statements in the company case, other business-level documents or

relevant system-level and the project charter.
Because such infrastructure & process project is to attain uniformity in the development of the various software packages of the project deliverables application area.
The work references for the project deliverables is an essential requirement for writing the final report on the management of the software. The

universal recommendation of the project plan can be summarized as:

- All project deliverables must employ the same sets of standards, procedures, and tools.

- use the commonly adopted commercial software or open-source where available

- Avoid using software that do not have a license or may bring some problems.

- Avoid finding a software solution but also engage other IT experts.

• Describe and identify the system or business needs to be satisfied by the project.
The project plan will comprise of the numerous software projects that require to be launched and, therefore, to get universal infrastructure will offer a surrounding that will permit:

- Reduction of the cost by having projects that will share the resources both in terms of worldwide efforts to uphold sharing of usual services

and software licenses, of hardware equipment and a project infrastructure, etc.

- Easier exchange of communication and information among projects.

- An infrastructure that is more advanced than if each person project was building its own.

• Provide a concise detail of:

- The objectives of the project,

- The deliverables needed to meet the project objectives, and

- The procedures by which the fulfillment of the objectives will be determined.

The primary project goals if to offer the deliverables of the projects an infrastructure for the:

- Components that make the software phase's development, for example, testing, planning, documentation, and development.

- Overall service required by any project, such as collaborative facilities, a repository, and a project website.

• Describe the connection of this project plan to the other projects deliverable.

The software projects is going to function usually in offering facilities and services for the other deliverables software projects (e.g. updating the

project plan). But this artifacts use will be overall and, therefore, accessible to all other projects and the software experiments.

• If appropriate, explain how this project plan will be integrated with other ongoing work processes or projects.
The project plan will utilize as much as possible prevailing services and procedures accessible in the experiments, documentation and in the software application processes.

The usage and integration of such kind of the processes are a crucial goal of the project.
Planning is the first and foremost ingredient in this mix. You will need access to blueprints and the design of the building for drop locations whether it be for data and voice or electrical. You will also have to allow locations for peripherals, projectors, VTC, etc. A server room is going to be needed, so make sure that it is sizable for future growth of the network.

The specs for the floor should be outlined. Try and label all cables because this will help with unneeded confusion later on down the road.

Backup power for the backups should be in place also. There are cooling requirements for the server room so make sure you get the specs.
The media that you choose can make or break your networks speed. Try and make it a goal to install a couple of drops at each location for future expansion. If an additional phone or computers are added the location will already be physically installed. You will have to a lot enough time to move your existing lease lines and any other lines.

Remember to save everything on your system before you take it down. After all is said and done a test should be performed to ensure everything is up and running.
XYZ Company is engaged in Web analytics, whichis a generic term meaningthe study of the impact of a website on its users. Ecommerce companies and other website publishers often use Web analytics software to measure

such concrete details as how many people visited their site, how many of those visitors were unique visitors, how they came to the site (i.e., if they followed a link to get to the site or came there directly),

what keywords they searched with on the site's search engine, how long they stayed on a given page or on the entire site and what links they clicked on and when they left the site.
Web analytic software can also be used to monitor whether or not a site's pages are working properly. With this information, Web site administrators can determine which areas of the site are popular and which areas of the site do not get traffic. Web analytics provides these site administrators and publishers with data that can be used to streamline a website to create a better user experience (Peppers, 2008).
XYZ Companywas responsible for carrying out an investigation of how best to offshore their information systems services and decided to go with a large service provider in Okinawa, Japan.

They decided to negotiate with the Japanese company for maintaining a significant portion of their database services. Following a year of intense planning, communication, and transition, the bulk of database maintenance was contracted out to the service provider in Japan.
Outsourcing occurs when information systems activities are carried out by aprovider outside the organization.
Project managers are often involved with negotiation and management of contractswith international vendors for the delivery of information systems services.
Skills Required by the IT Management ofOffshore Projects

Contract negotiation and management

Relationship management

Risk assessment and management

Planning and integration

Business process redesign

Enterprise needs analysis and testing

Security and privacy planning
Outsourcing of information systems services to countries outside the US.
Just because you can get 10 Gigabit Ethernet here today and higher speeds do not mean that you need those ports all over the LAN. Too often customers purchase the fastest equipment possible thinking they need it, even though their existing 100 Mbps network is only running at 5% capacity. While it is definite to ensure that core switches can support these higher speeds, you may be advising the customer to waste a lot of money if you tell them that 10 Gigabit switches are needed everywhere. While these always seem to be left off purchase orders, network management tools are invaluable in providing maximum network uptime. Your goal is to offer the customer the lowest price possible.
More customers are deploying wireless LAN technology and IP telephony. Wireless LAN access points are easiest to install when Power over Ethernet (PoE) is available. IP telephony utilizes phones that connect to and draw power from the LAN.
Value Comparison: Licensed Software vs. Software-as-a-Service (SaaS) Solutions**
Hardware & Software Software-as-a-Service (SaaS)
Pay upfront capital expense Pay-as-you-go-operational expense
High upfront cost and annual maintenance costs Lower up-front subscription costs depending on number of users per month
Cost for applications,maintenance, infrastructure and IT/application resources Cost for annual subscription and minimal IT/application resources
Longer time required to install and configure applications Faster implementation and time-to-productivity
Not much control over vendor after purchase More control over relationship with vendor
Greater risk for users Better risk sharing with vendor

XYZ Company has 4 security design committee or team to determine the security needs of the organization and to deploy security policies which can meet these requirements. The members of the network security design committee are knowledgeable on a number of factors, including the following:

•The mission critical resources of the organization.

• The security weaknesses or vulnerabilities of the organization.

• The threats to which the mission critical resources of the organization is exposed.

• The resources which are mainly at risk.

• The loss to the organization should particular resources of the organization be compromised.

• The level of security needed to secure the organization's resources.

• The security features and security policies which can be used to secure the resources of the organization.

As the business grows so too must the security policies and processes be able to cater for this growth. Determine the risk tolerance of the organization. The level of risk tolerance would differ between organizations.
We know that most of data warehouses risks project are organizational to some extinct than technical (i.e., having a data warehouse that doesn't address a related business need, for example). With that said, in Chapter 4 of Data Warehouse Project Management (by Sid Adelman and Larissa Moss) provides a pretty easy list of the major risks that can confront a DW project.
The risks factors include, but are not limited to the following:

a) Not having a commercial support high in the corporate office.

b) Project management that has never built a data warehouse

c) Team members not getting along, arguing.

d) The data bases are not legit and are to be transaction- oriented vs. aggregation oriented.

There are many risk factors for data warehouse accomplishment. I do not have any case studies to cite but have been implicated in more than 30 data warehouse implementation projects and can only cite experience. I will cover the risks that I have seen to be the most important. By the way, they have nothing to do with tools.
DATA WAREHOUSING COST
There are down sides of course. You have to maintain Data Warehouses and that alone can be expensive to build. They can have a high failure rate without the right mix of high speed, powerful sponsor, and practically short time scale. However, just the impact that this can have on views that are traditional of data ownership and organ¬izational structure can be really fatal.
Here are a few of the more cost that are very noticeable associated with data warehousing are listed in the following table.
1. Time spent in careful analysis of measurable needs

2. Design and implementation effort

3. Hardware costs

4. Software costs

5. On-going support and maintenance

6. Resulting re-engineering effort
Requirements for the business:
The following interpretations regarding the prioritization of requirements have been used:

 Requirements that conclude project success (must have); will be included in this release. These items stand for core functionality and must be present. Absence of any "must have" functionality represents project failure. (Inmon, W.H.,1993).

 Requirements that add value (should have); will be built-in in this release provided that all "must have" requirements have been met and sufficient project resources and time remain. (Inmon, W.H.,1993).

 Requirements that add convenience (nice to have); will be built-in in this release provided that all "must have" and "should have" requirements have been met and sufficient project possessions and time remain. (Inmon, W.H.,1993).
Personal requirement

1. Business Sponsor: review and approve

2. Project Manager: review and integrate into construction project phase

3. Systems Analyst: review and translate into system specifications

4. Stakeholders: review and provide feedback to business sponsor

Some recent principles and tools have evolved and incorporated into a brand new science referred to as Data Warehousing. A data warehouse is a storage facility that is normally used to store an extremely big amount of data through an organization. A relational database is primarily designed for query and analysis processing rather than transaction processing. A relational database is a well-prepared, well-structured and advantageous process of organizing, managing and reporting data that are otherwise non-uniform and scattered throughout the organization in different systems.
The crucial features that data warehouse provide are the fact that: it allows recording, amassing and refining of data to separate systems at higher stages. More often than not it involves historic information that are derived from transactional data. However, it might additionally incorporate data from other sources as well. It helps companies consolidate data from several sources through separating evaluation workload from the transactional workload. Additionally, a data warehouse environment requires ETL which is Extraction, Transportation and Loading resolution, an OLAP which is Online Analytical Processing Engine, analysis tools and different instruments so that you can look at the process of gathering knowledge and eventually supplying it to users. The information stored in these warehouses must be preserved in a design that is dependable, comfy, and effortless to process and manage. The necessity for data warehousing arises as firms turn out to be more complicated, and they have also started producing and gathering a huge quantity of data that have been difficult to manage in the ordinary way.
Knowledge Discovery and Data Mining
Knowledge Discovery and Data Mining is the approach of automatic extraction of non-obvious hidden data from gigantic volumes of information. For illustration, classification units are used to categorize participants into low, medium and excessive lifetime worth. Alternatively of classifying membership in the one-dimension-matches-all product. The membership can be arranged into distinct clusters established on the profile of the individuals and by using the clustering models the merchandise will also be personalized within the high-quality feasible manner for each and every cluster.
All of these KDD applications use special statistical and information mining systems that depend on summarized, discipline-oriented, cleansed data which is best viable and offered using a good designed and structured data warehouse.
Data Integration
An enterprise data is large and complex and spread out through a variety of different in-house and external systems. Also, there's an importance of analyzing data across different systems via vicinity, time, and channel. Therefore, the information integration is needed here so that the entire data is equipped and stored in one region. It also cuts down time and the prolonged approach involved in conception of reviews. Since a sequence of steps concerned in it which might be stripping and extraction of data from one source and then sorting and merging of information after which enriching the information by running reports on it are eradicated.
Data Warehousing serves both the rationale of a reliable information storage platform and also a very capable and satisfactory data integration platform. The information stored within the Data Warehouse is completely built-in, time-variant, non-volatile and field oriented. It helps corporations get a complete view of their company.

Executive Information System
The data warehouse enables a business to make use of government information process as good. This EIS allows the Executives of the corporation to get a holistic snapshot of the company's efficiency so as to make vital decisions. They would need the key performance indications was dropped on them. These KPIs require going division, or cross product evaluation which if accomplished manually is utterly tedious and time drinking undertaking and likewise almost inconceivable to perform on uncooked information derived from operational programs.
Some of these KPIs may just require a cross product or pass the departmental evaluation. However, could also be too manually intensive, if not impossible, to perform on uncooked knowledge from operational methods that are relevant to relationship advertising and marketing and for doing profitability analysis. The data present in Data Warehouses are already structured to support such type of evaluation. Advanced Reporting & Analytics. The foremost design technique of data warehouse is that it supports querying, reporting, and evaluation. The data model is de-normalized and then structured supporting subject areas. This flattened data model makes it faster and less difficult to understand and as good as write queries alternatively of working with hundreds and hundreds of extraordinary tables and write prolonged queries. Consequently, it enables anybody to get even the complex data with somewhat easy sets of queries and even let's perform multidimensional analysis. The data warehouse is designed peculiarly to help in querying, reporting and analysis tasks. Apart from this, it is also possible to do multi-stage trend analysis. Below Multi-level pattern evaluation Data warehousing facilitates analysis of key tendencies at entry level across various dimensions comparable to Company, Location, and Product, Place, Time and the hierarchies inside them. It additionally makes it easier for most reporting ,visualization and data analysis instruments to take full competencies of the info model with the intention to provide enormously robust features reminiscent of drill-down, roll-up and different ways of reducing and dicing data.
Database Schema
Schema will define the table structure. For the entities, we'll make a table and relationship will be defined depending on the type of association between them.
1. Page - Each page URL is unique in itself so it will act as its primary key.
2. Visit table - Each page will have 1 or more visits. Hence, here page's primary key will act as a foreign key.
3. Client - Since client name cannot be unique, we need to generate and ID field as its primary key. The client can ask for data collection for more than one page.
4. Registered User - Registered user is allowed to give feedback on more than one page. Hence in visit table, the primary key of registered user acts as a foreign key.
5. Payment - User are paid for different kind of payment type.
6. Status code - For many page visit and logging in the server, a single status code can be applied. Hence, the primary key of status code acts as a foreign key in the respective tables.
7. Period - For detailed facts of the visit, time notes down in the table.
These are the main tables of the database schema.
ER Diagram
The major entities that form the groundwork of the company are these independent components that facilitate the appropriate data as assortment and sending them to the data marts. Customers are the service receiver of the company.
The consumer visits a page. Internet analytics notices the main points of the page. A single web page can have many visits. Information concerning the unexpected error status code can also be have got to be noted down. A single popularity code can have many web page visits. Data regarding the registered consumer forms the backbone of data source "patron feedback". A single registered user can have more than one visits. At what time information is recorded can also be desires to save in Period? At a single point of time, where there can also be greater than one visit from within the system. Registered user are given payment for his or her feedbacks.