SQL Business Intelligence Training, SQL Server 2005 BI Course, Learn Business Intelligence

SQL Server 2005 Business Intelligence Application Development

Duration: 5 Days | Price: $2495 | Class Dates:

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 Business Intelligence: Integration Services and Analysis Services 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

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

Hands On Technology Transfer, Inc.
1 Village Square, Suite 8
14 Fletcher Street
Chelmsford, MA 01824
1-800-413-0939 | 1-978-250-4299