Business Intelligence Studio tutorial

Business Intelligence Development Studio (BIDS) &nbsp

(Projects and Solutions)

The BIDS paradigm for developing reports is based on the concept of projects and solutions. A project is a container for one type of object such as SSRS reports, web pages, SQL Server Integration Services packages, etc. Projects can be used to organize things in a meaningful way. For instance I could have a project for all reports used by the Accounting department, another project for Human Resource department reports, and another project for the Finance department reports.

A solution is a container for one or more projects. Think of a solution as the complete application that can be made up of a number of different types of projects such as a report project, SQL Server Integration Services project, a web project, etc.

In this section we will walk through creating an empty solution and adding a report project to that solution. In the sections that follow we will add reports to our report project.

To begin launch BIDS by selecting SQL Server Business Intelligence Development Studio from the Microsoft SQL Server 2008 program group. Click File, New Project on the top-level menu to display the New Project dialog. Click Visual Studio Solutions under Project Types, Blank Solution under Visual Studio installed templates, and enter the Name and Location as shown below:

Click OK to create a blank solution. Now we want to add a project to our solution. Remember a solution is just a container for one or more projects. By creating a blank solution, we can add multiple projects that make up the complete solution that we are building.

You might also like

SQL Server 2012 Business Intelligence
SQL Server 2012 Business Intelligence
Lesson 5 : Exploring Business Intelligence Development Studio
Lesson 5 : Exploring Business Intelligence Development Studio
Microsoft Press MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance (Microsoft Press Training Kit)
Book (Microsoft Press)
  • ISBN13: 9780735626362
  • Condition: New
  • Notes: BRAND NEW FROM PUBLISHER! 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!

IIFL Holdings jumps on receiving Sebi nod for investment advisory services  — Business Standard
With this, IIFL Holdings would be offering a wide range of investment and financial advisory services to corporate and institutional clients.

Sarah Oberhofer Joins Brookfield Office of Ameriprise Financial  — Brookfield Elm Grove Now
Brokerage, investment and financial advisory services are made available through Ameriprise Financial Services, Inc. Member FINRA and SIPC. © 2014 Ameriprise Financial, Inc. All rights reserved.

NOVUCOMP EOOD-140555-140555 XeoPOS: Forecast sales using artificial intelligence, keep track of your finances [Download]
Digital Software (NOVUCOMP EOOD-140555-140555)
  • accounts
  • importing data
  • reports
  • rule sets
  • Forecast sales

Capital Intelligence Raises the Ratings of Gulf Finance House BSC  — MENAFN.COM
Being a wholesale entity, the company has no official lender of last resort.

McGraw-Hill/Osborne Media SAP BusinessObjects BI 4.0: The Complete Reference
Book (McGraw-Hill/Osborne Media)
  • Used Book in Good Condition
Microsoft Press Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 (Developer Reference)
Book (Microsoft Press)
  • Used Book in Good Condition
Avery Avery Big Tab Write-On Dividers, 8-Tabs, 1 Set (23079)
Office Product (Avery)
  • Laminated tabs allow you to write, erase and reuse
  • Tabs are 50% bigger than typical tabs to provide more space for writing
  • Get free software and templates at avery s website
  • Three-hole punched with tear-resistant reinforced line for durability
  • Label the tabs with ease using either pen or pencil


Can anyone tell me where the Business Intelligence Project located, in Visual Studio 2003?

Can anyone tell me where the Business Intelligence Project located, in Visual Studio 2003?

You have to install the Business Intelligence version of Visual Studio which is included with SQL Server 2005.

How to get Business Intelligence Development Studio?

If not the free/express version of BIDS is available for download from Microsoft. I do not know if it has a full feature set compared to the full version, anyone care to comment?