SQL Server 2008 Business Intelligence Application Development (SSRS, SSIS, SSAS)
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
||Reporting Services Architecture
||Report Builder Utility
|Automating Report Creation and Delivery
||Securing SQL Server Components
|Adding Custom Code
||.NET Integration with Reporting Services
|Designing Data Integration
||BI Development Studio
||Analysis Server Overview
|Multidimensional Queries (MDX Queries)
||Data Mining Algorithms
"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