Module 1: Introduction to SQL Server 2008 Integration Services
  • Overview of SQL Server Integration Services
  • Using Integration Services Tools
  • Using the Import and Export Wizard
  • Running an Integration Services Package
Module 2: Developing Integration Services Solutions
  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution
Module 3: Implementing Control Flow
  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers
Module 4: Implementing Data Flow
  • Data Flow Sources and Destinations
  • Basic Data Flow Transformations
  • Advanced Data Flow Transformations
  • Data Flow Paths
Module 5: Implementing Logging
  • Overview of Integration Services Logging
  • Enabling and Configuring Logging
Module 6: Debugging and Error Handling
  • Debugging a Package
  • Implementing Error Handling
Module 7: Implementing Checkpoints and Transactions
  • Implementing Checkpoints
  • Implementing Transactions
Module 8: Configuring and Deploying Packages
  • Package Configurations
  • Package Parameters
  • Deploying Packages
Module 9: Managing and Securing Packages
  • Managing Packages
  • Securing Packages
  • What is Analysis Services Tabular Model?
  • How to create Azure Analysis Service Tabular model project
  • What is Workspace Database?
  • Import Data
  • Direct Query Mode
  • Tables and Columns
  • Relationships
  • Calculations
  • Measures
  • KPIs
  • Hierarchies
  • Partitions
  • Perspectives
  • Translations
  • Roles
  • Deployment of Tabular Project
  • What is Analysis Services Tabular Model?
  • How to create Azure Analysis Service Tabular model project
  • What is Workspace database
  • Import Data
  • Direct Query Mode
  • Tables and Columns
  • Relationships
  • Calculations
  • Measures
  • KPIs
  • Hierarchies
  • Partitions
  • Perspectives
  • Translations
  • Roles
  • Deployment of Tabular Project
Module 1: Introduction to Microsoft SQL Server Reporting Services
  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools
Module 2: Authoring Basic Reports
  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values
Module 3: Enhancing Basic Reports
  • Interactive Navigation
  • Displaying Data
Module 4: Manipulating Data Sets
  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists
Module 5: Using Report Models
  • Creating Report Models
  • Using Report Builder
Module 6: Publishing and Executing Reports
  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History
Module 7: Using Subscriptions to Distribute Reports
  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions
Module 8: Administering Reporting Services
  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008
Module 9: Programming Reporting Services
  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
Best MSBI Training in Hydrrabad

Preview this course

  • Duration 30 Hours
  • Students 21
  • Days 40 Days
  • Resume Preparation Yes
  • Interview Guidance Yes