SQL Server Bi step by step 1-preparation

SQL Server 2005 and 2008 provide many new and enhanced business intelligence functions, including integrating multiple data sources using the Integrated Service (SSIS) and using the Analysis Service (SSAs) enrich data content and create complex business analysis; use the report Service (SSRS) to edit, manage, and submit rich reports. if you do not know these functions yet, the next series of presentations will surprise you with SQL Server's current business intelligence support. however, currently, SQL Server Business Intelligence (SQL server business intelligence-Bi) has a relatively small amount of Chinese data, and many time-consuming research has been conducted on some complex issues, both of them need to search for English documents directly or directly go abroadCommunityI will introduce SQL Server Bi based on my current knowledge. I hope to study and improve it with my friends in this area.

Let's make preparations first. The whole case will be based on the adventureworks database. If you do not select to install the SQL server, you can also download it separately at http://www.codeplex.com/sqlserversamples. here are many examples of SQL Server, tools and resources. If you have bi basics, we recommend that you download the example above for research.
The installation of the adventureworks database and example can be referred to the http://www.cnblogs.com/luman/archive/2008/08/28/1278447.html

If you are not familiar with the adventureworks database, read the following resources:

Http://technet.microsoft.com/zh-cn/library/ms124438 (SQL .90). aspx SQL Server 2005 adventureworks Data Dictionary

Http://technet.microsoft.com/zh-cn/library/ms124438.aspx SQL Server 2008 adventureworks Data Dictionary

Https://msevents.microsoft.com/CUI/Register.aspx? Culture = ZH-CN & eventid = 1032321320 & countrycode = cn & isredirect = false describe the webcast of the adventureworks database.

When installing SQL Server, select and install integration service, Reporting Service, Analysis Service, and other services, and select development tools. After installation, you can use vs. Net to open the Bi project:

SSIS project:

SSAs project:

 

SSRs project:

 

As you can see, Microsoft has provided a complete set of BI solutions and can interoperate between them. Reporting Service can generate complex KPI reports based on the Multidimensional Dataset generated by SSAs, integration Service can also call SSAs in the control flow for data analysis. In addition, SQL Server Bi can also be integrated with other Microsoft products. For example, reporting service can be integrated directly into moss, and plug-ins can be installed, in Excel, you can directly operate the data analyzed by SSAs, making the client more convenient. these will be introduced one by one later.

Finally, I would like to share with you some of my frequently visited SQL Server-related websites:

Technical site for http://www.ssas-info.com/Analysis Service
Http://www.sqlis.com/integration service-focused website
Http://www.sqlservercentral.com/SQL Server related technologies Article And video
Http://www.sqlbits.com above
Http://www.jumpstarttv.com/Default.aspx more SQL Server related video tutorials (short tutorial)

Http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/ Microsoft community, of course, you have any questions can be raised here, will certainly help you solve

Also downloaded to the Server 2008 step by step Bi series course http://bbs.winos.cn/thread-50437-1-1.html
There are other videos, e-books, and other materials on hand. If you are interested, you can contact me directly to ask for the materials.

Author: lone knight (like a year of water)
Source: http://lonely7345.cnblogs.com
The copyright of this article is shared by the author and the blog Park. You are welcome to repost this article. However, you must retain this statement without the author's consent and provide a clear link to the original article on the article page. Otherwise, you will be held legally liable.