MSBI SSRS Course Content
Introduction to SSRS
Get introduced to the SSRS Architecture, components of SSRS Report Building tool, learning about the data flow in different components.
Matrix and Tablix Overview
Understanding the concepts of Matrix and Tablix, working with Text Box, learning about formatting, row/column grouping, understanding sorting, formatting, concepts of Header, Footer, Totals, Subtotals and Page Breaks.
Parameters and Expression
Learning about Parameters, filter and visibility expression, understanding drill-through and drill-down, defining variables, custom code.
Reports and Charts creation
Introduction to various aspects of Bar Chart, Line Chart, Combination Chart, Shape Chart, Sub Reports
Learn how to build a Dashboard with Sparklines, Data Bars, Map Charts, Gauge Charts and drilling into reports, the basics of ad hoc reporting.Data Bar, Sparkline, Indicator, Gauge Chart, Map Chart, Report Drilling, What is Ad hoc reporting?
Reports and Authenticity
Understanding Report Cache, Authorization, Authentication and Report Snapshot, learning about Subscriptions and Site Security.
Project – Building DashboardData – SalesTopics– In this project you will be working on SQL Server Reporting Services (SSRS) and deploying it for building dashboards in a business environment. The Business Intelligence Report that you create will be used to calculate sales based on the years and currencies that you choose. Some of the tasks that you will be performing as part of this project are – design and create Gauge and Map Charts, Sparklines and Data Bar and perform drill-through Reports, and ad hoc Reporting.