MSBI 2012 with SQL Server

  • Importing Excel and XML Data
  • Exporting  SQL Server Data
  • Automating  SQL 2000 DTS Packages
  • Designing Data Warehouses
  • Creating Cubes
  • Mining  Data
  • Managing Cube Security
  • Generating  Reports
  • Customizing  Reports
  • Rendering Reports
  • Automating Reports

→ SQl Server 2008 Integration Servers (SSIS)

  • Over view of Integration Services Solutions
  • Integration Services Tools

→ Developing Integration Services Solution

  • Creating  an integration services solution
  • Using Variables
  • Building and Running a Solution

→ Implementing Control Flow

  • Control flow Tasks
  • Control Flow  Precedence Constraints
  • Control Flow Containers

→ Implementing Data Flow

  • Data Flow Sources and Destinations
  • Data Flow Transformations
  • Data Flow Paths

→ Implementing Logging Debugging and Error Handling

  • Overview of Integration Services Logging
  • Implementing Logging
  • Debugging a package
  • Implementing Error Handling

→ Implementing Checkpoints & Transactions

  • Implementing Checkpoints
  • Implementing Transactions

→ Deploying Packages

  • Package Configurations
  • Deploying Packages

→ Introduction to Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating Data Mining Models

→ Data Mining Algorithms

  • Matching Alogorithms  to Business Needs

→ Managing and Securing Packages

  • Managing Packages
  • Securing Packages

→ Performance Tuning

  • SSIS Performance Tuning
  • DB Performance Tuning

→ Coding Standards

  • SSIS Naming Standards

→ Best Practices of SSIS
Comparison Between SSIS 2005 and SSIS 2008
SQL Server 2008 Analysis Services (SSAS)

  • Overview of Data Analysis Solutions
  • Overview of SQL server 2008 Analysis Services
  • Installing SQL  Server 2008 Analysis  Services

→ Creating Multidimensional Analysis Solutions

  • Developing Analysis Services Solutions
  • Data Sources and Data Source Views
  • Creating a Cube

→ Working with Dimensions

  • Configuring  Dimensions
  • Defining Hierarchies
  • Sorting and Grouping Attributes
  • Working with Measures
  • Working with Measure groups

→ Analytical MDX

  • Analytical MDX Introduction
  • MDX queries MDxvs.SQl
  • MDX Stored Procedures

→ Publishing and executing reports

  • Publishing report
  • Executing reports
  • Creating cached instances
  • Data Mining Models
  • Discovering Patterns of Data
  • Creating Predictive Models
  • Gathering Data
  • Data Mining Wizard

→ Modifying Models with Data Mining Designer

  • Adding Calculations to a Cube

→ Customizing Cube Functionality

  • Implementing key Performance Indicator
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

→ Deploying and Securing an Analysis Services Database

  • Deploying an Analysis Services Database
  • 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 Services Database

→ SQL Server Reporting Services (SSRS) 2008

  • Overview of SQL  Server Reporting Services
  • Installing Reporting  Services
  • Reporting  Services Tools

→ Manipulating Data Sets

  • Defining  Report Data
  • Using Parameters and Filters
  • Using parameter lists

→ Using report models:Creating report models

  • Using report builder
  • Creating Adhoc Reports
  • Creating snapshots and report history

→ Using subscriptions to distribute reports

  • Introduction to report subscriptions
  • Creating report subscriptions
  • Managing  report  subscriptions

→ Administering reporting services

  • Server administration
  • Performance and reliability monitoring
  • Administering  report server databases
  • Security administration

→ Programming reporting services

  • Querying for server information using a web service
  • Automating report management
  • Rendering reports
  • Creating custom code

→ Authoring Basic Reports

  • Linked reports
  • snapshot reports
  • Cached Reports
  • Adhoc reports
  • Drill down reports
  • Drill through reports
  • Sub reports

→ Creating following Reports

  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values

→ Enhancing Basic Reports

  • Interactive Navigation
  • Displaying Data

→ Performance Tuning

  • SSRS Performance Tuning
  • DB Performance Tuning

→ Coding Standards

  • SSRS Naming Standards

→ Best Practices of SSRS
Comparison Between SSRS 2005 and SSRS 2008

Contact for Demo
Training Enquiry Form





Online Courses Videos