Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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:

Community Additions

© 2015 Microsoft