What is SSRS?

What is SSRS?

SSRS or SQL server Reporting Services which is also called Microsoft SQL reporting is a component of the Microsoft BI stack. Reporting Services has intergraded into a mature and flexible reporting Tool.

Organizations can leverage Reporting Services and the Microsoft Business Intelligence Platform to implement a variety of reporting solutions, including enterprise reporting, Internet reporting, ad hoc reporting, and embedding reports in custom applications.

 

Why Use Reporting Services?

Reporting Services can help you implement a wide variety of type reporting. For example, Reporting Services can address two of the most pervasive reporting needs in every organization: standard reporting and ad hoc reporting.

Standard reporting

A standard report is a conditioned report whose layout is not meant to be changed by end users. Sales by Product marketing reports and Balance Sheet financial reports are good examples of standard reports. Standard reports can be rather complex. For instance, features a standard report that has multiple tables and chart sections:

 SSRS Standard reporting

 More...

Business Intelligence Architecture. Optimization Role Based Security process as ETL step

Business Intelligence

We are happy to start new exciting category of our blog - Business Intelligence articles. 

After a list of successfully designed and implemented BI solutions I want to share our experience and note all complex moments and issues that we have been faced. 

Business Intelligence (BI) - the set of techniques and tools for data transformation into useful information for business analysis purposes.

In this article I want to share our experience with ETL (Extract, Transform and Load) optimization.

ETL Optimization

Extract, Transform, Load (ETL) - is the base for a data warehousing, these 3 processes manage any data warehouse. Extract - acquire data from data sources, Transform - change data in the proper formatLoad - push data to final target (data mart, data warehouse).

We were designing and implementing BI solution for insurance brokerage company Willis Towers Watson.

It was common BI architecture following all general rules:

Business Intelligence BI architecture

BI architecture

 More...