A common challenge for most businesses today is to convert raw data into meaningful information. Data is often stored in a number of different systems and the management of consolidated reports can be very complicated and time consuming. The introduction of SQL Server Reporting Services 2008 R2 using the SharePoint 2010 add-in with the free Report Builder 3.0 authoring tool, provides an excellent and easy to use “No Programming” solution for your business reporting needs.
The Reporting Services and Report Builder help build next-generation of meaningful, interactive, flexible reports that are easily managed and rendered in your SharePoint 2010 environment. This course covers topics that provide you with the essential skills required to unlock your data and facilitate sharing valuable information with your end-users.
| Target Audiences: SharePoint Site Administrators, Power Users, Reporting Analysts, Developers, IT Professionals
|
 Content Author: Bruce Herz |
| SP 302 – Build Dashboards and Report on your SharePoint Data using SQL Reporting Services 2008 R2 | |||
|---|---|---|---|
| Level: Advanced Available on dvd Approx Time: 2.5 hrs | |||
| Title | Abstract | Duration (mm:ss) | |
| Introduction to SQL Reporting Services 2008 R2 and Report Builder 3.0 | In this video, you will get an overview of SQL Reporting Services 2008 R2 and the various Report Authoring tools that are available. You will learn how SharePoint 2010 can be integrated with Reporting Services. Also, you will be introduced to Report Builder 3.0, which is a free authoring tool, to create powerful no-code solutions, all managed and rendered using SharePoint 2010. | 17:51 | |
| Installing SQL 2008 Reporting Services R2 Add-in for SharePoint 2010 | In this video we will cover the basic steps required to verify and /or install SQL Server 2008 R2 Reporting Services Add-in for SharePoint 2010 and configure a Site Collection to create and manage reports using Report Builder 3.0 as a Click-Once application. | 8:33 | |
| Report Builder 3.0 Design Concepts and Creating Shared Data Sources and Data Sets | In this video you will learn some basic report authoring concepts and techniques. You will learn how to create shared Data Sources and Data Sets and use them in new report. | 10:27 | |
| Working with Report Parts and Datasets | Learn how to take advantage of parts of exiting report by publishing a Report Part to SharePoint and reusing them in multiple reports. | 9:22 | |
| Introduction to Tablix Data Regions | This is an introduction to the New to Tablix data region in Reporting Services 2008. It combines the features of Tables, matrices, and lists. | 3:47 | |
| Tablix – Table Template | Learn how to create a Tablix Table from a blank template and add a row group to create a new stepped report. Also, control report headers by keeping them visible when scrolling through or printing a report. | 13:24 | |
| Report Parameters | Report parameters lets you control report data and connect related reports together. You will learn how to use parameters effectively to control the report appearance and to filter report data. | 17:14 | |
| Report Expressions | Expressions are used throughout the report definition to specify or calculate values for parameters, queries and filters. Learn how to build your own expressions to create a dynamic report. | 12:48 | |
| Sparklines and Databars | Learn how and when to use these small simple trend charts that graphically display aggregated information in a small space. | 10:47 | |
| Gauges and Indicators | The gauges and indicator data region are graphical representations of a single value in your dataset. Learn how and when to use a gauge or an indicator. | 13:35 | |
| Drill -Down, Drill-Through and Sub-reports | Learn how and when you should use Drill -Down, Drill-Through and Sub-reports. Each organizes data in a variety of ways to show the relationship of the general to the detailed information. | 12:19 | |
| Report Charts | Use Report Charts when you want to summarize data in a visual format. See how to insert some of the most common types into an existing report and learn some helpful formatting tips. | 12:45 | |
| Report Maps | Report Builder 3.0 provides an easy to use wizard to display your business data against a geographical background. Once the map is created, learn how customize it by modifying its properties and adding additional layers. | 12:52 | |