SQL Business Intelligence Training

Microsoft Certified Partner

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

Northeast/New England	Southeast	Midwest	West/Southwest	Canada	United Kingdom
CT - Hartford CT - New Haven CT - Stamford DC - Washington MA - Boston MA - Chelmsford MA - Quincy MA - Springfield MA - Waltham MA - Woburn MA - Worcester MD - Baltimore MD - Columbia NH - Manchester NH - Nashua NJ - Jersey City NJ - Newark NJ - Princeton NY - Albany NY - Binghamton NY - Buffalo NY - Ithaca NY - Manhattan NY - Rochester NY - Syracuse PA - Harrisburg PA - Philadelphia PA - Pittsburgh RI - Providence	AL - Huntsville FL - Fort Lauderdale FL - Jacksonville FL - Miami FL - Orlando FL - Pensacola FL - Sarasota FL - Tampa FL - West Palm Beach GA - Atlanta GA - Savannah LA - Shreveport NC - Charlotte NC - Raleigh-Durham NC - Winston-Salem SC - Charleston VA - Alexandria VA - Fairfax VA - Norfolk VA - Richmond VA - Williamsburg	AR - Little Rock IA - Cedar Rapids IA - Des Moines IL - Chicago IL - Schaumburg IL - Springfield IN - Indianapolis KY - Louisville MI - Detroit MI - Lansing MN - Minneapolis MO - Kansas City MO - St. Charles MO - Springfield NE - Omaha OH - Cincinnati OH - Cleveland OH - Columbus OH - Dayton OK - Oklahoma City OK - Tulsa TN - Memphis TN - Nashville WI - Milwaukee	AZ - Phoenix AZ - Tucson CA - Bakersfield CA - Fresno CA - Irvine CA - Los Angeles CA - Modesto CA - Oakland CA - Riverside CA - Sacramento CA - San Diego CA - San Francisco CA - San Jose CA - Santa Clarita CA - Santa Monica CA - Temecula CO - Denver ID - Boise NM - Albuquerque NM - Las Cruces NV - Las Vegas OR - Portland TX - Austin TX - Corpus Christi TX - Dallas TX - El Paso TX - Fort Worth TX - Houston TX - San Antonio UT - Salt Lake City WA - Seattle WA - Spokane	AB - Calgary AB - Edmonton BC - Vancouver MB - Winnipeg QC - Montreal QC - Quebec City ON - Kingston ON - Mississauga ON - Ottawa ON - Toronto SK - Regina	Birmingham Bristol Chelmsford Edinburgh Glasgow Leeds Liverpool London Manchester

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