SQL Server Reporting Services with BI Tools Part 2 - Report Server Admin, Extensive Tabular Modeling/Reporting, and C#/VB Extensions

Course: SSRS2

Duration: 5 Days

Level: II

Course Summary

This course teaches the complex reporting options in SSRS and relative SSAS/SSIS environments. Students with a desire to leverage a variety of Microsoft languages will benefit from this course. Business Intelligence and Data Analytics are integrated into each section. Industry examples and exercises are used to prepare the student to be immediately productive after the class. Students are urged to bring their production requirements to class for review and practice.

« Hide The Details

Topics Covered In This Course

SRS Review

Developing Business Intelligence Solutions
Report Internal Architecture
SSAS/SSIS Architecture

Installing Reporting Services

Preparing for the Installation
The Installation Process
Common Installation Issues

The Report Manager

Folders
Moving Reports and Supporting Files to the Report Server
Managing Items in Folders
Search and Find Functions
Report Output Formats
Managing Reports on the Report Server
Roles

Report Delivery

Caching
Report Snapshots
Cache Refresh Options
Report History
Subscriptions
Site Settings

SSAS/SSIS Considerations

Modeling Basics
Structure Differences
Hierarchies, Aggregates, and KPIs
Data Quality Reporting
Master Data Reports

Data Tools and Beyond

Solutions
Projects
Extending Reporting Services
Destinations
Extending SharePoint
Web Service Considerations
Best Practices
Troubleshooting

Modeling for Analytics

Dimensional Modeling
Cube Deliverables
Tabular Design
Creating Small, Medium, and Large Tabular Models
Deployment Options
Refresh Considerations
Performance and Tuning

Extended Analytics Reporting

Advanced Defined
Beyond Generated MDX
DAX Deep Dive
Industrial Strength Reporting
Speaking in Code

Pushing the Limits

Leveraging complex SQL
Calendar Reporting with Functions or Dimensions
Stored Procedures
Common Table Expressions

Data Mining Reporting (if time allows)

Using Table Analysis Tools
Creating a Data Mining Model
Using the Data Mining Add-in for Excel
Validating Data Mining Models
Using a Data Mining Model in a Report

What You Can Expect

t the end of this course, students will be able to:

Install and Manage Native Reporting Services
Understand Dimensional Modeling
Design, Deploy, and Report Tabular Models
Create and Deploy C# and VB.NET SSRS extensions
Leverage Data Quality and Master Data Services
Visualize reports on SharePoint pages
Create and Tune more complex Reports
Use SQL, MDX, and DMX beyond the basics
Apply Data Mining Design and Reporting Techniques
Create KPIs

Who Should Take This Course

This course is designed for Business professionals who have taken Part 1 or equivalent experience.

Recommended Prerequisites

Querying with Transact-SQL

Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)

Some exposure to basic programming constructs (such as looping and branching)

An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable

Training Style

Instructor led with 50% lecture and50% lab. Boot camp exercises.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
SSQFD	Microsoft SQL Server: Querying Data for Report Developers	3 Days	I	Details
SSASTM	SQL Server Analysis Services 2014/2012 - Tabular model with DAX	3 Days	I	Details
SSASBI	Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions	5 Days	I	Details
SSIS	SQL Server 2012 Business Intelligence and Data Warehouses using SSIS	5 Days	I	Details
SSASAO	SQL Server Analysis Services 2014/2012 - Advanced Data Analysis and Optimization	3 Days	II	Details
SSRSXP	SQL Server Reporting Services 2014/2012 - Extensions and Programming	3 Days	II	Details
SSRPT	Microsoft SQL Server 2008 Reporting Services	3 Days	II	Details
SSRSJM	SQL Server Reporting Services 2014/2012 - Jedi Master Level	2 Days	III	Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]