Describe the operation of a data warehouse

Reference no: EM131259277 , Length: word count:2000

Innovations in Software Development

Introduction:

Research the concepts and technology of data ETL (Extraction, Transformation & Loading) and document the process from start to finish using Microsoft SSIS (SQL Server Integration Services) as the basis of your study.

Learning Outcome(s) Being Assessed:

1. Describe the operation of a data warehouse in support of business intelligence.

Details of Task:

ETL is an important process in the construction of Data WareHouse solutions. It consists of the following three primary phases, you must research each as well as the more specific steps contained within:
- Extracting Data
o From one or more external data sources.
- Transforming Data
o Ensure consistency and satisfy business requirements.
- Loading Data
o To the resultant Data WareHouse.

Microsoft SSIS provides a collection of tools to support ETL including:

- Data Flow Engine.
- Scripting Environment.
- Data Profiler.

"SSIS also acts to glue together the various servers and engines that make up SQL Server".

You must discuss the various tools that SSIS provides and relate them to the phases within ETL. You should also provide suitable examples from case studies (such as AdventureWorks & AdventureWorksDW) to reinforce your discussions.

What you should hand in:

A word processed report not exceeding 20 pages.

Guidelines:

- Correctly reference resources that you use.
- You may also wish to compare & contrast other ETL solutions.

Resources Required:

You may use the computing laboratories on the 6th & 7th floors and the university's database servers (ask the lecturer for details).

You should make use of these specific tools & resources:

- Microsoft SQL Server 2012.
- SQL Server Books Online.
- The Internet.

Reference no: EM131259277

Questions Cloud

What powers does a president have to influence the economy : What powers does a president have to influence the economy? Illustrate these powers with a news article from the last four week. 300 words. With citation.

Which techniques or tools would you use as a manager and why : What techniques or tools can managers use to improve programmed and non-programmed decisions? Why are these techniques effective? Which techniques or tools would you use as a manager and why?

Ethical standards should be applied to professional conduct : How does an individual determine when a code's ethical standards should be applied to professional conduct? Please elaborate your response.

Describe the economic logic : 1. Describe the "economic logic" of three successful companies. (No more than one page)

Describe the operation of a data warehouse : Describe the operation of a data warehouse in support of business intelligence - You must discuss the various tools that SSIS provides and relate them to the phases within ETL. You should also provide suitable examples from case studies

Describe how you have represented weak entities : Describe how you have represented supertype and subtype entities, if any exist.

Write a two page reaction to the lecture : Write a two page reaction to the lecture. In your reaction also provide at least one example as to how one of those themes reflect aspects your education here at the University of Dayton.

Classification of types of segmentation : 1. Search for two ads that are directed towards different segments of the population 2. Explain why you understand that ad is aimed at the segment you picked for each ad

Where did thomas aquinas say that conscience originates : The Latin term a priori describes the origin of knowledge developed rationally, and the term a posteriori describes knowledge developed through observation and experience. What is an example of ethics is best described as discovered in an apostior..

Reviews

len1259277

10/27/2016 8:10:50 AM

Subject- Innovations in System development Word Count- 2000 My lecturer mentioned about the following for the assignment, need more explanation about: -database history -OLAP & OLTP -ETL The assignment question and details is attached.

Write a Review

Required(*) Message

User Account

All Pages