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
Microsoft SQL Server: Querying Data for Report Developers
3 Days
SQL Server Analysis Services 2014/2012 - Tabular model with DAX
3 Days
Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions
5 Days
SQL Server 2012 Business Intelligence and Data Warehouses using SSIS
5 Days
SQL Server Analysis Services 2014/2012 - Advanced Data Analysis and Optimization
3 Days
SQL Server Reporting Services 2014/2012 - Extensions and Programming
3 Days
Microsoft SQL Server 2008 Reporting Services
3 Days
SQL Server Reporting Services 2014/2012 - Jedi Master Level
2 Days

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]