Working with SQL Server Reporting Services 

2-Day (COURSE-BI-REPORTINGSERVICES) Description Written and presented by industry experts from SolidQ, this intensive two-day course 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 course. 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. It is also designed for any combination of end-users (power users), business analysts, and professional developers. 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 R2, the course is equally applicable to those working with SQL Server 2008 or 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 • Basic understanding of working with Microsoft Excel   Course Objectives Through interactive presentations and concrete hands-on labs, attendees will learn: How to use SQL Server 2008 R2 Reporting Services to develop predefined server-based reports that simplify access to business-critical information. How to manage, schedule and cache SQL Server 2008 R2 Reporting Services reports. How to use SQL Server 2008 Reporting Services and Report Builder to develop ad hoc relational reports that simplify access to business-critical information. How to use Microsoft Excel and Excel Services to develop ad hoc reporting solutions from data stored in SQL Server 2008 R2 data stores and data warehouses. How to use PowerPivot to load and analyse large amounts of data and to provide high quality analytical reports.  Technologies The workshop will empower developers to exploit the BI functionality in the following technologies: SQL Server 2008 R2 Database Services SQL Server 2008 R2 Reporting Services SQL Server 2008 R2 Analysis Services (OLAP and Data Mining)  Microsoft Excel     Course Outline    Day 1 Module RS201: Introducing Reporting Services Reporting fundamentals Introducing Reporting Services Basic Report Design and Delivery Deployment Scenerios LAB: Designing Reports - Managed Reports  Module RS202: Common Report Elements and Interactivity Report Project Items Common Report Elements Report Interactivity LAB: Advanced Managed Reports - Enhancing the Report Design Module RS301: Custom Logic and Reporting From Analysis Services Extending Reports with Custom Logic Reporting from Analysis Services LAB: Advanced Managed Reports - Custom Logic  LAB: UDM Reporting with Reporting Services Module RS302: Managing Report Execution Optimizing Report Execution Securing Report Server Items and Data Delivering Reports with Subscriptions LAB: Managing Report Execution Day 2 Module RS303: End-user Reporting with Report Builder 3.0 Introducing Report Builder Report Models and Report Builder 1.0 Report Builder 3.0 Publishing Shared Datasets and Report Parts LAB: Report Builder - Self Service Reporting  Module RS304: End-user Reporting with Excel and Excel Services Reporting from Excel Visualizing Data Publishing to Excel Services LAB: UDM Reporting with Excel Module RS203: Analysing Data Using PowerPivot Introducing PowerPivot Loading data into PowerPivot Preparing PowerPivot data Reporting from PowerPivot  LAB: Loading Data in PowerPivot Module RS204: Enhancing PowerPivot Models Using DAX and Publishing to SharePoint Introducing DAX Creating Calculated Columns and Measures Publishing to SharePoint LAB: Enhancing PowerPivot Models with DAX Module RS205: General Enhancements, Reports as Data Feeds, and Maps General Reporting Enhancements Using Reports as Data Sources Using Map Data in Reports