BI Analytics

 SSRS SSRS Data Sources and Datasets New Project New Report Shared Data Source Shared Dataset Embedded DataSource Embedded Dataset Combine two datasets SSRS Basic Reports Table Report Matrix Report Create a Report using SQL Views Create a Report using SQL Stored Procedure Display Image in Report Add Text Box to Report Rectangle in a Report List Report SSRS Report Formatting Grouping in Table Report Row Groups & Column Groups in Matrix Report Add Totals, and Subtotals to Reports Add, Or Remove Headers and Footers on Reports Global Variables to Report Export Reports to PDF, XML, Excel, Word Format Table Report Change Font and Background Color of a Text Box Format Numbers in a Text Box Format Date and Time in a Report Repeat Headers on Each Page Headers Visible While Scrolling Filters at Tablix Level Filters at Dataset Level Sorting Data at Tablix Level Interactive Sorting Add Alternative Row Color to Report Add Row Numbers to Report SSRS Charts Area Chart Bubble Chart Column Char...

SSRS   Data Source  To establish the connection between reporting platforms and the data sources. It has 2 types Shared data source and normal data source(private)  Shared data source:  It is a public connection string. we can reuse the same data source on multiple reports in the entire project If we made any changes in the connection string It automatically reflects everywhere. It is used in real-time for multiple reports  Normal data source: 28/05 Drill through action Used to navigate between the reports We need to pass the parameters to it Just create a normal report and group any column and then remove the rows by making it to show only subtotals(just remove those rows by selecting it) It shows only the grouped column names and subtotal values. Next, create a details report by taking another new report in that you need to pass at least one parameter  Select * from a test where place=@place Now right click on the column (1nd report drill_through summary)...