BI 数据报表设计.doc

BI 数据报表设计 目录 摘要 2 Abstract 2 绪论 4 一、商业智能概述 5 （一）商业智能概念 5 1.商业智能概念的提出 5 2.对商业智能概念的新理解 5 3. OLTP 与 OLAP 5 4.多维数据分析 6 （二）商业智能的应用 6 1.从传统到商业智能 6 2. 为什么企业需要商业智能 6 二、探索商业智能 8 （一）商业智能的现状 8 1. 商业智能在国外 8 2. 商业智能在中国 8 （二）商业智能发展之路 8 1. 发展中的三大瓶颈 8 2. 可持续发展 9 （三）商业智能软件 9 1. 商业智能软件介绍 9 2. 商业智能软件发展之路 13 三、详细设计 16 （一）设计内容 16 1. 设计选材 16 2. 设计工具介绍 16 （二）设计实施 16 1. 分析企业经营模式 16 2. 了解企业分析方法 17 3. 模拟企业销售数据 17 4. 画出E-R（实体-联系）图 、创建数据模型 17 5.建立数据仓库 18 6.设计数据报表 21 7.分析报表结果 23 结论 24 致谢 25 参考文献 26 附录1 源代码 27 销售部分SQL 视图源代码 27 拜访部分SQL 视图源代码 31 附录2 英文原文及译文 36 摘要 这篇论文主要是向读者介绍BI的背景和相关的技术知识。笔者从事了多年的BI开发，并且也见证了这个新技术在这几年来的发展过程。目前，他正和一支商业智能团队一起设计分析方法、数据转换和开发报表。他们一起设计多维数据模型(逻辑和物理)，并在它的基础上开发数据仓库，设计数据转换，进行数据分析，最后制作出数据报表。他将会利用他的工作经验，在论文中展示如何设计一套BI系统。 在国际上，商业智能有着它巨大的潜力，来帮助公共机构或者私营企业逐渐关键词Abstract This paper will introduce readers to the BI background and technical knowledge. The writer has engaged in BI development for many years, and he had gone through the development of this new technology. He is working with a Business Intelligence team members to design analysis solutions, data transformations, and reports. They design and implement multi-dimensional database models (logical and physical), data warehousing, data transforms, data analytics, and reporting solutions. He will show how to design a BI system by his work experience in the paper. In the world, Business Intelligence certainly has a tremendous potential for helping both public and private sector organizations become increasingly successful. It has already shown value in many areas of the business and promises to show increased value throughout the business as it matures. It is the primary support for developing an intelligent learning organization. Any new technology, however, must have a solid foundation if it is to be successful and provide benefit to an organization. One major problem is that business intelligence, and information technology in general, is very lexically-challenged. Words and terms are used, misused, abused, and discarded resu