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
On our website at:   http://www.verhoef-training.com/courses/SSRS2.html
 
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.

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:

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.

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.