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



SAVE $10!

Invest in Your Career
Learn Reporting Services from a top industry expert. Practical SQL Server 2008 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 2008 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 2008 Reporting Services Training via CD-ROMô contains thorough, outstanding, well-prepared content that is second to none.

7 CD-ROMs with Over 20 Hours of Instruction
The instructor is Kalman Toth, 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.

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 2008 based applications. Network and Database Administrator candidates, C#, VB, Java, C++, ASP.NET and BI architects who need to know more about applying sophisticated reporting techniques in business environment.

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

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 2008. 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: Microsoft SQL Server 2008 Reporting Services
Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by Brian Larson, a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting Services Create SELECT queries to extract data Generate reports from the Report Wizard and from scratch Add charts, images, and gauges Build reusable report templates Use the new Tablix data format to create reports with any structure Export reports to Word, Excel, PDF, HTML, XML, and other formats Enable end-user access to reports via the Report Server and its Report Manager web interface

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


Practical SQL Server 2008
Reporting Services on 7 CD-ROMs

CD-ROM 1 - BI DELIVERY (2 hours 52 minutes)
1. Welcome to SQL Server 2008 Reporting Services
2. Enabling Enterprises to Deliver BI to All Staff
3. Reporting Services 2008 Architecture Grand Tour
4. Managing Report Server Components & Operation
5. Creating Richly Formatted Interactive Reports
6. SSRS Role in Microsoft Business Intelligence
7. Flexible Report Layout for Data Visualization
8. New & Enhanced Rendering in Word, Excel and CSV
9. Report Builder 2.0 for Business User Authoring
10. Navigating Reporting Services Design Studio
11. Creating Table Report Using the Report Wizard
12. Data Sources: OLTP/DW DB, OLAP, ODBC & OLE DB
13. Executive BI: Performance Management Metrics
14. Designing Matrix Reports using AS OLAP Cubes
15. Business Intelligence Development Studio Tour
16. Exploring Reporting Services Report Manager

CD-ROM 2 -REPORTING BASICS (3 hours 8 minutes)
1. Introduction to the BIDS Report Designer Tool
2. Developing Enterprise Reporting Solutions
3. Evaluating Critical Business Requirements
4. Reporting Services Design Concepts
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. Changing Font, Size and Color Options
10. Number, Currency, Date & Time Formats
11. Adding Table & Page Headers and Footers
12. Subtotals, Totals, Grand Totals & Formulas
13. Architecting Chart and Gauge Reports
14. Discovering List - Free Form Data Presentation
15. Improving Usefulness with Paging & Sorting
16. Reviewing the Structure of Tablix Data Region

CD-ROM 3 - FORMATTING REPORTS (3 hours 1 minute)
1. Exploring Report Items and Graphical Elements
2. Learning Basic Expressions & Global Collections
3. Including Custom Visual Basic Code in Reports
4. Formatting Fields and Conditional Formatting
5. Data Grouping, Static & Interactive Sorting
6. The Magic of Interactive Drill-Down Reports
7. Calculating Percentages ,Totals & Aggregates
8. BI Dashboards for Data Visualization
9. Corporate 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 Layout & Formatting Tips

CD-ROM 4 - REPORT PARAMETERS (3 hours 9 minutes)
1. Creating Simple Reports with Parameters
2. Binding Report Parameters to Dataset Parms
3. Setting Up Defaults & Drop-Down Parameters
4. Multivalued Parameter with Checkmark Drop-Down
5. Architecting Reports with Multi-Select Parameters
6. Designing Reports with Cascading Parameters
7. Parameters Passing in Drillthrough Reports
8. Exploring the 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 Dataset Filters
13. Learning Multiple Criterion Report Filtering
14. Comparing Filters vs. Query Parameters
15. Parameters as Interactive BI Report Features
16. Top 10 SSRS Report Parameter Tips

CD-ROM 5 - MATRIX REPORTS (3 hours 4 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. Exploring Matrix Charts & Parameterized Charts
8. Additive, Semi-Additive & Non-Additive Measures
9. Matrix Reports with Multi-Measures & Parameters
10. Time, Date & Other Multi-Level Dimensions
11. Matrix Reports with Mixed Dimensions
12. Matrix Reports with Multiple 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 42 minutes)
1. SSMS Reporting Services Management
2. Deploying Reports and Data Sources
3. Reporting Services Configuration Manager
4. Scheduled E-Mail Distribution of Reports
5. Scheduled Windows File Share Distribution
6. Configuring Data-Driven Subscriptions
7. Managing & Administering with Report Manager
8. Exception Handling - Catching Errors
9. Snapshots of Reports & Reports Histories
10. Report Caching & Optimized Stored Procedures
11. Automating BI Reports Execution & Delivery
12. Rendering in Excel, CSV, Word, XML, HTML & PDF
13. Reports, Projects, Solutions & Data Sources
14. ReportServer & ReportServerTempDB Databases
15. Importing Reports from Microsoft Access
16. TOP 10 Reporting Services Success Secrets

CD-ROM 7 - REPORT BUILDER 2.0 (3 hours 2 minutes)
1. Intuitive Report Authoring - Report Builder 2.0
2. DW Concepts - Dimension, Measure & Hierarchy
3. Exploring Aggregate Functions on Measures
4. The Architecture of a Matrix (Crosstab) Report
5. Designing Table Reports from OLTP Database
6. Designing Matrix Reports from Data Warehouse DB
7. Report Design from Multidimensional OLAP Cubes
8. Designing Reports with Parameters
9. Drop-Down Singlevalued & Multivalued Parameters
10. Adding Multiple Regions to a Report
11. Designing Reports with Charts
12. Designing Hierarchical Drill-Down Reports
13. Designing Master-Detail Drillthrough Reports
14. Key Performance Indicators (KPIs) Reports
15. Designing Reports from Stored Procedures
16. Publishing & Administering Reports

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.


The future is just a click away! Your future!

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