ScholarLens Back to search
2008•Computer and ModernizationRequires access

Research and Application of OLAP Based on Excel

Meng Xian-lei

Open publisher page 0 citations

Abstract

Aiming at the problems of OLAP in the practical application,this paper introduces Excel,proposes one kind of OLAP based Excel,puts forward a comprehensive solution of OLAP.The solution integrates OLAP technology into Excel application environment,promotes users to analyze date on their own initiative.The result in the practical application indicates that the using efficiency of the existed information data has been heightened,and the ability of the enterprise decision analysis has been improved.

About this research paper

What this paper is about

Aiming at the problems of OLAP in the practical application,this paper introduces Excel,proposes one kind of OLAP based Excel,puts forward a comprehensive solution of OLAP.The solution integrates OLAP technology into Excel application environment,promotes users to analyze date on their own initiative.The result in the practical application indicates that the using efficiency of the existed information data has been heightened,and the ability of the enterprise decision analysis has been improved.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Aiming at the problems of OLAP in the practical application,this paper introduces Excel,proposes one kind of OLAP based Excel,puts forward a comprehensive solution of OLAP.The solution integrates OLAP technology into Excel application environment,promotes users to analyze date on their own initiative.The result in the practical application indicates that the using efficiency of the existed information data has been heightened,and the ability of the enterprise decision analysis has been improved.

Key concepts: Online analytical processing, Computer science, Decision support system, Microsoft excel, Database, Data science, Data warehouse, Data mining

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
Research and Application of OLAP Based on Excel — Research Paper | ScholarLens