Installation of Business Intelligence in Visual Studio 2012

Business Intelligence Development Studio

Today, I thought that if Business Intelligence (BI) can work with Excel, QlikView, SQL Server so why not it install in Visual Studio.

Business Intelligence Development Studio is Microsoft Visual Studio with additional project types that are specific to SQL Server Business Intelligence. Business Intelligence Development Studio can be used to create ad analysis business reports and services. Business Intelligence Development Studio have various types of services. Business Intelligence is very useful for crating reports using SQL Server data tools.

Key Point

Business Intelligence Development Studio is used in a 32 bit development environment for analysis and integration services and reporting services projects. Microsoft Visual Studio 2010 does not support the features of Business Intelligence.

It is based on the Microsoft Visual Studio development environment, but basically is customized with the SQL Server services that contains specific extensions and project types that include various tools, controls and projects for reports.

Accessibility in Business Intelligence Development Studio

The Business Intelligence Development Studio has accessibility to interact with the user interface. It means that by using the user interface in Visual Studio it supports many shortcut keys. It helps users like in recognizing colors, text labels and also contains many features.

Installation of Business Intelligence Development Studio

The following is the link for downloading Business Intelligence Development Studio.

Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012

When you complete the installation of Business Intelligence in Visual Studio then open Visual Studio.

Step 1: Open Visual Studio

The first step is to open the Visual Studio window.

window

Step 2: Select New project type

The next step is to select a new project type from "File" -> "New" -> "Project...".

project

Step 3: When you select the project type then there is an option for Business Intelligence in the templates with various types of services.

templates

Now you can see Business Intelligence installed properly in Visual Studio with various types of features.

In the Business Intelligence templates there are the following analysis services.

  • Analysis service
  • Integration service
  • Reporting service

Analysis service in Business Intelligence Development Studio

Business Intelligence Development Studio does contain an analysis service project for developing OnLine Analytical Processing (OLAP) and also contains data mining functionality. This project type of Business Intelligence Development Studio provides a data source, data source views, cubes and dimensions. It can be used with multidimensional data.

Integration service in Business Intelligence Development Studio

Business Intelligence Development Studio does contain an Integration service project for developing Extract, Transform and Load (ETL). This project type includes templates for package data sources, data sources views and also provides various types of tools to work with these objects.

Reporting service in Business Intelligence Development Studio

Business Intelligence Development Studio does contain a Reporting service project for developing reports models and report objects for report solutions. This project type includes various types of reports, models and data sources and data source views. This project type includes shared data sources also.

Business Intelligence Development Studio basically contains the following four types of main windows.

  • Tool box
  • Properties window
  • Design window
  • Solution Explorer

Summary

This article introduced Business Intelligence development types and also explained how to install Business Intelligence in Visual Studio.

X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now