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

Training Provided by Hands On Technology Transfer, Inc. This hands on SQL Server course presents the Business Intelligence tools included in SQL Server 2005 as well as the new features of SQL Server 2008. 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 Business Intelligence: Integration Services and Analysis Services rather than this course. Course Prerequisites: Familiarity with database concepts and Windows desktop navigation.

SQL Server Business Intelligence Application Development (SSRS, SSIS, SSAS) SQL Server 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

About The Training Provider: Hands On Technology Transfer, Inc.

More Hands On Training Classes Training from Hands On Technology Transfer, Inc.

• Advanced .NET Framework Programming Using C #
• Advanced .NET Framework Programming Using VB.NET
• Advanced ASP.NET Application Development Using C# and AJAX
• Advanced ASP.NET Application Development Using VB.NET and AJAX
• Advanced Visual Basic 6.0
• ASP Programming
• ASP.NET Programming Using C#
• ASP.NET Programming Using Visual Basic.NET
• C++ Programming for Non-C Programmers
• Introduction to Visual Basic 6.0
• Java EE Web Application Development with Enterprise JavaBeans and Web Services
• Java Programming
• JavaScript Programming
• Korn Shell Programming
• Learning to Program with C#
• Learning to Program with Java
• Linux System Administration
• Mastering XML
• Microsoft SQL Server 2005 Administration
• Microsoft SQL Server 2008 Administration
• Microsoft Transact-SQL Programming
• Microsoft Windows System Programming
• Object Oriented Analysis & Design with UML
• Perl Programming and CGI Scripting
• PHP Programming
• SQL Programming
• UNIX Linux Fundamentals
• Web Site Development with HTML JavaScript
• Windows Forms Programming Using C #
• Windows Forms Programming Using Visual Basic.NET
• Windows Server 2008 Active Directory and Security Design
• Windows Server 2008 Administration
• Writing a Windows Device Driver