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

Duration: 5 Days | Price: Contact us for pricing

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

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

Students Will Learn:

Multiple Training Locations - Convenience and Cost Control

Regularly Scheduled Courses in 16 Cities Across the United Kingdom