Efficient Use of OLAP Cube to Analyze Business Data for Decision Making
Abstract & Details
Research Area
Computer Engineering
Keywords
OLAP
pre-calculate
OLAP database
pre-aggregate
relational database
Abstract
OLAP is a software that allows users to analyze information from multiple database systems at the same time. Using OLAP technique, analysts easily extract and view business data from different points of view. Analysts frequently need to group, aggregate and join data. These operations in relational databases are resource intensive. With OLAP, data can be pre-calculated and pre-aggregated, making business data analysis faster. OLAP databases are divided into one or more cubes. The cubes are designed in such a way that creating and viewing reports become easy to make business decisions faster. The OLAP Cube consists of numeric facts called measures (it is property on which calculations can be made) which are categorized by dimensions.
License
This work is licensed under a Creative
Commons
Attribution-ShareAlike 4.0 International License.
Author Information
| # | Name | Institute / Affiliation |
|---|---|---|
| 1 | Mrs. Vijayshri D. Vaidya | Dr. Vitthalrao Vikhe Patil Polytechnic, Loni Maharashtra |
| 2 | Mr. Abhishek A. Nibe | Dr. Vitthalrao Vikhe Patil Polytechnic, Loni Maharashtra |
| 3 | Mr. Avinash B. Anap | Dr. Vitthalrao Vikhe Patil Polytechnic, Loni Maharashtra |
| 4 | Mr. Vasimraj S. Tamboli | Dr. Vitthalrao Vikhe Patil Polytechnic, Loni Maharashtra |
| 5 | Mr. Ravindra S. Kakade | Dr. Vitthalrao Vikhe Patil Polytechnic, Loni Maharashtra |
How to Cite
Use the following formats to cite this article in your research.
APA Style
Vaidya, Mrs. Vijayshri D., Nibe, Mr. Abhishek A., Anap, Mr. Avinash B., Tamboli, Mr. Vasimraj S., & Kakade, Mr. Ravindra S. (2022). Efficient Use of OLAP Cube to Analyze Business Data for Decision Making. International Journal of Advance Research and Innovative Ideas In Education, 8(3), 577-585.
MLA Style
Vaidya, Mrs. Vijayshri D., et al. "Efficient Use of OLAP Cube to Analyze Business Data for Decision Making." International Journal of Advance Research and Innovative Ideas In Education, vol. 8, no. 3, 2022, pp. 577-585.
IEEE Style
Mrs. Vijayshri D. Vaidya, Mr. Abhishek A. Nibe, Mr. Avinash B. Anap, Mr. Vasimraj S. Tamboli, and Mr. Ravindra S. Kakade, "Efficient Use of OLAP Cube to Analyze Business Data for Decision Making," International Journal of Advance Research and Innovative Ideas In Education, vol. 8, no. 3, pp. 577-585, 2022.
Vancouver Style
Vaidya Mrs. Vijayshri D., Nibe Mr. Abhishek A., Anap Mr. Avinash B., Tamboli Mr. Vasimraj S., Kakade Mr. Ravindra S.. Efficient Use of OLAP Cube to Analyze Business Data for Decision Making. International Journal of Advance Research and Innovative Ideas In Education. 2022;8(3):577-585.
Harvard Style
Vaidya, Mrs. Vijayshri D., Nibe, Mr. Abhishek A., Anap, Mr. Avinash B., Tamboli, Mr. Vasimraj S., & Kakade, Mr. Ravindra S. (2022) 'Efficient Use of OLAP Cube to Analyze Business Data for Decision Making', International Journal of Advance Research and Innovative Ideas In Education, 8(3), pp. 577-585.
Chicago Style
Vaidya, Mrs. Vijayshri D., et al. "Efficient Use of OLAP Cube to Analyze Business Data for Decision Making." International Journal of Advance Research and Innovative Ideas In Education 8, no. 3 (2022): 577-585.
Turabian Style
Vaidya, Mrs. Vijayshri D., et al. "Efficient Use of OLAP Cube to Analyze Business Data for Decision Making." International Journal of Advance Research and Innovative Ideas In Education 8, no. 3 (2022): 577-585.
Related Research
A Brief Review of Performance Evaluation of Global and Local Image Thresholding Based on Computational Efficiency
Download PDF
Performance Evaluation of Global and Local Image Thresholding Based on Computational Efficiency
Download PDF
Enhancing Handwritten Alpha-Numeral Recognition Using GAN-Based Synthetic Data Generation
Download PDF
Comprehensive Review of Existing Chatbot Systems for Career Assistance, Resume Support, and ATS-Aware Guidance
Download PDF
Development of an AI-Powered Multimodal Web Assistant with Intelligent Resume Building and ATS Enhancement
Download PDF
A Deep Learning-Based Framework for Mood-Oriented Music Recommendation Using Facial Expression Analysis
Download PDF