Creating a Data Source View (Basic Data Mining Tutorial)

A data source view is built on a data source and defines a subset of the data that populates a data warehouse. You can use the data source view to modify the structure of the data to make it more relevant to your project. By using data source views, you can select the tables that relate to your particular project, establish relationships between tables, and add calculated columns and named views without modifying the original data source. For more information, see Designing Data Source Views (Analysis Services).

To create a data source view

  1. In Solution Explorer, right-click Data Source Views, and select New Data Source View.

  2. On the Welcome to the Data Source View Wizard page, click Next.

  3. On the Select a Data Source page, under Relational data sources, select the Adventure Works DW2008R2 data source that you created in the last task. Click Next.


    If you want to create a data source, click New Data Source to start the Data Source Wizard.

  4. On the Select Tables and Views page, select the following objects, and then click the right arrow to include them in the new data source view:

    • ProspectiveBuyer (dbo) - table of prospective bike buyers

    • vTargetMail (dbo) - view of historical data about past bike buyers

  5. Click Next.

  6. On the Completing the Wizard page, by default the data source view is named Adventure Works DW2008R2. Change the name to Targeted Mailing, and then click Finish.

    The new data source view opens in the Targeted Mailing.dsv [Design] tab.

Community Additions