Page 80 - DCAP606_BUSINESS_INTELLIGENCE

Unit 5: Microsoft Business Intelligence Platform

Using Source Control Services Notes
Like Visual Studio, Business Intelligence Development Studio is integrated with source control
programs. If source control software is established on the computer, you can add solutions and
projects to source control, and then open the solutions and tasks in Business Intelligence
Development Studio from the source control application.

Getting More Information

The Visual Studio documentation provides detailed information about the Microsoft application
development environment. It help collection provides documentation for the user interface that
Business Intelligence Development Studio uses. To access the Visual Studio help topics that are
relevant to the user interface shared with Business Intelligence Development Studio, you must
install the MSDN Library that is included with SQL Server or configure the Business Intelligence
Development Studio help options to access Help. When online Help is enabled, you can obtain
context-sensitive help from the Visual Studio windows by pressing F1 or clicking Help.

Analysis Services in Business Intelligence Development Studio

Business Intelligence Development Studio includes the Analysis Services project for developing
Online Analytical Processing (OLAP) for business intelligence applications. It includes the
templates for cubes, dimensions, mining structures, data sources, data source views etc.

Integration Services in Business Intelligence Development Studio

Business Intelligence Development Studio includes the Integration Services project for developing
ETL solutions. It includes the templates for packages, data sources, and data source views, and
provides the tools for working with these objects.

Reporting Services in Business Intelligence Development Studio

Business Intelligence Development Studio includes the Report Model and Report projects for
developing reporting solutions. The Report Model project type includes the templates for report
models; data sources etc. and provide the tools for working with these objects.

Self Assessment

Fill in the blanks:
14. The choices on the ............................ menu support editing of text and code in documents.
15. The choices on the ............................ menu help you manage the client interface of Business
Intelligence Development Studio.
16. The choices on the ............................ menu customize behaviour of the development
environment.
17. The choices on the ............................ menu organise the behaviour of windows, explorers,
and browsers in Business Intelligence Development Studio.

5.6 Data Extraction, Transformation and Load

In computing, Extract, Transform and Load (ETL) refer to a process that involves:
Extracting data from outside sources

LOVELY PROFESSIONAL UNIVERSITY 75