MS-55124: Quick Microsoft SQL Server 2012 Reporting Services
Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.
- Course Materials
- What We'll Be Discussing
Module 2: Introduction to Microsoft SQL Server Reporting Services
Reporting 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.
- Version Changes of SSRS from 2008-2012
- Reporting Services Installation and Architecture
- Reporting Services Tools
Module 3: Building Basic Reports
In 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.
- Data Sources
- Understanding Security in Connections
- Report Items
- Report Parts
Module 4: Highlighting Basic Reports with Visualizations
Visualize 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.
- Gauges and Dashboards
- Sparklines, Data Bars, and Indicators
Module 5: Developing Advanced Reports
Looking 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.
- Conditional Formatting
Module 6: Managing and Maintaining Reporting Services
To 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.
- Deploying Reports
- Securing Content
- Viewing Reports Online
- Utilizing Subscriptions
- Data Alerts