Create a data warehouse project plan

Assignment Help Management Information Sys
Reference no: EM131445786 , Length: 3

Section : Data Warehouse Project Plan

Imagine that the CIO has been impressed with your past performance and has promoted you to database administrator. Your first project is to create a data warehouse project plan that will merge five (5) disparate operational data sources into a common warehouse and associated data marts. The project plan will address the technical design for the future implementation of the data warehouse.

Your company has realized that there is a great amount of data within the company that you should use or test with before you can recommend or propose any intelligent business solutions. You approach for better understanding their business needs is to setup Hadoop independent from their business and systems environment and extract data files to experiment with first.

Simply :

Gathers data from three (3) internal organizational systems and two (2) external sources.

Combines the data into one database.

Manipulates and conforms it to common and organizational standards.

Restructures it for easy exploration, reporting, and data mining.

Use any of the recommended tools (i.e., Hadoop, Google Analysis etc.) in class to analyze this data.

Using your knowledge of requirements gatherings, architectural framework, the Hadoop system, and testing methodologies for data warehouse projects, develop your report for the final analytical findings of preceived trends.

Specifically, write a (2-3) page report in which you:

Write an objective statement to include an introduction of the purpose of this activity

Construct a requirements statement that details the business user and technical requirements.

Use Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, or OpenOffice to complete the following. Note: The graphically depicted solution may not exceed two (2) pages. Ensure that each finding has a written explanation or narrative.

Construct the business and technical metadata that would be necessary for the data files used.

Create a schema for the data files used.

Construct the necessary fact table(s) and dimensional table(s).

Illustrate the flow of data including both inputs and outputs for Hadoop.

Recommend and justify a business intelligence (BI) solution; then, depict the probable dashboard that could benefit users long term.

Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Section 2: Create a PPT for the class on your analysis and findings

expect you and your teammate to present your slides in class. There is a separate loading area for the PPT.

Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the Word document before the paper is submitted.

Reference no: EM131445786

Questions Cloud

Explain the purpose of an income statement : In a two- to three-page paper (excluding the title and reference pages), explain the purpose of an income statement and how it reflects the firm’s financial status. Include important points that an analyst would use in assessing the financial conditi..
How did various stakeholder groups influence : How did various stakeholder groups influence the final outcome of Medicare Part D legislation? What were the specific strategies and tools that were used most effectively
Calculate the theoretical price for index futures maturing : Calculate the theoretical price for the S&P500 index futures maturing in December 2017. Assume that the dividend yield on the index is 1.5% per year continuously compounded. Use the above quotes to determine whether there is an arbitrage opportunity...
Discussing a plan for an incentives management system : Prepare a paper discussing a plan for an incentives management system; discuss incentives for the leadership team, and the rank and file (operational/productive) workforce. You should pick a college institution: Example: University of Mary Washing..
Create a data warehouse project plan : Imagine that the CIO has been impressed with your past performance and has promoted you to database administrator. Your first project is to create a data warehouse project plan that will merge five (5) disparate operational data sources into a com..
What aspect of the skeletal system caught your attention : Please watch the video on the skeletal system. Try to gather as much information as possible from the following video. What aspect of the skeletal system caught your attention
Find probabilities of survival under the nash equilibrium : Moe, Larry, and Curly are in a two round truel. In round 1, Larry fires first, then Moe, then Curly. Each stooge gets one shot in round 1. Each stooge can choose to fire at one of the other players, or to deliberately miss by firing in the air.
Determine general security architecture for the company : Determine general security architecture for the company. Develop a list of 12specific security policies that could be applied. Write specific details along with the rationale for each policy.
Explain the purpose of an income statement : In a two- to three-page paper (excluding the title and reference pages), explain the purpose of an income statement and how it reflects the firm’s financial status. Include important points that an analyst would use in assessing the financial conditi..

Reviews

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd