Project Deliverable 6: Project Plan

The company named as SOMAR AND CO. DATA COLLECTION COMPANY is a data collection and analysis company and is working for less than two years. It wants to create a repository of the company data and is expected to add 20% data in the database every year. So the company is eyeing for the best practices in gathering the data in the company's warehouse.

Scope of the Somar data collection company is full planning about the data collection and analysis, including the features, functions, project goals, tasks, and deadlines. So by adopting all these features of scope, Somar and co. can achieve the results according to need.

How to control the scope?

Controlling the scope of specific business functions is essential. It is a check whether the business is functioning correctly or not. It has three elements:

Know your scope: Somar and co. should know what they want to do. They aim to build a system for the data collection which is reliable, and all the annual data is stored and analyzed correctly.

Train your team: Somar and co. Should, train its team. If the group is qualified enough, it can be able to do the tasks accordingly.

Communicate: Communication is vital between the employees who are involved in the data collection and data analysis process. It is a systematic process.

Features of the data collection and analysis system (assumed):

Somar and co should hire a dedicated team of data collection and analysis Experts.

• The company should be equipped with the best data collection methods and tools and best data analysis skills.

• Experts should be trained enough to evaluate the required data, and they should have an insight into the data analysis on time.

• Collection of, raw data to produce the correct meanings.

Project goals: goals for the Somar and co. will be the following:

• Create a repository for the data that is collected

• Analysis of the collected information

• Adopt the best warehousing practices to achieve the target of 20% data collection every year.

• To wipe off the data which is of no use.

Deadlines: the task deadlines should be under the domain, for example, building a warehouse practice should be within a year be because too much pile up of data can affect the efficiency of the company and its warehousing.

Tools of data analysis: there are the following tools of data analysis:

· R programming

· Python

· SAS

· Apache Spark

· Hadoop

· Excel

Risks, constraints, and assumptions:

Somar and co. can face security risks. Because security concerns are increasing day by day. The restrictions can be the tools used in the whole system, or it can be the warehousing management techniques, or sometimes the offshoring or outsourcing techniques are also involved as in offshoring or outsourcing somar and co. Wants to analyze the data of inventory that is purchased, and the outsourced service calculated the data that is sold the stock. In assumptions, random data samples, normality, independence, equal variances can be used by somar and co. to test the accuracy of the system without creating a loophole in the whole system.

Relationship between system and infrastructure:

Physical and virtual components of support can be helpful for the operation of somar and co. The system is nothing without the foundations; it can help in flow, storage, and analysis of the data. It can be the cooling systems to support the hardware of data centers. The components of internet infrastructure can be fiber optics cables, satellites, antennas, etc.

Security of infrastructures is critical. For example, somar and co. should develop a system of physical security of the company. There should be electronic keys; there should be operating cameras in all the premises. Access to data should be limited to the authorized person only (Rouse, 2006).

Design and implementation of infrastructure are affecting the role of clouding. It is different from the traditional system. The infrastructure as a service can give a broad outlook of the system computing to somar and co. It is a very flexible system. Somar and co. can use the cloud provider’s computer and can store and analyze the data without exporting the system. The interface can also be used for example somar and co. and share two components of the system to share the information regarding the data storing, sharing and analyzing.

The purpose of the database and data warehouse are very different from each other. Somar and co. Data warehouse characteristics will be the following:

• A warehouse in which physical and logical data can be managed.

• A warehouse that creates a relationship between the existing system and data storage

• Somar and co should build a warehouse which can store different department’s data in different sections.

• Somar and co can use the warehouse for the online data analytical processes.

• Apache Spark shall be embedded in the system, as it will help to store the massive data.

• Hadoop big data tool can also be used for the storage of big data because it follows the 3V model

The Apache Spark and Had oop tools will be used to store the big data because they are designed for the storage of big data so the problem of big data with Somar and Co. will be resolved, as they will be storing their data on these engines. Hadoop follows a 3V model; Volume, Velocity, and Variety. The ample space of these engines enables them to store data from different resource simultaneously. The velocity is high as Hadoop does not let the operation to lag, so the system runs smoothly even, with high storage. Variety features allow them to store all structured and unstructured data that includes text, image, video clips, numeric and all sorts. This makes the storage of data more accessible and faster as explained by the image below so Somar and Co. should incorporate it in their system and bring changes in the servers.

Somar and Co. for security should outsource or hire a CSIRT, as it is the Computer Security Incident Response Team that protects the system from any security breach. Somar and co. can arrange the data in the database as well, in the form of columns and rows. They can export DBMS software for this purpose. Analytics can also be used by Somar and co. For example the tracking information from the websites and emails etc. and then analyze it to draw the meanings.

Outsourcing and offshoring needs:

Somar and co. can hire other company to help in the collection and analysis of data and can adopt the best warehousing practices in its own business that can be helpful in many ways. The company can focus on the main operation and can exhibit the outsourcing data collection with the outsourcing partners which are reliable and trustworthy (Jukic, 2016).

Somar and Co. should outsource an IT-Team for now until they develop a plan to build a proper, well-equipped IT Department. For time being the outsourcing will help because the IT Professionals will know how to handle the big data and perform the desired tasks. Meanwhile, the existing technical personnel can manage and communicate with the outsourcing team on day-to-day business for the updates. Also, for security CSIRT should be outsourced instead of hiring a full new team because CSIRT will overlook the network and propose solution for the security of the data. Somar and co. can focus on the other business entirely and it can prove an excellent strategic completion for the company. So outsourcing and offshoring can be a good idea.

Necessary resources: Somar and co. can obtain the resources needed from the publically available resources that can be interviews, observations, questionnaires, documents and records, and focus groups.

Relevant terms used in the project:

Data collection:

A collection of raw data and giving the meanings to store it for future use.

Data analysis: to give useful insights to the collected data.

Outsourcing and offshoring:

To help in the collection and analysis of data and can adopt the best warehousing practices by using outsourcing. The company can focus on the main operation and can exhibit the outsourcing data collection with the outsourcing partners who are reliable and trustworthy.

Sourcing a business through home-based or from the operations from other countries is called offshoring, and this can be done for the whole organization or only a part of the organization.

Warehousing management: all the collected and analyzed data is stored in the warehouse. So warehouse management is necessary.

Course learning outcomes:

REQUIREMENT NO 1:

Companies and non-IT senior managers nowadays are using the power of business analytics. The use of advanced data analysis can result in the boom of the company. It can increase the smartness and quick business decisions. The use of business analytics can give an idea about past performance and can provide the best assumptions and beliefs about future performance. Analytics as a service can use the new and advance cloud technologies which can give the best ideas without implementing the other infrastructures.

REQUIREMENT NO 2:

Technological resources are different kind of tools and devices that can provide the answers to various questions related to the research. These can be scanners, whiteboards, and digital cameras. And the information resources are the data and all kind of information used by the organization. These can be the databases and related tools which can help in gathering the data and analyzing it. These resources can be helpful in research issues.

REQUIREMENT NO 3:

The strategic issue can be a critical issue that can affect the company very severely. So there are many planning processes involved in this matter. It can be international implications on the company’s decision making processes. For example, there are following strategic issues a university campus of the USA is facing:

• What can we do to build a reputation of the brand?

• Where is the market for the students?

• How many accounts are generated and how can be maintained in a regularity?

• What are the strategic opportunities?

• How can the campus meet critical needs?

• Do you know what is going on?

• Is the analysis we conducted is all good?

• Are we searching for the right content?

• Is the campus flourishing or it is just a fake tail? (University Of Illinois Springfield, 2016).

References Jukic, N. S. (2016). Database systems: Introduction to databases and data warehouses. Prospect Press, NA. Rouse, M. (2006, October 17). infrastructure (IT infrastructure). Retrieved from TechTarget: https://searchdatacenter.techtarget.com/definition/infrastructure The University Of Illinois Springfield. (2016). Strategic Issues Facing UIS. Retrieved from University Of Illinois Springfield: https://www.uis.edu/strategicplan/plan/sectiontwo/issues/