Data Warehouse Architecture

This assignment is a three- part activity. You will respond to three separate prompts but prepare your paper as one research paper. Be sure to include at least one UC library source per prompt, in addition to your textbook (which means you’ll have at least 4 sources cited).

Start your paper with an introductory paragraph.

Prompt 1 “Data Warehouse Architecture” (2-3 pages): Explain the major components of a data warehouse architecture, including the various forms of data transformations needed to prepare data for a data warehouse. Also, describe in your own words current key trends in data warehousing.

Prompt 2 “Big Data” (2-3 pages): Describe your understanding of big data and give an example of how you’ve seen big data used either personally or professionally. In your view, what demands is big data placing on organizations and data management technology?

Prompt 3 “Green Computing” (2-3 pages): One of our topics in Chapter 13 surrounds IT Green Computing. The need for green computing is becoming more obvious considering the amount of power needed to drive our computers, servers, routers, switches, and data centers. Discuss ways in which organizations can make their data centers “green”. In your discussion, find an example of an organization that has already implemented IT green computing strategies successfully. Discuss that organization and share your link. You can find examples in the UC Library.

Conclude your paper with a detailed conclusion section.

The paper needs to be approximately 7-10 pages long, including both a title page and a references page (for a total of 9-12 pages). Be sure to use proper APA formatting and citations to avoid plagiarism.

Your paper should meet the following requirements:

  • Be approximately seven to ten pages in length, not including the required cover page and reference page.
  • Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
  • Support your answers with the readings from the course, the course textbook, and at least three scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find supplemental resources.
  • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

Requirements: 10 page

Answer preview

As alluded to in the introductory part of the paper, organizations in the contemporary business environment are heavily dependent on big data. To effectively leverage big data to improve management, strategic decision-making requires organizations to have effective mechanisms or strategies to collect, store, analyze, and interpret pertinent data (Pearlson et al., 2016). Data warehousing denotes the process of gathering and managing information from different sources to get meaningful business insights (Pearlson et al., 2016). A data warehouse is typically used to connect and assess business data from various sources. It serves as the core of the BI system, created for data analysis and reporting (Pearlson et al., 2016). A data warehouse allows an organization to transform big data into valuable information and avail it to users in a timely way to make a difference (Pearlson et al., 2016).

[3511 Words]

Data Warehouse Architecture

IT management

After a Lakewood IT management team meeting, they decided there is a need for even more information about the the IT service solutions you researched last week. The management team asked for more detail about the solutions you identified as the best selections. Revisit the solutions you selected in week 2’s paper in order to compare and contrast, at least five, features and functions in each solution. In addition, be sure to identify risks associated with implementing each recommended solution. Lastly, make sure to gather and include the capital costs and any on-going operational costs for the hardware/software associated with each solution.

The paper must not exceed 5 pages of content (the title page, abstract [if required], reference pages, figures/tables, and appendices are not content pages). In addition, the paper must use:After a Lakewood IT management team meeting, they decided there is a need for even more information about the the IT service solutions you researched last week. The management team asked for more detail about the solutions you identified as the best selections. Revisit the solutions you selected in week 2’s paper in order to compare and contrast, at least five, features and functions in each solution. In addition, be sure to identify risks associated with implementing each recommended solution. Lastly, make sure to gather and include the capital costs and any on-going operational costs for the hardware/software associated with each solution.

The paper must not exceed 5 pages of content (the title page, abstract [if required], reference pages, figures/tables, and appendices are not content pages). In addition, the paper must use:

Requirements: 3-5 pages

Answer preview

Some risks associated with implementing AWS. AWS is expensive compared to the cost of accessing the cloud-based services from other providers. For instance, a company may be required to pay up to $15,000 per month to access AWS services (Narula, & Jain, 2015, February). Another risk is data breaching threats. Although AWS provides maximum security protection, it is also exposed to some cyber threats. Although the Dropbox application offers numerous services to its users, it is associated with some data security issues. The application is exposed to data theft risks which are associated with a lack of oversight (Drago et al.2012, November). Another security issue is data loss. Lack of visibility over the movement of files or file versions across endpoints is one of the issues affecting the program. It is also associated with the corruption of the data.

[1162 Words]

IT management