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

  Discusses rfp and its role in the purchasing process

What is an RFP, and what critical tasks does it facilitate in the purchasing process? and Discusses RFP and its role in the purchasing process.

  Visit and analyze the company-specific web-site

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

  Expalin importance of human resource information systems

The Importance of Human Resource Information Systems - What you learned in HRIS research, and what surprised you the most in HRIS capabilities.

  Explain the advantages of the medium

Common Transmission Mediums - The Twisted Pair - Explain the advantages of the medium, and identify at least one application that would not be able to use it?

  Why ethical practices are conducted for theortical concepts

Healthcare Information Technology - analyze how and why ethical practices are conducted for outlining theortical concepts in discipline.

  What sort of service level agreement do they offer

Disk vs Cloud Storage, Backups, SLAs - What sort of service level agreement (SLA) do they offer? Are you willing to store your information with a personal cloud provider that offers no SLA? Why or why not?

  Explain types of networks- lan and wwn

Types of Networks: LAN and WWN - What are the two types of networks that are specific to the user? How are these types of networking advantageous for both the business and the end user?

  Technological innovations in spreading christianity

Utilization of Information Technology in churches in the U.S - It indicates how churches in the United States utilized technological innovations in spreading Christianity.

  Discuss information systems-insurance

Information Systems-Insurance - Discuss with your classmates your thoughts about why these users might be getting such poor response.

  What is the best quantitative and qualitative approach

Quantitative and Qualitative Project Analysis and qualitative and quantitative approaches that can be used to analyze project problems

  Show the information sharing with global partners

Information Sharing with Global Partners - What procedures would you put in place to allow information sharing between your global partners without compromising your information's security?

  Backup terminology

This post addresses Windows 7 and backup terminology - Briefly explain the three types of Windows 7 updates: Important, Recommended, and Optional.

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