1 / 3

Final Exercise (by December 10th)

Final Exercise (by December 10th). Define a business purpose you want to achieve or a problem you want to solve List all the data you have/need in the Library Database or seek external data Create suitable data model to hold the integrated data Design the ETL process

bambi
Download Presentation

Final Exercise (by December 10th)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Final Exercise (by December 10th) • Define a business purpose you want to achieve or a problem you want to solve • List all the data you have/need in the Library Database or seek external data • Create suitable data model to hold the integrated data • Design the ETL process • Build reports on top of the data • Present your DW project and show how you do it and achieve your goal in 10 to 15minutes. • You will need to create a slide to show how you get the data, design the ETL process, Data Model and reports.

  2. Business Purpose Samples… • As an owner of the e-shop, I want to see the competitor price of the items I am selling every week. • As an owner of the e-shop, I want to see how many competitors are selling the same items I am selling every week. • As an owner of the e-shop, I want to see how many items are listed under one category on the competitor site every week. • As a web site owner, I would like to know how many users access my site from different broswers(IE, firefox…) every week • List questions as many as you can, and then get the data and do the data integration.

  3. Library database • Library database (Oracle) • IP:10.60.1.53 • TNS string: orcl • User/Pass: direpo/direpo • Schema: libsys

More Related