Designing a business intelligence application in SQL Server starts with creating an Analysis Services project in Business Intelligence Development Studio. Within this project, you define all the elements of your solution, starting with a data source view.
This lesson contains the following tasks:
-
Creating an Analysis Services Project
-
In this task, you create the Analysis Services Tutorial project, based on an Analysis Services template.
-
Defining a Data Source
-
In this task, you define the AdventureWorks DW database as the data source for the Analysis Services dimensions and cubes that you will define in subsequent lessons.
-
Defining a Data Source View
-
In this task, you define a single unified view of the metadata from selected tables in the AdventureWorks DW database.
-
Modifying Default Table Names
-
In this task, you modify table names in the data source view, so that the names of subsequent Analysis Services objects that you define will be more user-friendly.
Next Lesson
See Also