摘要
对数据仓库、联机分析处理(OLAP)的概念进行了简单的介绍,结合实际项目构建数据仓库,利用Excel的数据透视表来实现数据分析功能。此方案摆脱了以往进行数据库操作的复杂性,做到了一般会熟练使用计算机的用户都可以轻松进行操作。
The concept of data warehouse and OLAP are introduced briefly, and the pivot table of Excel is used to realize the function of data analysis by combining a practical project to build data warehouse. This scheme is get rid of complexity of the former database operation, and the normal computer users can operate it easily.
出处
《装备制造技术》
2007年第8期104-106,共3页
Equipment Manufacturing Technology