Practical SQL Server 2005 Reporting Services
on 7 Full-Motion Video & Audio CD-ROMs

 TEST DRIVE
 BUY ONLINE
 CONTACT US
 REFERENCE
 LINKS

Testimonials


 

SQLUSA.com
Search

GoogleCheckout
SAVE $10!

Invest in Your Career
Learn Reporting Services from a top industry expert. Practical SQL Server 2005 Reporting Services is now available on full-motion CD-ROMs with narration. Learn the fun way! Multimedia training is far more effective than classroom training. It simulates the real-world environment providing excellent retention. You can replay the video and audio instructional units as many times as you needed.

Learn Reporting Services 2005 with this easy-to-follow CD-ROM collection from Silico-Magnetic Intelligence. Whether you are learning Reporting Services for the first time or adding to your professional skills set, you will find that SMI’s Practical SQL Server 2005 Reporting Services Training via CD-ROM™ contains thorough, outstanding, well-prepared content that is second to none.

7 CD-ROMs with Over 18 Hours of Instruction
The instructor is Kalman Toth,  video MCDBA, MCITP, Senior SQL Server Database, Data Warehouse and Business Intelligence Architect. By mastering one CD-ROM a day, you can become an Reporting Services professional in just 7 days. You can also proceed at your own pace. The thorough CD-ROM course is focused on practical solutions to real-world report design and publishing issues. Full-motion screen video and rich audio make the subject matter understandable, and reusable as reference material.

Audience
Database developers, business intelligence developers, DBAs, software engineers, data warehouse architects, systems analysts, IT managers and project managers who design, develop, implement and manage Microsoft SQL Server 2005 based applications. Network and Database Administrator candidates, VB, Java, C++, ASP.NET and BI architects who need to know more about applying sophisticated reporting techniques in business environment.

Prerequisites
Reporting Services 2005 students must have a solid working knowledge of the Windows environment. SQL Server 2005 administration and programming experience in SQL, and the knowledge of at least one computer language are helpful. This is best SQL Server 2005 Reporting Services multimedia training currently available in North America, or anywhere in the World.

Objectives
Interactive OLAP reporting, executive dashboard & scorecard design for Enterprise Performance Management applications, and effective delivery of BI to end users though data visualization, interactivity and report linking. Report Authoring: Learn the basics of report design with table reports. Find out how to set up a data source and dataset. Make reports easy to navigate by adding drill-downs, document maps, drillthroughs. Find out how and when to create page, report, and table headers and footers. Use expressions in a variety of report design situations: aggregating data, creating conditional formatting, and adding custom fields. Explore new features such as working with expressions, multi-value drop-down report parameters, interactive sorting, and floating headers. Discover Data Regions: Learn how to use table, matrix, list, subreport, and chart data regions as well as the practical application of each for delivering Business Intelligene. Manipulating Datasets: Build parameterized reports using query parameters and filters. Discover how to use stored procedures and user defined functions to build dynamic reports. Find out how to build a report that displays recursive hierarchies. Create a report from an Analysis Services OLAP cube. Learn model design for the ad-hoc Query Builder tool. (See full list below).

About the Trainer
Kalman Toth, MCDBA, is an IT professional with over 16 years of database design, administration and development experience with SQL server 4.2, 6.5, 7.0, 2000 and 2005. Kalman Toth was a developer on IBM's marketing Data Warehouse project operated by Dun & Bradstreet. He has designed OLTP databases, OLAP data warehouses and Business Intelligence reporting solutions for major finance, online dating, health, diet and fitness ecommerce websites. His clients include: Citibank, Bank of Sweden, Deloitte-Touche, Swiss Bank, Reuters, Lehman Brothers, Salomon Brothers, Merrill Lynch, and IBM. He holds M.Phil degree in Physics and M.Phil. degree in Computing Science from Columbia University, where he had taught computer science.

CD-ROM Features
SMI's CD-based training is like training one-on-one with an expert -- full motion video allows you to see the steps, hear the explanations, and perform the critical tasks. You can pause the video at any time and practice along. This is the complete training solution for passing a certification exam, excelling on an interview and performing well in the workplace. It is convenient, giving you the freedom to learn at your own pace, wherever and whenever it suits your schedule. CD-ROM is easy to use, with streamlined interface featuring one-click navigation. 100% guaranteed.

Bonus Book 1: Microsoft SQL Server 2005 Reporting Services
SSRS enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions. Microsoft SQL Server 2005 Reporting Services will help you understand SSRS from various perspectives: How it fits business scenarios; How to install and configure Reporting Services; Reporting Services components; Developing reports
As you progress to advanced user status, you will enjoy the chapter about accessing Reporting Services programmatically and extending Reporting Services, and you will be able to use this book as a convenient reference.
Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.

Bonus Book 2: Microsoft® SQL Server™ 2005 Reporting Services Step by Step
Teach yourself the fundamentals of SQL Server Reporting Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization
Discover how to: Install and configure SSRS; Author, manage, and access reports; Create attractive, information-rich reports with the Report Designer; Calculate values, organize information, and manipulate report data; Build, deploy, and maintain a report model; Render and distribute reports in various formats; Implement role-based security to restrict access to information; Explore more advanced report design techniques; Programmatically customize any stage of the reporting lifecycle.
Your hands-on guide to learning Microsoft SQL Server Reporting Services, Microsoft's customizable reporting solution for business data analysis. SSRS is a powerful tool for business intelligence, so an understanding of the essentials-how to architect a report, as well as how to install and program Reporting Services-is key to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to use the report project wizard, how to think about and access data, and how to build queries. It also walks you through the creation of charts and visual layouts to enable maximum visual understanding of the data analysis. Interactivity features (enhanced in SQL Server 2005) and security are also covered in detail. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using Reporting Services. A companion CD includes data sets and sample code.



 
 
Multimedia Practical SQL Server 2005 Reporting Services on 7 full-motion screen image video and rich audio CD-ROMs $695.

Enlarge

Practical SQL Server 2005
Reporting Services on 7 CD-ROMs

CD-ROM 1 - BI DELIVERY (2 hours 54 minutes)
1. Welcome to SQL Server Reporting Services
2. SSRS Architecture: Tour of Features
3. Report Server Components & Operation
4. Traditional & Interactive Web-based Reports
5. RS Vital Part of MS Business Intelligence Platform
6. Reporting Services Installation & Configuration
7. Report Builder - End User Authoring Tool
8. Navigating Reporting Services Design Studio
9. Report Designer's Report Wizard
10. Data Sources: SQL Server, OLAP, & OLE DB
11. Report Layouts & Various Rendering Formats
12. Enterprise BI: Executive Scorecard & Dashboard
13. Matrix Reports for OLAP Cube Reporting
14. Business Intelligence Development Studio
15. Reporting Services Report Manager
16. SQL Server Management Studio

CD-ROM 2 -REPORTING BASICS (3 hours 1 minute)
1. BIDS Report Designer Tool
2. Developing a Reporting Solution
3. Evaluating Business Requirements
4. Designing for Reporting Services
5. Identifying Users & Preparing Specifications
6. Managing Shared & Private Data Sources
7. Designing Basic Reports from Scratch
8. Building Table Reports with Report Wizard
9. Experimenting with Formatting Options
10. Adding Table Headers and Footers
11. Adding Page Headers and Footers
12. Subtotals, Totals, Grand Totals & Formulas
13. Creating Chart Reports of Various Types
14. Lists - Free Form Data Presentation
15. Improving Usefulness with Paging & Sorting
16. Designing Reports from a Report Specification

CD-ROM 3 - FORMATTING REPORTS (2 hours 57 minutes)
1. Report Items and Graphical Elements
2. Basic Expressions & Global Collections
3. Including Custom VB Code in Reports
4. Formatting Fields & Conditional Formatting
5. Grouping, Static & Interactive Sorting
6. The Magic of Interactive Drill-Down Reports
7. Calculating Totals and Percentages
8. BI Dashboards for Data Visualization
9. Performance Management Scorecards
10. Advanced Report Features, Web Farm Deployment
11. Drill-Through Reports & Report Metadata
12. Linked Reports & Complex Expressions
13. Subreports & Report Definition Language
14. Configuring Document Maps & Bookmarks
15. Organizational Chart (Recursive) Reports
16. TOP 10 Report Formatting Tips

CD-ROM 4 - REPORT PARAMETERS (2 hours 46 minutes)
1. Creating Simple Parameter Reports
2. Binding Report Parameters to Dataset Parms
3. Setting Up Defaults & Drop-Down Parameters
4. Multivalued Parameters with Checkmark Drop-Down
5. Architecting Reports with Multi-Select Parameters
6. Designing Reports with Cascading Parameters
7. Parameters Passing in Drillthrough Reports
8. Report Parameters Dialog Box
9. Configuring Stored Procedures with Parameters
10. Configuring Functions (UDF) with Parameters
11. Debugging Reports, Troubleshooting & Error Logs
12. Enhancing Performance with Filters
13. Multiple Criterion Report Filtering
14. Filters vs. Query Parameters
15. Parameters as Interactive BI Report Features
16. Top 10 Report Parameter Tips

CD-ROM 5 - MATRIX REPORTS (2 hours 54 minutes)
1. Delivering BI with Matrix (Crosstab) Reports
2. Classifying Data into Dimensions & Measures
3. Matrix Page, Columns, Rows & Details Setup
4. Matrix Subtotals, Totals & Grand Totals
5. Applying Aggregate Functions to Measures
6. Designing Interactive Drill-Down Matrix Reports
7. Creating Basic & Complex Matrix Charts
8. Matrix Reports with Time Dimensions
9. Matrix Reports with Multi-Level Dimensions
10. Matrix Reports with Mixed Dimensions
11. Matrix Reports with Multi-Measures
12. Matrix Reports with Multi-Aggregates
13. Adding Static & Dynamic Columns and Rows
14. Architecting Drillthrough Matrix Reports
15. Matrix Reports for OLAP (AS) Cube Reporting
16. OLAP Performance Management Matrix Reports

CD-ROM 6 - PUBLISHING & MANAGING (2 hours 45 minutes)
1. SSMS Reporting Services Management
2. Deploying Reports and Data Sources
3. RS Security: Managing Roles & Data Sources
4. Setting up Folders & Permissions for Users
5. Managing with Report Manager
6. Managing with Management Studio
7. Standard & Data-Driven Subscriptions
8. Automating Report Creation and Delivery
9. Snapshot Reports & Storing Report Histories
10. Report Caching & Fast Stored Procedures
11. Rendering Reports in Excel, XML or PDF
12. Managing Reports Builds and Deployments
13. Reports, Projects, Solutions & Data Sources
14. ReportServer & ReportServerTempDB Databases
15. Managing Models Builds and Deployments
16. Publishing Report Builder Reports

CD-ROM 7 - ADVANCED REPORTING (2 hours 40 minutes)
1. Key Performance Indicators (KPIs) Reports
2. Importing Reports from Microsoft Access
3. Adding Multiple Regions to a Report
4. Nested Lists & Green Bar Reports
5. Architecting Master-Detail Business Reports
6. Building Reports on Analysis Services Cubes
7. Generating MDX Using the MDX Builder
8. Mastering OLAP Reports: Drop-Down Parameters
9. Cascading Prompts for OLAP Cube Reports
10. Report Builder Model Designer
11. Creating Reports with Report Builder
12. Deploying Report Builder to End Users
13. Infinite Drillthrough Report Builder Reports
14. SQL Query Builder & DSV (Data Source Views)
15. Designing Matrix Reports with Report Builder
16. TOP 10 Reporting Services Success Secrets


Bonus CD
CD 1 Reports
CD 2 Reports
CD 3 Reports
CD 4 Reports
CD 5 Reports
CD 6 Reports
CD 7 Reports

Availability: the product usually ships on the next business day.

 
 
 
     
  Copyright 2008, Silico-Magnetic Intelligence Corp. All Rights Reserved.  
     
  Microsoft is a trademark of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
Business Intelligence Development Studio is a program product of Microsoft Corporation