Efficient Use of OLAP Cube to Analyze Business Data for Decision Making

May 2022
Vol-8, Issue-3
Paper ID: 16618
ISSN: 2395-4396
Downloads: 0

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.

Export Citation

Related Research

Comprehensive Review of Existing Chatbot Systems for Career Assistance, Resume Support, and ATS-Aware Guidance
Amruta Bargal et al. 2026 Data science
PDF Unavailable
Development of an AI-Powered Multimodal Web Assistant with Intelligent Resume Building and ATS Enhancement
Amruta Bargal et al. 2026 Data science
PDF Unavailable
A Deep Learning-Based Framework for Mood-Oriented Music Recommendation Using Facial Expression Analysis
Vaibhav Ashok Bhangare et al. 2026 Computer Engineering
PDF Unavailable
Survey On : Intelligent Payroll and Human Resource Management Systems: A Systematic Review of Automation, Security, and Analytics
Vishakha Jadhav et al. 2026 Human Resource Management, Artificial Intelligence, Machine Learning, Payroll Systems, Cybersecurity, Business Intelligence, Robotic Process Automation, Employee Analytics, Digital Transforma
PDF Unavailable
Civic Engagement & Empowerment Platform
Supriya Dadaso Bankar et al. 2026 Computer engineering
PDF Unavailable
Recent Developments in Microneedle Technology and Its Diverse Biomedical Applications
Diksha Patil 2026 Technology
PDF Unavailable
RAG System Development with Pydantic AI ChromaDB & Groq
Prof. Priyanka P. Kakade et al. 2026 Computer Engineering
PDF Unavailable
Machine Learning Based Early Stage Diabetes Detection System
Rohan Mulik et al. 2026 Computer Engineering
PDF Unavailable
A Survey on Skillsense:AI Career Analyzer App
Kirti Datir et al. 2026 Computer Engineering
PDF Unavailable
Employee Performance Portal
P.Harika et al. 2026 Computer science and engineering
PDF Unavailable