MSBI Online Training Course Content

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

We are providing MSBI Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality MSBI online training all over India. The IT Professionals and Students from India and abroad who are unable to attend regular classes can attend our MSBI online training from their home in their convenient timings. For more details on MSBI Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com

MSBI online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India