MSBI Interview Questions

MSBI Interview Questions

  • MSBI Characteristics

Criteria Result
Analytics Dashboards, guided navigation and drill down
Type of Solution End-to-end Business solution with extended ETL
User-friendly Ease of installation, use, maintenance


  • Define Query parameter in SSRS?

Query parameters is revealed in the query of the datasources that are to be included into the SQL script’s where clause of the SQL that can accept parameters. Query parameters begin with the symbol @.

  MSBI Interview Questions

  • What are the Reporting Service Constituents in SSRS?

Report Manager :A Web-based administration tool for managing the Report Server.
Report Server : Provides services for implementation and delivery of reports.
Report Designer : A place where we can create report.


  • What do you understand by matrix in SSRS?

A matrix is a data region related to a report set. Matrix permits us to create crosstab reports with the report variables showing on rows and columns. It allows us to drag.

                                                                                                                                  MSBI Interview Questions

  • What do you mean by sub reports and how we can create them?

A sub report is like any other reports which can be termed in main report and can be generate through main report. Parameters can be conceded from main report to sub report and basis of that report can be created.


  • Define report model project?

Report model project is used for creating Adhoc reporting. We can create the adhoc reports over report builder. Report model project can be created on bids or report server. This model can have simple view.

 MSBI Interview Questions

  • What do you understand by report server project?

Report Server Project comprises of RDL file and it need to be deployed on report server to view the report files to application and user. It is a solution where we can design our reports. We can add it by going into BIDS clicking on new item and then selecting reports server project. Once the solution is formed we can start forming reports.

  • Explain report builder?

Report builder is used to create small reports and it is a define interface. We can’t change the report interface in report builder it pre designed. We can just drag columns in the report. It creates reports on database objects available with report model project.

                                                                                                                                   MSBI Interview Questions

  • In which SQL Server type report builder introduced?

Report builder presented in SQL Server 2005. While creating or arranging report model project on report server we can get error or it might not get formed. For this we need to check whether the service pack 22 is installed or not.


  • How to organise the Report?

Report can be organized in three ways :

Using visual studio :In visual studio we can directly deploy the report through solution explorer by providing the report server URL in project properties at Target Server URL. This will organize entire project or single report as per our selection.
Using report server :We can directly go to the report server and deploy the report by looking the report from the disk location on server.
Creating the utility :SQL server provides the utility which can be used to create a modify utility for our report deployment in bulk.
MSBI Interview Questions

  • Define RS.exe utility?

Rs.exe utility is used for organizing the report on report server. It comes with the report server and can be modify accordingly.

  • What is the name of reporting services config file and what it is used for?

Reporting service config file is used for report configuration details. It contains the report format and also the report import types. Report service config exist in ISS.

  • What are the three different part of RDL file elaborate them?

In visual studio RDL files has three parts.
Data : It covers the dataset on which we write the query. Data set is associated with data source.
Design : In design we can design report. We can create tables and matrix reports. We Drag columns values from source.
Preview : It ia used to check the preview after the report run.

  • Which language rdl files made of?

RDL files are printed in XML

  • What do you understand by chart in report?

Chart reports are for graphical representation. We can get pie charts columns harts and various other options. 3d charts are also presented in reporting services.

  • Define Data Set in report?

Data set are the set of data which we want to show in report. Data creates on data source. Data source is the source of data from where we are receiving this data i.e. database server and database name joining string.

  • Name different types of data sources in SSRS?

SQL Server SAP Net weaver BI.
Report Server Model.
SQL Server Analysis Service OLEDB.
SAP Net weaver BI.

  • What is the web service used for reporting services?

Reporting Service Web Service used in SSRS. By retrieving this web service we can access all report server section and also get the report organized on report server.

  • How to enhance the custom code in Report?

To enhance the custom codes in report go to report tab on top then properties and there you will find the selections for custom code.
MSBI Interview Questions

  • Define cache in SSRS?

Report server can lay up a copy of processed report in a memory and return the copy when a user opens the report. This server memory is called as cache and the process is known as caching.

  • Elaborate Web service task in SSIS?

First we configure HTTP Connection manager which will point to WSDL of a web service.
Web service task customs this HTTP Connection manager and let us invoke methods in it.
It return values of method value we can store it in some variables and can use as input for some other tasks.

  • Explain transfer SQL Server object task?

It allows us to allocate different SQL server objects between different instances of SQL Server.Object incomes from table, stored procedures, user defined functions etc.
MSBI Interview Questions

  • In SSIS is it conceivable to communicate with MSMQ?

Yes, it is possible for that we have Message Queue task. It contract us send messages to MSMQ and receive message from MSMQ.

  • What is the advantage of using MSMQ?

MSMQ helps in communicating two applications with each other asynchronously. Specialty is two application may be built using dissimilar technology and it works even offline messaging. Sender will stock messages inside queue and reader reads it wherever required.

  • Differentiate between SSRS 2005 and SSRS 2008

The major differences between SSRS 2005 and SSRS 2008 are as follows:
SSRS 2005 report server requires IIS, whereas SSRS 2008 comes with a build-in web server and hence does not require IIS.


This information box about the author only appears if the author has biographical information. Otherwise there is not author box shown. Follow YOOtheme on Twitter or read the blog.
+91 9952948899