1.Introduction to SSRS & Usage
- SSRS Architecture and Tools
- Three–Phase Report Life Cycle
- Reporting Services Configurations
- Report Server Database and TempDB
- SSRS 2012 and Web Service URLs
- SSRS 2014 and Web Service URLs
- Communication Ports & Encryptions
- Execution Accounts and Usage
- Report Designer Usage and Scope
- Report Builder Usage and Scope
- Report Manager and Options
- RSCONFIG Tool and Limitations
2. Report Planning and Design
- SSRS Report Authoring Options
- Data Sources (RDS) Connections
- Credentials and Security Options
- Toolbox Items and Dataset Options
- Table Reports and Matrix Reports
- Report Images, Textbox and Globals
- Dynamic Expressions and Options
- Reporting Functions and Formats
- Report Headers and Report Footers
- Enterprise and Ad-hoc Reports
3. Report DataSets, Queries and Joins
- Working with Multiple DataSets
- Joining Local and Shared Datasets
- Configuring Dynamic DataSets
- Working with Remote Datasets
- Reusing XML and Shared Datasets
- Dataset Import Options in RDL
- Report Design and Sub Reports
- Designing Wizard based Reports
- Custom Reports and Report Groups
- Row Drilldown and Column Grouping
- Advanced and Static Options in SSRS
- Chart Based Reports and Images
- Using SSRS Expressions & Variables.
4. Report Parameters & Usage
- Report Parameters & Properties
- Dynamic Parameters & Usage
- Dependent Parameters & Usage
- Multi Valued Null Parameters
- Report Filters – Options, Reusability
- Toolbox Filters and Limitations
- Sub Reports and Report Actions
- Parent–Child Report Parameters
5. Enterprise Reports in SSRS
- Gauge Reports, Indicator Reports
- Pie Charts, Bars and Spark Lines
- Rectangle Reports and List Reports
- Report Testing and Auto Refresh
- Map Reports and Report Dashboards
- Multiple Chart Areas in Dashboards
- Report Dashboard & Limitations
- Report Scorecards with SQL Queries
- Exporting RDL Reports in SSRS
- LOOKUP Functions – Limitations
- Map Reports and Stored Procedures
- Designing Reports using OLAP DBs
- Identifying KPIs and Measures
- MDX Queries with Cube Reports
- MDX Filters with Sub Reports
6. Report Builder & Power View
- Designing DataSets in Report Builder
- Chart and Map Wizard in Report Builder
- Report Parts and Web Services
- Report Designer Vs Report Builder
- Publishing Report Parts with RB
- Stored Procedures with Report Builder
- Sparkline and Data–Mashup
- Report Builder versus Power View
- Scorecards with MDX and DAX
- Sub Reports versus Report Actions
- Accessing and Controlling Reports
- Report Downloads and Edit Options
- Power Pivot & Power View Add ins
- Power View for RDLX Reports
- Understanding Data Models
7. Report Management Options
- Report Manager Configurations
- SSRS Report Builds and Deployment
- Managing Data Source Security
- Exporting and Importing Reports
- Snapshot Management & Schedules
- ReportServerTempdb Usage & Tuning
- Linked Reports & Null Parameters
- Report Caching and Memory Refresh
- Managing Reporting Engine & Tuning
- Report Execution Audits & Events
- Tuning SSRS Reports & Memory Options
8.Subscriptions and Report Builder
- Global and Shared Schedules
- Report Subscriptions and Advantages
- Email and File Share Subscriptions
- Creating Standard Subscriptions
- Creating Data–Driven Subscriptions
- Data Source Credential Store Options
- Subscription & Logging Options
- Report Uploads and Downloads
- Report Parts and Sub Reports
- Report Sites and Parameter Options
- Report Builder Connections & Caching
- Report Builder Reports to RDL Entries
9.Report Security and Upgrades
- Data Source Security Credentials
- Report Server Security Levels
- Security Options and Report Users
- Content Manager and My Reports
- Report Browser Role Permissions
- Report Publisher Role Permissions
- Report Builder Role Permissions
- Cloning Report Roles and Schedules
- Report Browser and Report Publisher
- Report (RDL) Configuration Options
- Managing Configurations Files
- RSConfig & Encryption (snk) Keys
- SSRS Reports Upgradations
- Scale–out Deployments in SSRS
- Real–time Case Study for SSRS
10. Power View with SSRS
- Managing RDL and RDLX Reports
- Power View and Report Builder
- Drill through Report Management
- Migrating Reports with SSRS and Excel
