Working with SQL Server Reporting Services 

2-Day (COURSE-BI-REPORTINGSERVICES) Description Written and presented by industry experts from Solid Quality, this intensive two-day workshop gives professional developers the information and hands-on experience they need to deliver state-of-the-art, integrated reporting solutions using Microsoft Business Intelligence. Attendees will work through 9 practical hands-on labs to build a complete  solution by the end of the workshop. For details on booking courses or seminars, please visit our booking page.    Audience The presentations and labs have been designed specifically to give professional developers and database administrators—those who work for an ISV, SI, or enterprise customer—the information they need to deliver reporting solutions on the Microsoft BI platform. This course is also relevant and useful for those interested to understand and evaluate Microsoft’s Reporting Services offerings. While based on SQL Server 2008, the course is equally applicable to those working with SQL Server 2005. Differences in the versions will be highlighted.   Prerequisites The following skills and knowledge will help attendees have a positive experience in the workshop: • Basic understanding of SQL and relational database technology   Course Objectives Through interactive presentations and concrete hands-on labs, attendees will learn: How to use SQL Server 2008 Reporting Services to develop predefined and ad hoc relational reports that simplify access to business-critical information. How to publish and collaborate on a Unified Dimensional Model using SQL Server 2008 Reporting Services and Excel Services in Office SharePoint Server 2007. How to manage, schedule and cache SQL Server 2008 Reporting Services reports. Technologies The workshop will empower developers to exploit the BI functionality in the following technologies: SQL Server 2008 Database Services SQL Server 2008 Integration Services SQL Server 2008 Reporting Services SQL Server 2008 Analysis Services (OLAP and Data Mining) Office SharePoint Server 2007  While based on SQL Server 2008 versions of SQL Server, this course is highly relevant for those working on SQL Server 2005 versions as well.     Course Outline   Day 1 Module RS201: Introducing Reporting Services Introduction to SQL Server Reporting Services Designing reports LAB: Designing Reports Module RS202: Implementing Interactivity in Reports Interactivity concepts Available interactivity options for rendering targets URLs Linking to reports Bookmarks LAB: Adding Interactivity to Reports Module RS301: Enhancing Reports Through .NET Code Report code blocks Referencing .NET assemblies LAB: Enhancing Reports Through .NET Code Module RS302: Managing Reporting Services Subscribing to reports Data-driven subscriptions Caching reports Report snapshots Report security Linked reports LAB: Managing Reporting Services  Day 2 Module RS303: Implementing Report Builder Introduction to Report Builder Creating report models Authoring reports with Report Builder LAB: Implementing Report Builder Module RS304: Deploying and Linking to Reports Deploying reports Accessing reports via URLs Using reportviewer in .NET applications LAB: Deploying and Linking to Reports Module RS203: Reporting from Analysis Services Cubes Analysis Services query designer LAB: Reporting from Analysis Services Cubes Module RS204: Using Excel for Reporting Office Data Connections Connecting to Analysis Services Pivot Tables Pivot Charts Accessing Cube members LAB: Using Excel for Reporting  Module RS205: SQL Server 2008 R2 Reporting Services Enhancements General Reporting Enhancements Report Builder and Shared Components Using Reports as Data Sources Using Map Data in Reports