|
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.
|
