30 likes | 133 Views
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
E N D
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.
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.
Library database • Library database (Oracle) • IP:10.60.1.53 • TNS string: orcl • User/Pass: direpo/direpo • Schema: libsys