SQL Server 2008中SQL应用系列及BI笔记系列--目录索引
导读:本文主要介绍了创建SQL Server Analysis Service项目及数据源、数据源视图的基本过程。
(一)BI基础概念
一个BI(Business intelligence)系统最多可以有五层:
1. A data source layer(数据源层),由每日操作数据、文本数据、Excel表格、Access数据库、其他外部的数据组成。
2. A data transformation layer(数据转换层),转换数据源层为统一的连续数据,并放入数据存储层。
3. A data storage and retrieval layer(数据存储和提取层),数据仓库。
4. An analytical layer(分析层),多维度的OLAP数据库,为决策者提供分析依据。
5. A presentation layer(展示层),报表和可视化工具。
如下图,可以从不同的维度分析同一份业务数据。
简单的说,一个成熟的企业BI系统可以从多个角度帮助决策者作出合理的判断。
(二)一个BI入门实例
1、创建Analysis Service 项目。
步骤如下:
开始-程序-Microsoft SQL Server 2008 R2-SQL Server Business Intelligence Development Studio,新建一个Business Intelligence Solution,
注意,即使你安装了vs2010 sp1,也不会有现成的Analysis Services项目模板(在线模板也没有)。因此,你还是得在vs2008环境下新建BI项目。试着复制模板,也没有成功。(有知道如何在vs2010环境下创建Analysis Services项目,请告知一声。)
2、创建数据源。
3、创建数据源视图
4、修改数据源视图
如果表过多,上一步得到的图过大,即使缩放也不易察看整体结构。此时,可以在视图设计界面,新建一个diagram,命名为Internet_Sales
至此基本有了分析的数据轮廓。
如果不直接从表,也可以改用查询:
至此,一个Analysis Service项目已经完成,下一步,我们将在此基础上继续创建维度。
附: SQL Server Analysis Services 官方教程(http://technet.microsoft.com/zh-cn/library/ms170208.aspx)
邀月注:本文版权由邀月和CSDN共同所有,转载请注明出处。
助人等于自助! 3w@live.cn
分享到:
相关推荐
Microsoft SQL Server 2008 Analysis Services Step by Step 随书光盘
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL ...
Microsoft SQL Server 2008 Analysis Services Step by Step
《Microsoft SQL Server 2008 Analysis Services Step by Step》随书数据库,由邀月(3w@live.cn)整理上传,本数据库只限学习、研究之用,不得用于商业用途,否则后果自负。
Microsoft-SQL Server 2008 Reporting Services Step by Step(2009).pdf, 学习2008 报表服务的好书
英文版一步一步学习sql 2008 报表服务
Microsoft SQL Server 2008 Reporting Services Step By Step.part1
Microsoft SQL Server 2008 Reporting Services Step By Step.part4
Microsoft SQL Server 2008 Reporting Services Step By Step.part2
Provides information on the fundamentals of Microsoft SQL Server 2005 Analysis Services. Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, ...
Microsoft SQL Server 2012 Analysis Services 高级教程 pdf
SQL Server 2005 Analysis Services Step by Step
Microsoft-SQL Server 2008 Reporting Services Step by Step(2009) 随书光盘 案例数据库文件及补充阅读
Microsoft SQL Server 2008 Analysis Services Unleashed分析服务器很深的技术类书籍
Provides information on the fundamentals of Microsoft SQL Server 2005 Analysis Services. Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, ...
Provides information on the fundamentals of Microsoft SQL Server 2005 Analysis Services. Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, ...
SQL Server 2005 Analysis Services Step by Step CD光盘
This title serves as an authoritative guide to Microsofts new "SQL Server 2012 Analysis Services" BI product and is written by key members of the Microsoft Analysis Services product development team....
Microsoft SQL Server 2008 Reporting Services Step By Step.part3