Combination of Microsoft Access and Microsoft Excel BI features to develop Sephora Store Decision Support System

AL-Wehaibi, Rehab and AL-Otaibi, Awatif and Khan, Muhammad (2016) Combination of Microsoft Access and Microsoft Excel BI features to develop Sephora Store Decision Support System. Project Report. Biohouse Journal, America.

[img]
Preview
PDF
Sephora Store Decision Support System.pdf - Published Version

Download (455kB) | Preview

Abstract

Business Intelligent (BI) application became the backbone for most of profitable organizations systems. It is provide ability to analyze data, help in forecasting and predicting the trend and preferences of the market alert organization to save the cost and to utilize the resource. Sephora Stores specialized in buying the different product for varying brands. These stores have large data in their data warehouse can get benefits from these data for increase the sales , customer loyalty and quality services .By utilize these data the manager can make appropriate decision and predict the future. We decide to create BI application to provide a clear vision for Sephora manager to invest in right way. Using Excel 2016 features to provide OLAP operations, data visualization and data mining and Microsoft Access to create star schema, fact table with their dimensions and appropriate queries .also we used Visual Basic Application (VBA) for data mining

Item Type: Monograph (Project Report)
Subjects: Information Systems
Divisions: Female College of Sciences and Arts - Khamis Mushyait > Information Systems
Depositing User: L. Awatif ALOtaibi
Date Deposited: 05 Mar 2017 21:10
Last Modified: 05 Mar 2017 21:10
URI: http://eprints.kku.edu.sa/id/eprint/436

Actions (login required)

View Item View Item