Em Andamento

Implementation Of A Data Warehouse And a Star Schema Diagram

I have uploaded files regarding the task but below is a description of the core tasks to be completed. It must be completed at a university level as it is for a univeristy assignment.

Specify 2 suitable DW reports (queries). A star schema for the Data Warehouse to support your 2 queries specifying:-

• the tables and key and non-key attributes for the DW,

• attribute definitions.

List the anomalies, differences and issues between the 3 data sources that will affect you taking the data from them and loading it into your Data Warehouse.

For each case you identify, make a recommendation to overcome it. (This could involve data cleansing, transformation).

Using QSEE, forward engineer the star schema database you have designed. Create and run a script to create the data warehouse tables initially, this script will be run once only, it sets up the tables.

Include the QSEE generated script(s) as part of your upload.

Implementation of the ETL (Extract, Transform, Load) programs:

Your oracle account is effectively the ‘data-staging’ area for the exercise.

In this assignment you are going to create the data warehouse schema, populate it with data from the data sources (xls spreadsheets).

Include a short ‘overview document’ describing your implementation and referencing the scripts you have written (.sql) and tested (evidenced by spool(.lst) files). Include these files as part of your upload (there is no need to print them out).

Implementation involves:

1. ETL script 1 – Initial Insert

Load the xls files into Oracle – describe how you did this.

Create a script to populate the data warehouse from the provided data sources, this script will be run once only.

2. ETL script 2 – On going maintenance

Create a script to insert into the DW the new data that has accumulated in the 3 data sources for 2009/10.

3. Create an interface to provide the reports for your Data Warehouse. (For example using SQL or apex tools).

Data Mining

Describe a scenario where data mining could be used in the assignment case study, ie. a Data Warehouse for recorded crimes. Use examples to describe your scenario, you may wish to discuss data that hasn’t been provided by this case study but would be useful in terms of data mining. (word limit: 300 words).

Habilidades: Oracle, SQL

Ver mais: star schema diagram data warehouse, star schema implementation oracle, star schema implementation, star diagram sql, case study star schema, forward engineer qsee oracle, star schema exercise, star schema university data warehouse exercise, star schema diagram case study, oracle load programs, data warehouse implementation using star, assignment implementation, star schema sql, data warehouse diagram case study, implementation data warehouse diagram, data mining implementation oracle, data mining schema university database, star schema case study, data warehouse implementation, data warehouse etl diagram, sql star diagram, implementation star schema, data warehouse assignment etl star schema, sql diagram, implementation star schema sql

Acerca do Empregador:
( 0 comentários ) Huddersfield, United Kingdom

ID do Projeto: #580735

5 freelancers are bidding on average $220 for this job


Hello, We have extensive experience in datawarehousing having worked on ETL tools like OWB, have got experience in SQL PLSQL. we can complete the project within budget and time Regards gisoftek

$200 USD in 5 dias
(0 Comentários)

Hi, we are basically a software development firm and posses a team of highly skilled professionals who can provide timely and quality work. We do these types of projects regulary. We can also send you our profile as pe Mais

$250 USD in 6 dias
(0 Comentários)

please check pmb

$250 USD em 1 dia
(1 Comentário)

I will do it , i m already in oracle on databases.

$150 USD in 5 dias
(0 Comentários)

Ø Working professional. Ø Working in Design, Development and Implementation of Datawarehosuing /Business Intelligence Systems for around 6.5 years. Ø Designed Complete Warehouse Architecture and Process flow from Mais

$250 USD in 7 dias
(0 Comentários)