The integration of SSRS and Power BI

The integration of SSRS and Power BI creates a single portal to access all reporting items; which would be from Power BI dashboard.

For using this functionality, some requirements need to be met. You have to use SQL Server 2016 or higher version. Your dataset of the report should be using saved credentials. SSRS report should have charts, gauges, or maps, because only charts, gauges, and maps can be pinned to the dashboard. Power BI Integration in the reporting services configuration manager should be enabled. And finally; SQL Server agent should be up and running because Agent is responsible for keeping that tile up to date.

Using the integration of SSRS and Power BI; you can have tiles in Power BI dashboard which points to SSRS reports for the detailed paginated report. Power BI users will use normal tiles for interactive reports, and they can use SSRS tiles when they want to see the more detailed paginated report in SSRS.

Microsoft BI Tools Snapshot

2

  •  SQL Server Management Studio (SSMS)

-Manage database schema
– Write & execute queries
– Stored Procedures

  • SQL Server Integration Services (SSIS)

– Extract, Transform and Load (ETL) data
– Updating data warehouses
– Cleaning and mining data
– Creating “packages”
– A series of tasks of manipulating the input data
– Can take a variety of sources
–  XML, flat files, relational data sources

  • SQL Server Analysis Services (SSAS)

– Design, create and manage multidimensional structures with
data that is aggregated from multiple sources
– Data cubes
-Analysis by data mining

  • SQL Server Reporting Services (SSRS)

– Server-based reporting platform
– Publish reports to a report server, or Microsoft Windows application or to a Sharepoint site.
– Can schedule reports to run
– Users can subscribe to reports
– Reports (.rdl files) can be exported to a variety of formats
– Excel, PDF, CSV, XML, Word

Study Notes: Busniess Intellengence (B.I.)

What is Business Intelligence?

Business intelligence is used for transforming raw data into meaningful information for analysis through techniques and tools such as MSS, Data Warehousing, OLAP, Data Mining, either individually or in the combination.

Diagram: BI through DW, OLAP & DM

Picture1

How does it work?

  •  Once raw data is gathered, data engineers/analysts or BI developers use  ETL (Extract Transform Load) tool to manipulate, transform, and classify the data in a structured database
  • The structured databases are so-called data warehouses or data marts, where business owners and decision makers can access business data and use them to solve their business problems.
  •  BI developers/analysts can use the data visualization tools (eg. Power BI) to summarize the results on visual dashboards, making such information accessible to various stakeholders. It helps users analyze past performances and adapt future strategy in light of a specific goal. Such as: what does the data say about my latest sales performances, and how can I improve them? Is the data revealing increased ROI from my advertising investments? etc.

Microsoft BI-related Products:

• SQL Server Management Studio (SSMS)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• SQL Server Reporting Services (SSRS)
– Report Builder
• Power BI
•SQL Server Visual Studio

Reference: 
- Dr Ami Peiris, Infosys330 lecture notes, The University of Auckland
- Hugo Le Squeren, retrived from: https://blog.dataiku.com/2015/05/27/what-is-the-difference-between-business-intelligence-and-data-science