Microsoft – BI
(SSIS, SSAS, SSRS)
Contents:
Planning for ETL:
· Source Identify Data Sources and Destinations
· Evaluating Data
· Identify Staging Requirements
Lab: Planning an ETL Solutions
Planning SSIS Solutions:
· Planning Packages
· Planning Package development
· Designing Package Control Flow
Lab: Implementing SSIS Packages
Designing Data Flow:
· Understanding Data Flow
· Designing Data Flow Operations
· Handling Data Changes
Lab: Implementing Data Flow
Logging Error Handling and Reliability:
· Logging ETL Operations
· Handling Errors in SSIS
· Implementing Reliable ETL Process with SSIS
Lab: Implementing Reliable Packages
Optimizing an SSIS Solution:
· Monitoring SSIS Performance
· Optimizing SSIS Packages
· Scaling out SSIS Packages
Lab: Optimizing Packages
Deploying and Operating an SSIS Solution
· Deploying SSIS Packages
· Operating an SSIS Solution
Lab: Optimizing Packages
Contents:
Introduction to Microsoft SQL Server 2005 Analysis Services
· Overview of Data Analysis Solutions.
· Over of SQL Server 2005 Analysis Services.
· Installing SQL Server 2005 Analysis Services.
Creating Multidimensional Analysis Solution
· Developing Analysis Service Solutions.
· Data Sources and Data Sources Views.
· Creating a Cube.
Lab: Creating a multidimensional Analysis Solution
Working with Dimensions
· Configuring Dimensions.
· Defining Hierarchies.
· Sorting and Grouping Attributes.
Lab: Defining Dimensions
Working with Measure and Measure Groups
· Working with Measure.
· Working with Measure Groups.
Lab: Configuring Measure and Measure Groups
Querying Multidimensional Analysis Solutions
· MDX Fundamentals.
· Adding Calculations to a Cube.
Lab: Querying a Cube
Customizing Cube Functionality
· Implementing Key Performance Indicators.
· Implementing Actions.
· Implementing Perspectives.
· Implementing Translations.
Lab: Customizing a Cube
Deploying and Securing an Analysis Services Database
· Deploying an Analysis Services Database.
· Securing an Analysis Services Database.
Lab: Deploying and Securing an Analysis Services Database
Maintaining a Multidimensional Solution
· Configuring Processing Settings.
· Logging, Monitoring and Optimizing an Analysis Services Solution.
· Backing Up and Restoring an Analysis Service Database.
Lab: Maintaining an Analysis Services Database
Introduction to Data Mining
· Overview of Data Mining.
· Creating a Data Mining Solution.
· Validating Data Mining Models
Lab: Implementing Data Mining
SSRS – Objectives:
v Describe SQL Server Reporting Services and its Components.
v Create a Reporting Services report.
v Enhance a Reporting Service report.
v Create and manipulate data sets.
v Use report models to implement reporting for business users.
v Configure report publishing and execution settings.
v Implementing subscription for reports.
v Implement custom Reporting Services applications.
