Roadmap › 2. Database, ETL & BI › Step 32
RS
SSRS — SQL Server Reporting Services
Report server architecture, data sources and datasets, tablix (table/matrix/list), parameters and cascading parameters, expressions, grouping, drill-down and drill-through, subreports, charts, subscriptions, security, performance and Power BI Report Server.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: Building Reports
- 1.Data sources and datasetsBasic ★ Must know
- 2.Report items: tablix, table, matrix, list, chartsBasic ★ Must know
- 3.Grouping, sorting, totals and page breaksBasic ★ Must know
- 4.Expressions and built-in collectionsIntermediate ★ Must know
Module 2: Parameters and Interactivity
- 5.Parameters, multi-value and cascading parametersIntermediate ★ Must know
- 6.Drill-down, drill-through, subreports and document mapsIntermediate ★ Must know
Module 3: Server Features and Administration
- 7.Deployment and securityIntermediate ★ Must know
- 8.Subscriptions, caching and snapshotsIntermediate ★ Must know
- 9.Performance tuning and the execution logAdvanced Medium
- 10.SSRS vs Power BI vs Power BI Report ServerBasic Medium
Next course in the roadmap: 33. IIS — Internet Information Services and Hosting .NET Applications →