Intro to Reporting Services and BI Workshop
Intro to Reporting Services and Business Intelligence
Intro to Reporting Services and BI Class Overview
The goal of this 3 day, instructor-led course is to
provide you with an detail introduction to the Microsoft
Reporting Services and BI. ITM's SQL Server 2005 Reporting Services/BI training teaches attendees how to create, test and distribute SQL Server 2005 Reporting Services reports. Student will learn the usage of Microsoft DW/BI tools: Management Studio, Business Intelligence Development Studio. Students will get overview of Integration Services.
SQL Server 2005 Reporting Services/BI Training Prerequisites
All attendees should have prior experience with relational databases and writing SQL queries for SQL Server 2005.
This course will give IT Professionals a jump-start on how to install, configure, administer, use, customize and develop for Microsoft Reporting Services. It is intended for administrators, developers, Webmasters and others who need to acquire these skills.
The course teaches SSRS reports development skills by having the students work
through an report development project for a fictitious company.
The course will also focus on teaching the mechanics of installing, configuring and administering SSRS using Microsoft's virtual PC for developers in oder to acquire the required skills and the fundamentals for developing business reports with Reporting Services.
Student learning will be facilitated through a combination of instructor presentations and written lab exercises.
After completing this course, students will be able to:
- Introduction to Microsoft SQL Server Reporting Services 2005
- Understand the concepts and terminologies that are unique to Reporting Services.
- Understand the technical architecture and system requirements for SSRS.
- Install and configure SSRS and Work with the Report Wizard
- Create Reports using SQL Server 2005 Reporting Services
- Tabular reports, Headers and Footers, calculations and formatting to reports
- Grouping and sorting data within reports
- Manage, secure and deploy reports with Report Manager
- Report Delivery, distribute reports via subscriptions
-
Create new web parts, access databases from web parts, access web services from web
parts, Create Part-to-part connections
- Integrate Reporting Services into ASP.NET and Win-Forms applications using MS Visual Studio 2005
- Business Intelligence Overview, The New BI Platform
- Tour of Business Intelligence Development Studio
- Tour and overview of SQL Server 2005 Analysis Services
Agenda
Each day there will be a combination of presentations, code walk-throughs, and hands-on projects.
The final project incorporates everything we've covered during the course.
Total Cost of this individual course is $300.00 (includes code hand-outs/project).
Note: You can always “repeat” the classes you have taken earlier (provided seats are available)
Student Pre-Requisites
The technical student should be familiar with IIS. You should be
familiar with general programming in Visual Studio .NET. It is not required that you be a .NET guru, but as always the
more background you bring to the table the more you benefit. If you are not up
to speed with .NET, C#, or VB.NET, I believe you will find those sections
dealing with them fascinating, inspiring, and of course challenging.
Everything in Microsoft is evolving toward total and complete adoption of the
.NET platform and its various languages. This is an ideal place to take-a-look,
even if it’s a bit over the top for you at the moment.
