SQL Server BI Step by step 1

SQL Server 2005 and 2008 provide many new and enhanced business intelligence features, including leveraging Integrated Services (SSIS) to consolidate multiple data sources, leveraging Analysis Services (SSAS) to enrich data content and build complex business analytics; And the use of report Services (SSRS) to edit, manage, and submit rich reports. If you don't know these features now, the next series of introductions will give you a surprise about SQL Server's current business intelligence support. But now about SQL Server Business Intelligence (SQL Server Business Intelligence-bi) Relatively few Chinese materials, a lot of time for the study of some complex problems, you need to search the English language directly or directly to the community to ask for advice. From the beginning of this article, I will be based on the relevant knowledge now available, the introduction of SQL Server BI, I hope and friends in this field to study and improve.

Let's start with the preliminary preparation, the whole case will be based on the AdventureWorks database, if you install SQL Server did not choose to install, you can download separately, http://www.codeplex.com/ Sqlserversamples, and here are a lot of examples of SQL Server, tools and resources, if you have a bi basis, it is recommended to download examples directly from the above to study.

AdventureWorks database and sample installation can refer to the http://www.cnblogs.com/luman/archive/2008/08/28/1278447.html

If you are not familiar with the AdventureWorks database, please use the following resources to understand:

http://technet.microsoft.com/zh-cn/library/ms124438 (sql.90). aspx SQL Server 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 introduces the webcast of AdventureWorks database

When you install SQL Server, select services such as install integration service,reporting service,analysis Service, and select the development tools. When the installation is complete, you can open the BI project with vs. NET:

SSIS projects: