MBSI Microsoft Business Intelligence course for beginners by enosis learning

Introducing to SQL Server Reporting Services
Architecture of SQL Server Reporting Services
Components behind SQL Server Reporting Services
Creating a basic report using the SQL Server Reporting Services Wizard

Creating Tabular and List Reports
Learn how to create a tabular report from scratch
Learn about datasets and data regions
Discover how to add controls to reports

Calculations and Formatting
Creating expressions in reports
Creating Custom functions using the Code window
Discover the Various global collections that you can reference in your expressions
Formatting report items using formatting toolbars, the Properties window, and the Textbox Properties dialog box
Find out how you can use conditional formatting to make your reports more dynamic

Grouping and Sorting
Explore creating groups
Learn how to calculate group totals and percentages Understand scope as it applies to aggregate functions
Discover interactive sorting
Creating drill-down reports

Working with Parameters
Understanding how Reporting Services parameters work with stored procedure parameters
Learn how to create parameters in ad-hoc SQL
Displaying parameter values in report headers

Creating Matrix Reports and Charts
Learn how to create matrix reports
Charts in Reporting Services
Working with Different types of charts
Use of Reporting Services gauges
Managing Reporting Services
Plan and configuring for deployment
Deploying Reporting Services projects and individual reports and data sources
Exporting reports to a variety of formats
Managing Reporting Services projects using Report Manager
Programming Reporting Services
Exploring application programming interfaces of Reporting Services
Using URL to integrate Reporting Services reports into your applications
Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place
Exploring the Report Views controls in local mode to display reports that don t involve Reporting Services