Data warehouse and database design

Assignment Help Management Information Sys
Reference no: EM1324352

Data Warehouses

As a Business Intelligence Consultant, you have been tasked with submitting a proposal for creating an enterprise data warehouse for a university.

Currently, the information is contained in a separate database by each university department (HR, Payroll, Registrar, Bursar, etc.). Some of the information contained in the various databases for students are: courses, tuition payments, extracurricular activities, scholarships, grades, and personal information. Faculty/staff: positions held, courses taught, salary & benefits, personal information, and published work or research.

They want to use this data warehouse to be able to see a single view of all university information for students, faculty, and staff. You have been tasked with creating a project plan, choosing the BI tools that will be used, and giving cost information.

1. Project Plan and Requirements for the Data Warehouse
2. Database Design
3. ETL Tool Selection
4. Data Mining/Reporting Tool

Reference no: EM1324352

Questions Cloud

Describe commerce clause : Describe Commerce Clause and discuss the effect of the Commerce Clause on federal and state governments and whether it is limiting or empowering in nature
Business and economic ethics : Evaluate whether or not you believe a U.S.-based company outsourcing jobs to foreign markets is ethical. Support your position.
Best practices in emr implementation : Best Practices in EMR Implementation: A Systematic Review Analysis - which of the three phases of EMR implementation is the most important?
Significant information regarding bias : Explain how bias plays a role in the follower's inability to see clearly (Scriptures).
Data warehouse and database design : Data Warehouses - Project Plan and Requirements for the Data Warehouse and Database Design
Conflict management discussion : Whenever you're in conflict with someone, there is one factor that can make the difference between damaging the relationship and deepening it. The greatest factor that determines the outcome is attitude.
Perception of musical rhythm at birth : Several researchers believe that an infant in utero can hear sounds which it is influenced by parents playing music or reading aloud.
Effective resumes : If success in business is due to effective planning, how may an individual proactively prepare for an interview or a job in regards to a resume or cover letter?
Sensory perception introduction : Attempt to put in order the sequence of events that lead up to your exclamation.

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