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: 56
Download PDF

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.

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

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
Download PDF
Civic Engagement & Empowerment Platform
Supriya Dadaso Bankar et al. 2026 Computer engineering
Download PDF
RAG System Development with Pydantic AI ChromaDB & Groq
Prof. Priyanka P. Kakade et al. 2026 Computer Engineering
Download PDF