Lesson 1: Preparing the Analysis Services Database
Designing a business intelligence application in SQL Server 2005 starts with the creation in Business Intelligence Development Studio of a SQL Server 2005 Analysis Services (SSAS) project based on an Analysis Services project template. After you create an Analysis Services project, you define one or more data sources. Then, you define a single unified view of the metadata, called a data source view, from selected tables and views from the data sources.
In this lesson, you will create an Analysis Services project, define a single data source, and add a subset of tables to a data source view.
This lesson contains the following topics:
- Creating an Analysis Services Project (Data Mining Tutorial)
- Creating a Data Source (Data Mining Tutorial)
- Creating a Data Source View (Data Mining Tutorial)
- Modifying a Data Source View (Data Mining Tutorial)