Please use this identifier to cite or link to this item: https://hdl.handle.net/11147/3321
Full metadata record
DC FieldValueLanguage
dc.contributor.advisorAytaç, İsmail Sıtkıen
dc.contributor.authorGüratan, Işıl-
dc.date.accessioned2014-07-22T13:51:19Z-
dc.date.available2014-07-22T13:51:19Z-
dc.date.issued2005en
dc.identifier.urihttp://hdl.handle.net/11147/3321-
dc.descriptionThesis (Master)--Izmir Institute of Technology, Computer Engineering, Izmir, 2005en
dc.descriptionIncludes bibliographical references (leaves: 99-101)en
dc.descriptionText in English Abstract: Turkish and Englishen
dc.descriptionxii, leavesen
dc.description.abstractIn the business world, many organizations store, organize and update their records of activities in large databases. As years pass, huge amount of data is gathered within the systems of the companies. As the system grows fast, some problems in the comprehension and analysis of the data collected occur. On the other hand, companies should analyze the accumulated data accurately and get information from them in order to carry out some crucial functions critical to the survival of the company such as planning, forecasting and managing. The difficulties mentioned above have compelled the technology experts to find new solutions to assist the people taking part in the decision process and lacking in technical knowledge. In the recent years, the concept of data warehouse has begun to appear as a new type of complex decision support systems. A data warehouse can simply be defined as a pool of data that supports users in making strategic decisions. These data are organized in a way that will present easy use and excellent reporting performance. The subject of this study is to design and develop a data warehouse using the necessities and sales database of a retailer company. Firstly, data warehouse and the steps of data warehouse processes are defined, and then applied part is explained. The data warehouse application constituting the subject of this thesis is carried out in a middle-scale company that is in the food sector and has a nation-wide distribution net. This company has approximately 600 employees. In this study, a data warehouse has been designed in order to support the Sales and Human Resources Departments by using the data collected by Sales Field Organization of the company. The main objective of creating a data warehouse is to enable a better control of the Sales Representatives working in the Sales Field Organization by Sales Managers and provide the gathering of consistent and accurate data that will be used by Human Resources Department while preparing a performance measurement system. These data will also be used by the Sales Department while determining a sales policy for the company. In this study, powerful and easy-to-use MS SQL Server 2000 that includes data transformation and analysis tools is used.en
dc.language.isoenen_US
dc.publisherIzmir Institute of Technologyen
dc.rightsinfo:eu-repo/semantics/openAccessen_US
dc.subject.lccQA76.9.D37 .G72 2005en
dc.subject.lcshData warehousingen
dc.titleThe design and development of a data warehouse using sales database and requirements of a retail groupen_US
dc.typeMaster Thesisen_US
dc.institutionauthorGüratan, Işıl-
dc.departmentThesis (Master)--İzmir Institute of Technology, Computer Engineeringen_US
dc.relation.publicationcategoryTezen_US
item.openairetypeMaster Thesis-
item.openairecristypehttp://purl.org/coar/resource_type/c_18cf-
item.fulltextWith Fulltext-
item.languageiso639-1en-
item.cerifentitytypePublications-
item.grantfulltextopen-
Appears in Collections:Master Degree / Yüksek Lisans Tezleri
Files in This Item:
File Description SizeFormat 
T000414.pdfMasterThesis2.83 MBAdobe PDFThumbnail
View/Open
Show simple item record



CORE Recommender

Page view(s)

124
checked on Mar 25, 2024

Download(s)

202
checked on Mar 25, 2024

Google ScholarTM

Check





Items in GCRIS Repository are protected by copyright, with all rights reserved, unless otherwise indicated.