Research Article

Reseach article Open access

Designing and Implementing A Data Warehouse in Technology Companies

Behrouz Dolatshah , Ebrahim Nazari Farrokhi , Khatereh Qorbani

A data warehouse is a comprehensive system utilized within enterprises for the examination and presentation of organized and partially organized data from various origins, including point-of-sale transactions, marketing automation, customer relationship management, and others. It is well-suited for both spontaneous analysis and customized reporting. The qualitative research method was employed in this study, focusing on technology companies in Tehran, with an estimated 80 active companies comprising the target population. From this population, four companies were selected as samples, resulting in a total research population of 260 individuals. The sample size was determined based on the availability of panel members, with 30 experts ultimately selected for participation. Initially, a researcher-designed questionnaire, based on prior studies and expert opinions, was used as the data collection tool. Descriptive and inferential statistics were employed to analyze the research questions, with a three-round Delphi method utilized in the inferential statistics to model the design and implementation challenges of data warehousing. The findings revealed that 26 indicators were presented to the participants for evaluating the dimensions, and the participants collectively endorsed and categorized the indicators into three dimensions: business conditions, technology utilized, and data type.

Keywords: Data Warehouse, Technology Companies, business conditions, technology utilized, and data type

Note to users:

Articles in press are peer reviewed, accepted articles to be published in this publication. When the final article is assigned to volumes/issues of the publication, the article in press version will be removed and the final version will appear in the associated published volumes/issues of the publication. The date an article was first made available online will be carried over. Please be aware that, although articles in press do not have all bibliographic details available yet, they can already be cited using the year of online publication and the DOI, as follows: author(s), article title, Publication (year), DOI.

Please consult the journal’s reference style for the exact appearance of these elements, abbreviation of journal names and use of punctuation.

There are three types of Articles in Press:

Journal pre-proofs: versions of an article that have undergone enhancements after acceptance, such as the addition of a cover page and metadata, and formatting for readability, but are not yet definitive versions of record. These versions will undergo additional copyediting, typesetting and review before being published in final form, but are provided to give early visibility of the article. Please note that, during the production process, errors may be discovered which could affect the content, and all legal disclaimers that apply to the journal pertain.

Uncorrected proofs: articles that have been copy edited and formatted, but have not been finalized yet. They still need to be proof-read and corrected by the author(s) and the text could still change before final publication.

Corrected proofs: articles that contain the authors' corrections. Final citation details, e.g. volume and/or issue number, publication year and page numbers, still need to be added and the text might change before final publication.

Management and Educational Studies

Research Article

Designing and Implementing A Data Warehouse in Technology Companies

Note to users:

Note to users: