How will data mart be advantageous to the company

Assignment Help Database Management System
Reference no: EM131726422

Assignment: Data Mart/Data Warehouse Access

Diagram out a data warehouse including all of the information that would be needed for it to be a premier Decision Support System. Choose an industry and a fictional company in that industry as the basis for your data warehouse. Keep in mind the ideas we've covered so far: The data will need to enter the system, will need to be transformed into the long-term storage format, and will need to be stored long term. What will it look like? How big will it be? How will it be advantageous to the company?

Secondly, consider three different actors within the company, with three different user roles. In order to perform their duties, what sort of a data mart would need to be set up for them? Consider time, location, and security issues, as well as any others that you can think of or research in your answer.

Remember to support your responses with research (including adequate references), and to respond politely to your classmates.

Submit your assignment via this assignment's link as a Word .doc file, it should be approximately 3 pages in length with several academic references to support your position. Please feel free to discuss this in the discussion board. I'm happy for the class to come to a consensus opinion (as long as you submit your own paper with your own researched references).

Reference no: EM131726422

Questions Cloud

Unique talent of leader is their ability to understand : create and manage culture and that the unique talent of leader is their ability to understand and work with culture.
Compute the revised depreciation for both years : Compute the revised depreciation for both the second and third years: Book value at point of revision and remaining depreciable cost
Feel age discrimination is rampant : In many cultures, age is celebrated and older individuals are sought out for their wisdom. In contrast, in the United States, many feel age discrimination.
What role does religion play in the latino community and why : What role does religion play in the Latino/Hispanic community and Why
How will data mart be advantageous to the company : Assignment: Data Mart/Data Warehouse Access- What will Data Mart look like? How big will it be? How will it be advantageous to the company?
Aligning performance management with hr strategy : Thinking of a company that you are familiar with, which HR strategy (Bargain Laborer, Loyal Solider, Committed Expert, or Free Agent) is currently in place?
What is the amount we owe after discount : We returned $300 of merchandise. What is the amount we owe after a 1% discount
Discuss video content relates to some aspect of sociology : Use your sociological imagination to find ways that the video content relates to some aspect of sociology
Summary of one leadership book : Share a summary of one leadership book you have read and what you learned - whether you agreed or disagreed with the concept.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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