SQL Server Reporting Services (SSRS)
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
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 Formatting
- Report Headers and Report Footers
- Enterprise and Ad-hoc Reports
- Working with Aliasing & Expressions
- Queries with Many-to-Many Relations
- Enterprise Reports and Usage
- Report Formatting Styles, Syntax
- Alternate Row Colors & Expressions
Report DataSets 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
- LOOKUP Functions - Limitations
- Sub Reports and Report Actions
- Joining Rectangle & List Reports
Report Design and SubReports
- 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 & Globals
- Accessing and Controlling Reports
Report Parameters & Usage
- Report Parameters & Properties
- Dynamic Report Parameters and Filters
- Dependent Parameters & Usage
- Multi Valued Nullable Parameters
- Report Filters - Options and Types
- Toolbox Filters and Limitations
- Sub Reports and Report Actions
- Parent-Child Report Parameters
- Formatting Options & Expressions
- Report Parts and Reusability
Enterprise Reports in SSRS
- Gauge Reports, Indicator Reports
- Pie Charts, Bars and Spark Lines
- Report Testing and Auto Refresh
- Map Reports and Report Dashboads
- Multiple Chart Areas in Dashboards
- Drilldown Reports and Toggling
- Multi Toolbox Items in Reports
- Report Dashboard & Limitations
- Report Scorecards with SQL Queries
- Exporting RDL Reports in SSRS
Map Reports and Cube Reports
- Map Reports and Stored Procedures
- Indicators with Map Reports
- Designing Reports using OLAP DBs
- Identifying KPIs and Measures
- MDX Queries with Cube Reports
- MDX Filters with Sub Reports
- Scorecards with MDX and DAX
- Sub Reports versus Report Actions
- Accessing and Controlling Reports
- Tuning MDX Reports in SSRS
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
- Report Downloads and Edit Options
- Power Pivot & PowerView Addins
- Power View for RDLX Reports
- Understanding Data Models
- Tables, Charts and Data Bars
- SparkLines and Data-Mashup
- Report Builder Vs PowerView
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
Subscriptions and Report Builder
- Global and Shared Schedules
- Report Subscriptions and Advantages
- Email and Fileshare 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
Report Security and Upgrades
- Data Source Security Credentials
- Report Server Security Levels
- Security Options and Report Users
- Content Manager and My Reports
- 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
Power View with SSRS
- Managing RDL and RDLX Reports
- Comparing PowerView and Report Builder
- Drillthrough Report Management Options
- Migrating Reports with SSRS and Excel
No comments:
Post a Comment