Working with SQL Server Reporting Services - Courses

Working with SQL Server Reporting Services

Choose your own date

INFORMATION COURSE OUTLINE

2-Day (COURSE-BI-REPORTINGSERVICES)

Description
Audience
Prerequisites
Course Objectives
Technologies

DescriptionWritten 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, please send an e-mail.

AudienceThe 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 Exce

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

Section D: Reporting Solutions with Reporting Services

Module D01: Introducing Reporting ServicesReporting Fundamentals; Introducing Reporting Services

Module D02: Authoring Reporting Services ReportsBasic Report Design; Introducing Report InteractivityExtending Reports with Custom Logic; Introducing Report Builder 3.0Lab D02A - Authoring Reports Based on Relational Databases, Part 1Lab D02B - Authoring Reports Based on Relational Databases, Part 2Lab D02C - Authoring Reports Based on CubesLab D02D - Authoring Reports Based on Data Mining Models

Module D03: Delivering Ad Hoc Reporting With Report Builder 1.0Developing Report Models; Introducing Report Builder 1.0Creating Reports with Report Builder 1.0Lab D03A - Developing a Report ModelLab D03B - Authoring Reports Based on Report Models

Module D04: Managing and Delivering Reporting Services ReportsOptimizing Report ExecutionSecuring Report Server Items and DataDelivering Reports with SubscriptionsLab D04A - Managing and Delivering Reports

Module D05: Programming Reporting ServicesAccessing Reports in Reporting ServicesAccessing Reports ProgrammaticallyEmbedding Reports into .NET ApplicationsLab D05A - Managing Report Content with ScriptLab D05B - Embedding Reports with the ReportViewer Control

Section E: Self-Service Business Intelligence with Office and ProClarity

Module E01: Creating and Sharing Reports with ExcelCreating Reports in ExcelPublishing to Excel ServicesLab E01A - Analyzing and Reporting with ExcelLab E01B - Working with Excel Services

Module E02: Working with PowerPivotIntroducing PowerPivotLoading Data into PowerPivotCreating PowerPivot ReportsIntroducing DAXWorking with PowerPivot in SharePointLab E02A – Creating a PowerPivot ModelLab E02B – Creating Reports Based on a PowerPivot ModelLab E02C - Enriching a PowerPivot Model with Calculations Lab E02D - Working with PowerPivot in SharePoint

Module E03: Creating SharePoint DashboardsReviewing Dashboard FundamentalsIntroducing the SharePoint BI FeaturesLab E03A - Creating a SharePoint Dashboard

Module E04: Advanced Cube Analysis with ProClarity Desktop ProfessionalIntroducing PerformancePoint Services (PPS)Building ScorecardsDefining PPS ElementsLab E04A - Creating PerformancePoint KPIs and a ScorecardLab E04B - Creating PerformancePoint Reports and Dashboards