MSBI Online Training in Hyderabad

Introduction to MSBI

• What is BI and MSBI
• Importance of MSBI in the current Enterprise
• Installation Steps and requirements
• ETL and OLAP Tools
• Features of MSBI

SSIS – (SQL Server Integration Services)

• What is SSIS and use in the enterprise?
• SSIS Architecture
• Control flow architecture
• Data flow architecture
• Data pipeline
• Packages

Developing SSIS Solutions and Packages

• SSIS Solution and Project Creation
• SSIS Package Creation
• Connection Managers and Shared Data Sources
• Control Flow Tasks
• Data Flow Task [ETL]
• Variables and Expressions
• .NET scripting in SSIS

Data Flow Tasks and Transformations

• Objectives of Data Flow Tasks
• Transformations
  • Aggregate Transformation
  • Merge Transformation
  • Merge Join Transformation
  • Union All Transformation
  • Multicast Transformation
  • Conditional Split Transformation
  • Lookup Transformation
  • Fuzzy Lookup Transformation
  • Derived Column Transformation
  • Copy Column Transformation
  • Data Conversion Transformation
  • Sort Transformation
  • Merge Vs. Union All

Control Flow Tasks

• Working with Control Flow Tasks and Containers
• For Each Loop
• For Loop
• File System Task
• Execute SQL Task
• Analytical Processing Task
• Transfer Database Task
• Backup Database Task
• Sqlserver transformation Task
• Agent Task
• Script Task
• Execute Package Task. Etc.

Errors and Debugging SSIS

• Various ways of debugging SSIS Package
• Data viewers
• Configure Error output
• Execution Logging

Logging, Events and Configurations

• Various ways of Configuring SSIS Package
• Using check points
• Implementing Transactions
• Logging ETL Operations and Log Providers
• Various Events involved in the execution of Packages

Bottlenecks, Performance Tuning

• Monitoring and Optimizing Packages
• Various ways to identify bottlenecks
• Tuning Source Tasks
• Tuning Destination Tasks
• Tuning in Package level and System Level

SSIS Administration

• Various ways of Deploying SSIS Package
• Configurations
• Sql Server Deployment
• Security
• Manually Executing SSIS Package
• Scheduling SSIS Package
• Importing and Exporting Packages

SSAS – (SQL Server Analysis Services)

• Dimensions
• Facts
• Data Sources
• Data Source Views

Developing Cubes

• Cube Designer
• Partitions and Aggregations
• Dimension Usage
• Calculation and Kpis
• Perspectives, Actions
• Translations
• Write-back feature

MDX Language

• Axes, Slice
• Tuple and Set
• MDX Queries
• MDX Expressions
• MDX Scripts

SSAS Administration

• Installation
• Configuration
• Deployment
• Processing
• Security
• Backup and Restore

SSRS – (SQL Server Reporting Services)

• What is SSRS, Need of Reporting Services
• SSRS-2008 additional features
• Enterprise Report Life Cycle

SSRS Administration and Management

• Working with RS Configuration Tool
• Report Manager/Server/Database Creation
• Authenticating Manager/Server/Database
• RS Server starting and stopping

Report Creation and Authoring

• Working with various report facilities
• Report Server Wizard
• Report Server Project
• Report Model Project
• Report Builder
• Creating different reports and managing
• Table
• Matrix
• Chart
• List
• Gauge
• Sub Report
• Formatting
• Map
• Bar

Working with Reports Extensively

• Creating a report by connecting to
• OLAP cubes
• RDMBS
• XML Sources
• Excel Sources
• Stored Procedures
• Creating Sub Report and using it
• Working with
  • Sub Totals/Full Totals
  • Page Breaks
  • Page Footer/Header
  • Table Header/Footer
  • Sorting & Grouping
  • Applying Colors, Fonts etc

Working with Drill Down, Drill Through

• Creating Drill Down & Through reports
• Various ways to create and manipulate

Adhoc Reporting, Report Builder

• Creating and working with report model
• Report Builder and various options, features

Actions, Expressions & Variables

• Implementing various Report Actions
• Working with various expressions
• Variables (Report and Group)
• Calculated members, Query fields

Parameterised Reports

• Passing Parameters
• Non-Queried
• Queried
• Multivalued
• Cascading Parameters

Publishing and Executing Reports

• Executing the Reports
• Creating cached Instances
• Creating snapshots and report history

Creating Subscriptions & Optimization

• Normal, Data Driven, Null Subscription
• Email and File Share Delivery Tuning of SSRS, Components and Query