SQL Server 2005 Business Intelligence Application Development
Price: $2495
Duration: 5 Days | SQL Server 2005 Business Intelligence Application Development Course Schedule
Prerequisites: Familiarity with database concepts and Windows desktop navigation. Attendance at SST's 3-day SQL Programming course, or equivalent knowledge, is recommended but not required.
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.
Fundamentals of Business Intelligence
- OLTP vs. OLAP
- Data Warehousing
- Defining Archive Requirements
- Identifying Key Performance Indicators
- 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
- Types of Events
- Triggered Events vs. Scheduled Events
- Responding to Application Failure
- Subscriber Events
- Dimensions and Facts
- Cubes
- MDX Queries
- External Tools
- Creating Calculated Members
- Defining Dimension Tables
- Handling Slow Changing Dimensions
- Summarizing OLTP Data
- Using Integration Packages
- Designing for Scalability
- Report Server Components Defined
- Review of the Report Server Databases
- Reporting Services Web Service Interface
- Report Lifecycle
- Accessing Report Models
- Using the Report Builder
- Filtering Data
- Adding Expressions
- Building a Chart Report
- Setting up Folders for Users
- Setting Permissions
- Creating Custom Security Roles
- Securing Report Models
- Securing Integration Packages
- Securing Analysis Databases
- Securing Subscriber Applications
Designing Data Integration
- Managing Data Flow
- Migration vs. Recurring Transfers
- Blocking and Logging Issues
- Creating ETL Packages
- Using Checkpoint Restart
- Designing Transformations
- Handling Errors
- Controlling Transformation Order
- Management Tools
- Deployment Tools
- Comparison to Development Studio
- Matching Algorithms to Business Needs
- Mining for Hidden Information
- Data Mining Models
- Discovering Patterns of Data
- Supporting Subscriber Applications
- Generating and Sending Notifications
- Allowing Custom Criteria Selection
- Providing Personalized Messages
- Supporting Multiple Devices
- Creating Table Reports
- Creating Parameter Reports
- Creating Matrix Reports
- Formatting Options
- Paging and Sorting
- Drill-Through Reports
- Linked Reports and Subreports
- Creating Snapshot Reports
- Storing Report Histories
- Using Report Caching
- Creating Report Subscriptions
- Rending Reports in Excel, XML or PDF
- Querying SQL Server Components
- Creating Custom Data Extensions
- Creating Command Objects
- Creating Data Reader Objects
