SQL Server 2005 Business Intelligence Application Development

Hands On Technology Transfer - UK
Birmingham, Bristol, Chelmsford, Edinburgh, Glasgow, Leeds, Liverpool, London, Manchester, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Students Will Learn:Generating Reports
Customizing Reports
Rendering Reports
Automating Reports
Creating UDMs
Mining for Hidden Patterns in Data
Creating ETL Packages
Managing One-time Data Migration
Managing Security

Description: This hands on SQL Server 2005 course presents the Business Intelligence tools included in SQL Server 2005. Topics include the use of Business Intelligence Development Studio along with Integration Services, Analysis Services, and Reporting Services components of SQL Server used to develop solutions for business analysis and decision support. The extensive hands on exercises are structured to build complex skills in a very short time to address practical business problems. The course provides a thorough introduction to decision support database application development, including using use of Unified Dimensional Model (UDM), reporting tools and data integration using Extraction, Transformation and Loading tools of the Integration Services of SQL Server 2005. Students will learn how to effectively consolidate data from a variety of sources and then format the data for analysis to produce consistent and reliable information. Special emphasis is placed on generating information from raw data using Reporting Services. The impact of security policy on the Business Intelligence services is incorporated throughout the course. Students who are already familiar with Reporting Services and who wish to focus more in-depth on Integration Services and Analysis Services should attend the SQL Server 2005 Advanced Business Intelligence rather than this course.

Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at HOTT’s 3-day SQL Programming course, or equivalent knowledge, is recommended but not required.

SQL Server 2005 Business Intelligence Application Development Course Overview:
Fundamentals of Business Intelligence
OLTP vs. OLAP
Data Warehousing
Defining Archive Requirements
Identifying Key Performance Indicators
Reporting Services Architecture
Report Server Components Defined
Review of the Report Server Databases
Reporting Services Web Service Interface
Report Lifecycle

Creating Reports
Creating Table Reports
Creating Parameter Reports
Creating Matrix Reports
Formatting Options
Paging and Sorting
Drill-Through Reports
Linked Reports and Subreports
Report Builder Utility
Creating and Accessing Report Models
Using the Report Builder
Filtering Data
Adding Expressions
Building a Chart Report

Automating Report Creation and Delivery
Creating Snapshot Reports
Storing Report Histories
Using Report Caching
Creating Report Subscriptions
Rending Reports in Excel, XML or PDF
Securing SQL Server Components
Setting up Folders for Users
Setting Permissions
Creating Custom Security Roles
Securing Report Models
Securing Integration Packages
Securing Analysis Databases
Securing Subscriber Applications

Adding Custom Code
Querying SQL Server Components
Creating Custom Data Extensions
Creating Command Objects
Creating Data Reader Objects
.NET Integration with Reporting Services
Writing User-Defined Functions
Report Functions
Using Custom Functions
Referencing .NET Libraries
Creating and Building Libraries
Managing Report Servers from .NET Applications
Accessing SSRS from .NET Applications
Retrieving Report Items
Listing Report Metadata
Using the ReportViewer Control in .NET Applications

Designing Data Integration
Managing Data Flow
Migration vs. Recurring Transfers
Blocking and Logging Issues
Creating ETL Packages
Using Checkpoint Restart
Supporting XML Input
Flat File Sources and Destinations
BI Development Studio
Wizards
Creating Integration Packages
Creating Report Models
Adding Subtotals and Formulas
Managing Data Sources
Publishing Report Models
Creating OLAP Databases
Deploying Applications
Generating Report Definition Language

Data Transformation
Designing Transformations
Handling Errors
Controlling Transformation Order
Compensating for Missing Data
Cleaning Incoming Data
Merging Data from Multiple Sources
Splitting Data to Multiple Destinations
Handling Events
Types of Events
Triggered Events vs. Scheduled Events
Responding to Application Failure
Subscriber Events

Management Studio
Management Tools
Deployment Tools
Comparison to Development Studio
Analysis Server Overview
Dimensions and Facts
Cubes
External Tools
Creating Calculated Members
Identifying Key Performance Indicators
Slowly Changing Dimensions

Loading Data

Multidimensional Queries (MDX Queries)
SELECT query
WITH clause
MDX Scripts
Data Mining Algorithms
Matching Algorithms to Business Needs
Mining for Hidden Information
Data Mining Models
Discovering Patterns of Data
Creating Predictive Models

Gathering Data

Data Mining Wizard

Modifying Models with Data Mining Designer

OLAP Design
Defining Dimension Tables
Handling Slow Changing Dimensions
Summarizing OLTP Data
Using Integration Packages
Designing for Scalability
Proactive Caching

Effective Denormalization

Ensuring Data Integrity

Designing Aggregation

...''

Phone:0870 063 2964

School Address:

Hands On Technology Transfer, Inc.
The Old Post House
91 Heath Road
Weybridge Surrey
KT13 8TS UK

Jobs & Resumes: Birmingham, Bristol, Chelmsford, Edinburgh, Glasgow, Leeds, Liverpool, London, Manchester
Houses & Roommates: Birmingham, Bristol, Chelmsford, Edinburgh, Glasgow, Leeds, Liverpool, London, Manchester

Building Component Software Using COM/DCOM
Visual Basic Programming
ASP.NET 2.0 Programming Using C#
ASP.NET 2.0 Programming Using Visual Basic.NET
C# 2.0 Programming for Windows Applications
Visual Basic.NET 2.0 Programming for Windows Applications
SQL
Microsoft SQL Server 2005 Administration
Microsoft SQL Server 2005 Database Developer
SQL Server 2005 Reporting Services
SQL Server 2005 Business Intelligence: Integration Services and Analysis Services
Windows 2003 Server and XP Administration
Windows Server 2003 Active Directory

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.