SQL Server BI Tools (SSIS,SSAS,SSRS) Training

Table of Content

SQl Server 2014/16 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

Managing and Securing Packages
• 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 2014/16 Analysis Services (SSAS)

• Overview of Data Analysis Solutions
• Overview of SQL server 205 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 MDx vs.SQl
• MDX Stored Procedures
• Adding Calculations to a Cube

Customizing Cube Functionality
• Managing Packages
• Securing Packages

Scheduling Jobs

SQL Server Reporting Services (SSRS)

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

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

Enhancing Basic Reports
• Interactive Navigation
• Displaying Data

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

Using report models
• Creating report models
• Using report builder

Publishing and executing reports
• Publishing report
• Executing reports
• Creating cached instances
• 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

SQL Server
• Introduction to SQL server
• Introduction to T-SQL
• Constraints
• Joins
• Functions
• Views
• Indexes
• Stored Procedures
• Cursors
• Triggers

Difference Between ORACLE & SQL Server

SQL Queries

Contact Us

We are always here to guide you...

Quick Enquiry

Please enter name.
Please enter name.
Please enter valid email adress.
Please enter Course name.
Please enter your comment.


+91 9619 3417 13

+91 7506 4114 34

Website : www.sitcomputer.in

We Are Social