800-413-0939

SQL Business Intelligence Training Course

SQL Server 2008 Business Intelligence Application Development (SSRS, SSIS, SSAS)

Duration: 5 Days | Price: $2595 *California residents call for pricing. | Class Dates:

Click here for information regarding remote access training.

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

Course Description: This hands on SQL Server course presents the Business Intelligence tools included in SQL Server. 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. 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 2008 Business Intelligence: Integration Services and Analysis Services rather than this course.

Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at HOTT's SQL Programming course or Microsoft Transact-SQL Programming course is highly recommended although not required.

SQL Server 2008 Business Intelligence Application Development (SSRS, SSIS, SSAS) 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
  • Using Gauges
Report Builder Utility
  • Creating and Accessing Report Models
  • Using the Report Builder
  • Filtering Data
  • Adding Expressions
  • Building a Chart Report
  • Using Report Builder 2.0 in SQL Server 2008
Automating Report Creation and Delivery
  • Creating Snapshot Reports
  • Storing Report Histories
  • Using Report Caching
  • Creating Report Subscriptions
  • Rending Reports in Excel, XML or PDF
  • Rendering Reports as Word Documents
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

Student Testimonials

"I have taken numerous Microsoft training classes but none prior from HOTT. This class by far was the best I have taken. I came out of the class with the knowledge I paid to receive."
– W.W., El Paso Energy

Multiple Training Locations - Convenience and Cost Control

Regularly Scheduled Courses in more than 75 Cities Across North America and the United Kingdom