|
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
Complete SQL Server 2005 Reporting Services video course for database developers, business intelligence developers, DBAs, and managers who design, develop, implement and manage database and OLAP reporting applications. C#, VB, Java, C++, .NET developers and BI/DW 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
Learn Table and Matrix report design, interactive OLAP reporting, executive dashboard & scorecard architecture for Enterprise Performance Management applications, and effective delivery of BI to end users though data visualization, interactivity, subreports and report linking. Report Authoring: Learn the basics of report design with Table Reports. Find out how to set up a database, Excel, OLAP Analysis Services data sources and datasets. Make reports easy to navigate by adding single-values or multi-valued prompts, adding drill-downs, document maps and 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 cascading 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 Intelligence. Manipulating Datasets; Build parameterized reports using query and stored procedure parameters and filters. Discover how to use stored procedures and user defined functions to build dynamic reports. Discover how to build a report that displays recursive hierarchies. Create a report from an Analysis Services OLAP cube. Design multi-dimensional drill-down Matrix and KPI Reports. Learn model design for the ad-hoc Query Builder tool. Master report deployment, publishing, subscription, email and shared folder distribution. (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: 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.
|