SQL Server Reporting Services with BI Tools Part 1 - Report Builder, Data Tools, Cubes, and Tabular Reporting

Course:  SSRS1
Duration:  5 Days
Level:  I
Course Summary

This course teaches the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. This course is designed for students who want to implement the features of Microsoft SQL Server 2012 or later that will allow them to provide quality visual reports.

« Hide The Details
Topics Covered In This Course

SSRS Overview

  • Sharing Business Intelligence
  • Report Authoring Architecture
  • Report-Serving Architecture

Report Authoring

  • Database Basics
  • Database Structure
  • Trilogy Delivery Services
  • Querying Data
  • On to the Reports

The Report Wizard

  • Obtaining the Trilogy Database
  • Getting Started with the Authoring Environment
  • Creating the First Report
  • An Interactive Table Report
  • Creating Matrix Reports
  • Report Parameters

Building Basic Reports

  • The Tablix and Data Regions
  • Graphical Reporting options

Graphic Expression: Using Charts, Images, and Gauges

  • Gauging the Results
  • Using Images
  • From Graphical to Geo-graphical

Geography Lesson: Using Maps and Spatial Data Types

  • Colors and Bubbles: Representing Quantities on Maps
  • Building Higher

Intermediate Reporting

  • Putting the Report Template to Use
  • Data Caching During Preview

Advanced Reporting

  • Speaking in Functions
  • Reports within Reports
  • Interacting with Reports
  • A Few Surprises

Warehouse Considerations

  • Overview
  • SSAS Big Picture
  • SQL Deep Dive
  • Cubes and MDX
  • Tabular models ? Small, Medium, and Large with DAX

Integrating Reporting Services

  • Using Reporting Services without the Report Manager
  • New Capabilities and Enhancements including Power View and SharePoint
  • PowerPivot into Analysis Services to Support Corporate BI Applications
  • Power View for Self-Service Business Intelligence
  • Building PowerPivot Workbooks to get the most from Power View

Best Practices

  • Report-Authoring Practices
  • Report Deployment Practices
What You Can Expect

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

  • Retrieve data with SELECT queries
  • Generate reports using the Report Wizard and from scratch
  • Enhance reports with charts, images, gauges, and maps
  • Add value to reports through summarizing, totaling, and interactivity
  • Build reusable report templates
  • Enable end-user access to reports via the Report Server and its Report Manager web interface
  • Integrate SSRS reports with personal websites and custom applications
  • Understand what is new in Microsoft SQL Server 2012 Analysis Services Tabular, Power View, and PowerPivot
  • Understand the difference between SQL (Structured Query Language), MDX (Multidimensional Expressions) , and DAX (Data Analysis Expressions)
Who Should Take This Course

This course is designed for Business professionals with no SQL experience.

Recommended Prerequisites

Basic Web and Windows usage is required.

Training Style

Instructor led with 50% lecture and50% lab.

« 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]