Business intelligence development studio

Business Intelligence Development Studio is developed by microsoft. Microsoft Visual Studio 2005 with additional project types is very useful in business intelligence. These project type supplies templates are required for business intelligence solutions, and provides a variety of designers, tools, and wizards to work with the objects.

Business Intelligence Development Studio have some limitations, the 32-bit development environment for Analysis, Integration, and Reporting projects, is not designed to run on the Itanium 64-bit architecture and is not installed on Itanium servers.

Microsoft SQL Server 2005 is a complete business intelligence (BI) platform that provides the features, tools, and functionality. Business intelligence development studio have capability to build both classic and innovative kinds of analytical applications.

The SQL Server 2005 relational database contains several significant new features. Although the Microsoft Office query and portal tools are not part of SQL Server, the current releases will continue to work with SQL Server 2005. The BI functionality in Microsoft Office will evolve with the Office product release cycle.

Business Intelligence Development Studio is the primary environment that you will use to develop business solutions that include Analysis Services, Integration Services, and Reporting Services projects.Two components are new for SQL Server 2005: SQL Server Management Studio and SQL Server Business Intelligence Development Studio. The other primary BI components are

• Integration Services
• Analysis Services OLAP
• Analysis Services Data Mining
• and Reporting Services