Quick Microsoft SQL Server 2012 Reporting Services Training Course

Course 551242 Days

Course OverviewThis fast-paced two-day instructor-led course 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.

Lab : Course OverviewAfter completing this module, students will be able to:

Successfully log into their virtual machine.

Have a full understanding of what the course intends to cover.

Module 2: Introduction to Microsoft SQL Server Reporting ServicesReporting Services is a report design and enterprise-class information delivery tool. In this module, we will explore the version changes, installation, architecture and tools for Reporting Services.Lessons

Version Changes of SSRS from 2008-2012

Reporting Services Installation and Architecture

Reporting Services Tools

Lab : Introduction to Microsoft SQL Server Reporting Services

Reporting Services Tools

After completing this module, students will be able to:

Understand version changes of SSRS from 2008-2012.

Understand Reporting Services installation and architecture.

Understand and utilize Reporting Services tools.

Module 3: Building Basic ReportsIn this module, we begin building reports using the basics. We will explore the wizards available and then cover tables, matrices, and lists while demonstrating how to use each of them. Finally, we will take a look at the report items available to help design the report.Lessons

Wizards

Data Sources

Datasets

Understanding Security in Connections

Tables

Matrix

List

Report Items

Report Parts

Lab : Building Basic Reports

Wizards

Data Source Connections

Data Sources

Datasets

Tables

Matrix

List

Report Parts

Concept Reinforcement Scenario 1

After completing this module, students will be able to:

Understand and utilize Wizards.

Create and configure data sources.

Create and configure datasets.

Understand security in connections.

Create and configure Tables.

Create and configure Matrices.

Create and configure Lists.

Understand and utilize Report Items.

Understand and utilize Report Parts.

Module 4: Highlighting Basic Reports with VisualizationsVisualize and present your data using visualizations. In this module, we cover the visualizations available, while demonstrating each, so you can see for yourself just how captivating data can be.Lessons

Charts

Gauges and Dashboards

Maps

Sparklines, Data Bars, and Indicators

Lab : Highlighting Basic Reports with Visualizations

Charts

Gauges

Maps

Data Bars and Sparklines

Concept Reinforcement Scenario 2

After completing this module, students will be able to:

Understand and utilize Charts.

Understand and utilize Gauges.

Understand Dashboards.

Understand and utilize Maps.

Understand and utilize Data Bars.

Understand and utilize Sparklines.

Understand Key Performance Indicators.

Module 5: Developing Advanced ReportsLooking to take reporting to the next level? Then look no further. In this module, we cover what you’ll need to create advanced reports with features such as conditional formatting and interactivity just to name a few.Lessons

Expressions

Functions

Interactivity

Parameters

Conditional Formatting

Templates

Subreports

Lab : Developing Advanced Reports

Expressions and Functions

Parameters Using Two Datasets

Query Parameters

Fixed Parameters

Conditional Formatting

Subreports

Concept Reinforcement Scenario 3

After completing this module, students will be able to:

Understand and utilize Expressions.

Understand and utilize Functions.

Understand and utilize Interactivity.

Understand and utilize Parameters.

Understand and utilize Conditional Formatting.

Understand Templates.

Understand and utilize Subreports.

Module 6: Managing and Maintaining Reporting ServicesTo share your report, you need to publish or deploy it to a report server or SharePoint site. In this module, we explain deployment options and follow with an explanation on security and administrative tasks.Lessons