1 / 3

Data Warehouse Project: Building Insights for E-Shop Competitiveness

This project focuses on creating a comprehensive data warehouse system to enhance decision-making for e-shop owners. The goal is to monitor competitor pricing, item availability, and user behavior across various browsers weekly. The process includes defining the business purpose, gathering necessary data from the library database and external sources, designing an effective data model, and establishing an ETL process. A presentation will showcase how data is gathered, integrated, and analyzed, along with detailed reports to support strategic decisions and improve market understanding.

bambi
Télécharger la présentation

Data Warehouse Project: Building Insights for E-Shop Competitiveness

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