Introduction to Microsoft Business Intelligence

Microsoft Business Intelligence(MSBI) is a set services & tools. MSBI help us to fetch the data then if required then format it finally provide information to the user this whole process can achieve through MSBI services(SSAS,SSIS,SSRS).

SSAS : SQL SERVER Aanlysis Services.

SSIS : SQL SERVER Infromation Services.

SSRS : SQL SERVER Reporting Services.

      We can get all these services in sql server installation itself just we have to check all these options also in installation phase.

 In order to work with these services(SSAS,SSIS,SSRS) Microsoft provides a tool called Business Intelligence. Which provide respective templtes to work with SSAS,SSIS,SSRS.

 We learn SSRS then SSIS finally SSAS is our target in my articles:

What is SSRS ?

         AS said earlier SSRS is basically a service which help us to provide reports(.rdl) files, we can develop reports using VS.NET BI tool or Report Builder tool also.

Report builder also VS.NET Business Intelligence, but Report builder has limitation is design,testing(option Run). We can’t deploy in any centralized location to user to access them. but which is very useful & preferable in production to check/track the issues.

VS.NET BI tool help us to Design,Deploy,Test(Preview Option) the reports with the help of VS.NET BI tool.

   Finally once we develop the Report(.rdl) using VS.NET BI or Report Builder. report can’t run itself so we need to deploy and manage them. So Microsoft provides Report services configuration Manager  && ReportServer and ReportServerTempDB in SQL Server Database Engine in SSRS installation itself.

Reporting Services Configuration Manager:

now open then connect to sql server instance 

1.      1.  Deploy our SSRS reports in any one specific port as a web application.

2.   2.       Configure Security settings.

3.      3.  Report Manager URL

4.       Email Settings……..

5.       Reports folder structures

                       …………….can be configured with the help it.

All these above reports(.rdl),security settings…..saved in ReportServer database.

( As of my experience I developed my reports using Report builder, in sharepoint we have report library to place them then using sharepoint cental admin we configure Sql server reporting service application take care of it.)

Reference :

https://nirajrules.wordpress.com/2009/12/29/sql-server-reporting-services-ssrs-architecture-overview/