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

  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.

  Social media and icloud and why it is important

The Internet - social media and iCloud and why it is important - Take a moment to reflect on The Internet as a social media / iCloud and why it is important to you.

  Develop is operational plans that cover only one year

IS Operational Plans - Why might companies today develop IS operational plans that cover only one year?

  Organizational change consulting been impacted by technology

How Changing Technology is Shaping Business - How has the need for organizational change consulting been impacted by technology?

  Implement new system in your business

Successfully implementing new system in your business - What strategy would you use to get the project back on track?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Explain offshore outsourcing for software development

Tablets Take Their Place in the PC Market - What will happen to offshore outsourcing for software development? Can outsourcing firms in India and China for example be expected to develop software systems for use in U.S. schools?

  What software trends are relevant to managers

Management Information Systems - Software Trends and What kinds of software and software trends are relevant to managers?

  Develop a use case diagram for the avs scenario

Create Use Case Descriptions for all the use cases in your use case diagram.  The use case description should include the use case name, actor, brief description, normal flow of events, and exception flow of events.

  Impact of the soa paradigm on perspectives

Impact of the SOA Paradigm on Perspectives - Write a short report to explain the impact of architecture quality attributes on the SOA solution. The report should be a maximum of 2 pages.

  How will use a relational database to store data

Multidimensional Analysis and Data Versus Information - How will use a relational database to store data, be specific.

  Advantages and disadvantages of using standard protocols

Standard Protocols and Reference Models - Explain the advantages and disadvantages of using standard protocols

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