Quick Microsoft SQL Server 2012-2014 Reporting Service

This fast-paced two-day Quick Microsoft SQL Server 2012-2014 Reporting Service training class is intended for IT professionals who are interested in quickly learning how to use the Reporting Services development tools to create reports. This course also covers how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

This course is intended for SQL professionals, Microsoft Reporting Services administrators and report developers, and business intelligence professionals.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Goals
  1. Understand version changes of SSRS from 2008-2012.
  2. Understand Reporting Services installation and architecture.
  3. Understand and utilize Reporting Services tools.
  4. Understand and utilize Wizards.
  5. Create and configure data sources.
  6. Create and configure datasets.
  7. Understand security in connections.
  8. Create and configure Tables.
  9. Create and configure Matrices.
  10. Create and configure Lists.
  11. Understand and utilize Report Items.
  12. Understand and utilize Report Parts.
  13. Understand and utilize Charts.
  14. Understand and utilize Gauges.
  15. Understand Dashboards.
  16. Understand and utilize Maps.
  17. Understand and utilize Data Bars.
  18. Understand and utilize Sparklines.
  19. Understand Key Performance Indicators.
  20. Understand and utilize Expressions.
  21. Understand and utilize Functions.
  22. Understand and utilize Interactivity.
  23. Understand and utilize Parameters.
  24. Understand and utilize Conditional Formatting.
  25. Understand Templates.
  26. Understand and utilize Subreports.
  27. Deploy reports.
  28. Secure and manage content.
  29. Understand and utilize Caching.
  30. Understand and utilize Snapshots.
  31. Understand and utilize Report History.
  32. Understand how to complete other administrative tasks.
Outline
  1. Course Overview
    1. Introduction
    2. Course Materials
    3. Facilities
    4. Prerequisites
    5. What We'll Be Discussing
    6. Lab 1: Course Overview
  2. Introduction to Microsoft SQL Server Reporting Services
    1. Version Changes of SSRS from 2008-2012
    2. Reporting Services Installation and Architecture
    3. Reporting Services Tools
    4. Lab 1: Introduction to Microsoft SQL Server Reporting Services
      1. Reporting Services Tools
  3. Building Basic Reports
    1. Wizards
    2. Data Sources
    3. Datasets
    4. Understanding Security in Connections
    5. Tables
    6. Matrix
    7. List
    8. Report Items
    9. Report Parts
    10. Lab 1: Building Basic Reports
      1. Wizards
      2. Data Source Connections
      3. Data Sources
      4. Datasets
      5. Tables
      6. Matrix
      7. List
      8. Report Parts
      9. Concept Reinforcement Scenario 1
  4. Highlighting Basic Reports with Visualizations
    1. Charts
    2. Gauges and Dashboards
    3. Maps
    4. Sparklines, Data Bars, and Indicators
    5. Lab 1: Highlighting Basic Reports with Visualizations
      1. Charts
      2. Gauges
      3. Maps
      4. Data Bars and Sparklines
      5. Concept Reinforcement Scenario 2
  5. Developing Advanced Reports
    1. Expressions
    2. Functions
    3. Interactivity
    4. Parameters
    5. Conditional Formatting
    6. Templates
    7. Subreports
    8. Lab 1: Developing Advanced Reports
      1. Expressions and Functions
      2. Parameters Using Two Datasets
      3. Query Parameters
      4. Fixed Parameters
      5. Conditional Formatting
      6. Subreports
      7. Concept Reinforcement Scenario 3
  6. Managing and Maintaining Reporting Services
    1. Deploying Reports
    2. Securing Content
    3. Caching
    4. Snapshots
    5. History
    6. Viewing Reports Online
    7. Utilizing Subscriptions
    8. Data Alerts
    9. Lab 1: Managing and Maintaining Reporting Services
      1. Deployment Properties with SQL Server Data Tools
      2. Report Builder 3.0 Deployment
      3. Reporting Services Roles
      4. Caching
      5. Snapshots and History
      6. Shared Schedule
      7. Subscriptions
      8. Concept Reinforcement Scenario 4
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

Great practical examples by the instructor to help with real life use. This course/class will definitely get me off the ground and headed in the direction I want to go with web design.
Dennis Renfroe
n/a
Great experience with Webucator. This was my first online class and I will be signing up for more.
Erin Herndon
EHL Insurance
Great class and great instructors!!!
Harmony Corriveau
Gentex Optics
My instructor was fantastic. First of all, he has a great on-line presence and voice that kept my attention for 4 plus days. Secondly, his knowledge is vast, and I knew I was learning from an expert. He convinced me of the importance of what I was learning and also gave me the tools I needed to continue building upon these skills after the class. I feel more confident that I can learn and figure out what I need in this rapidly changing world of technology. I also appreciated the step by step lecture and lab information in the Webucator books. Very helpful for confidence building. Thank you.
Stacey Streseman
Heller Consulting, Inc.

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

62,706

Students who have taken Instructor-led Training

11,846

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 29,525 reviews

Contact Us or call 1-877-932-8228