New England Training Solutions

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

Length: 5 Days Price: Contact NETS for pricing.

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.

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

SQL Server 2008 Business Intelligence Application Development (SSRS, SSIS, SSAS) Training Overview
  • Business Intelligence Suite Architecture
  • SSRS Fundamentals
  • Learning to Install and Configure SSRS
  • Creating Reports
  • Assigning Data to Table Cells
  • Implementing Conditional Formatting
  • Using Aggregate Functions and Global Variables
  • Rectangle, List and Table Comparison
  • Linking Embedded Lists
  • Writing Custom Functions
  • Referencing .NET Libraries
  • Passing Parameters to Stored Procedures
  • Configuring Interactive Sorting
  • Deploying and Using Report Models
  • SSRS Security Overview
  • Reporting Services Integration
  • Accessing SSRS from .NET Applications
  • Using the ReportViewer Control in ASP.NET Applications
  • Designing OLAP Databases and Cubes
  • Understanding Data Warehouses
  • Creating Time Dimension Tables
  • Unified Dimensional Model (UDM)
  • Multidimensional Expressions (MDX)
  • Enhancing and Customizing Cubes
  • Writing MDX Queries
  • Using Key Performance Indicators (KPIs)
  • Perspectives, Translations and Actions
  • Creating a Data Mining Model
  • SSAS Administration and Integration
  • SSIS Fundamentals
  • Extraction, Transformation and Loading
  • SSIS Packages and Components
  • SSIS Package Designer
  • Executing Packages in BIDS
  • Creating and Designing SSIS Packages
  • Defining a Shared Data Source
  • Common Control Flow Tasks
  • Database Object Transfer Tasks
  • Using the Data Flow Task
  • Defining a Data Destination
  • Advanced SSIS Features
  • Analysis Services Transformations
  • Transformations to Split Data
  • Variables and Events
  • Securing and Deploying Packages
  • Scheduling SSIS Package Execution
  • Setting Up Logging and Choosing Logged Events