|
|
|
You Will Learn How To
- Leverage SQL Server 2008 Reporting Services to extract business intelligence from your data
- Design reports and display your data graphically with enhanced visualization features
- Integrate parameters, filters and interactive components into report design
- Deploy and deliver relevant reports across the entire enterprise through Report Server and SharePoint
- Safeguard reports with Windows Authentication
- Easily create reports on demand with Model Designer and Report Builder
Course Benefits SQL Server 2008 Reporting Services meets demanding requirements by providing a powerful and versatile reporting platform of data on SQL Server, Oracle or any other database system. In this course, you learn how to glean business intelligence from your data. In addition, you gain the knowledge and skills to produce compelling reports with enhanced visualization features and deliver the reports through organization portals.
Who Should Attend Those designing, creating or delivering reports from relational databases with SQL Server 2008. Previous exposure to any database system or spreadsheet data is assumed.
Hands-On Training Throughout this course, you gain extensive experience creating and managing reports using Reporting Services. Exercises include:
- Producing customized reports with expressions
- Employing Tablix to produce new report formats
- Leveraging advanced reporting charts
- Creating cached instances, snapshots and subscriptions
- Deploying reports to the Report Server
- Configuring and testing security on report items
- Creating report models to empower users with ad hoc reporting
Course 140 Content Introduction to SQL Server 2008 Reporting Services
- Identifying deployment: native, integrated or single server
- Managing web farm deployment with/without SharePoint
Developing Reports
Designing fundamental reports
- Connecting to relational and multidimensional data sources
- Generating a Tablix reporting structure
- Building an interactive chart
- Creating reports with richly formatted text
Composing expressions
- Computing custom fields
- Linking expressions to properties
- Employing conditional formatting
Arranging and sorting data
- Multiple-level grouping and categorizing the results
- Applying aggregate functions
Producing various outputs from a Tablix
- Creating parallel dynamic groups report formats
- Combining dynamic and static columns
Integrating Parameters and Filters
Incorporating parameters into reports
- Yielding subsets of data with query parameters
- Aligning report parameters to query parameters
- Constructing cascading report parameters
- Transmitting parameters to stored procedures
- Handling multivalued parameters
Applying filters to report data
- Augmenting performance with filters
- Determining filters vs. query parameters
Implementing Interactive Features
Combining multiple data regions in one report
- Applying sequential and nested regions
- Creating master/detail reports and linking subreports
Executing advanced data visualizations
- Applying the radial and linear gauge
- Customizing charts with scale breaks
- Charting KPIs from Analysis Services
Showing robust data with relevant detail
- Drilling through report detail and drilling down report data
- Navigating reports with document maps
- Reporting with hierarchical rows and dynamic headers
Deploying and Delivering Reports
Deploying reports to the server
- Publishing reports and configuring project properties
- Verifying results with Report Manager
Identifying delivery options
- Electing on demand or via subscription
- Enhancing performance with cached instances and snapshots
- Configuring snapshot history
- Formatting different outputs
Dispatching subscription reports
- Publishing reports via e-mail and fileshare
- Seamlessly delivering reports by data-driven subscriptions
Integrating reports with SharePoint
- Deploying reports to SharePoint
- Viewing results in Report Center and Data Connections libraries
Safeguarding Reporting Services
Structuring content security
- Leveraging existing Windows authentication
- Establishing permission levels on report items
Ensuring the RS system
- Instituting varying levels of administrative roles
- Granting and revoking system-level permissions
Empowering Users with Ad Hoc Reporting
Designing models for users
- Building personalized reports with Model Designer
- Defining data source views
- Creating and refining models
Designing reports with Report Builder
- Improving data visualization with sparklines, data bars, maps and indicators
- Dragging and dropping entities onto charts and tabular reports
- Exploiting Analysis Services cubes as report models
Delivering Reports to Users
- Accessing and controlling reports using URLs
- Leveraging RS Web services
- Embedding reports in applications with the Report Viewer
- Delivering reports through SharePoint
|
<< Back to Visual Studio and .NET Course List
Related Courses
SQL Server is a registered trademark of Microsoft Corporation.
|
|

Course Dates | Oct 19 - 22 | Toronto enrol | | Feb 1 - 4 | Ottawa enrol | | Mar 1 - 4 | Toronto enrol | | Jul 5 - 8 | Toronto enrol | | Aug 9 - 12 | Ottawa enrol | US Dates | | Sep 28 - Oct 1 | Reston, VA enrol | | Oct 26 - 29 | Atlanta enrol | | Nov 2 - 5 | N. New Jersey enrol | | Nov 9 - 12 | Rockville, MD enrol | | Nov 16 - 19 | New York enrol |
Attend highlighted events
in person or
online with Learning Tree AnyWareTM.
More Dates and Locations.
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customized for your organization.
|
|
|
Course participants configuring drill-down architecture on a report.
|
The most recent 100 evaluations scored this course:  |  | (3.65/4.00) |
|
|
"Just in the first week back from the Learning Tree Course, I was able to apply my new skills. I could never have gained the expertise I needed without having taken that class."
– M. Altemus Aqua Pennsylvania
|
 |
|
|