Skip Main Navigation
Page Content

Save This Event

Event Saved

MSBI Training – SSIS, SSAS, SSRS Classroom in Kolkata

PALIUM SKILLS

Thursday, December 1, 2016 at 10:30 AM - Thursday, December 31, 2020 at 6:00 PM (IST)

MSBI Training – SSIS, SSAS, SSRS Classroom in Kolkata

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
General Admission 1000 Tickets Jan 6, 2017 $290.00 $8.24

Who's Going

Loading your connections...

Share MSBI Training – SSIS, SSAS, SSRS Classroom in Kolkata

Event Details

MSBI Training – SSIS, SSAS, SSRS (Batches starts every month)


MSBI training covers all 3 aspects ie SSIS, SSAS, SSRS. It is recommended that the training be done in that order.  We also offer the modules individually. The focus of our training is on hands-on practice.

Duration of each module is 20 hours. However, if one does all 3 modules then the total will be about 52 hours; Course will cover the topics as well –

SSIS:

Introduction to SQL Server Integration Services

  • o    Introduction
  • o    Product History
  • o    Architecture overview
  • o    Packages

Business Intelligence Development Studio

  • o    Introduction
  • o    Package Designer
  • o    Toolbox
  • o    Solution explorer
  • o    Properties window
  • o    Variables window

Control Flow Overview

  • o    Introduction
  • o    Connection Managers
  • o    Tasks
  • o    Precedence Constraints
  • o    Containers

Control Flow Task Detail

  • o    Introduction
  • o    Data Preparation Task
  • o    File System Task
  • o    FTP Task,  XML Task
  • o    Web Services Task
  • o    Data Profiling Task
  • o    Execute Package Task
  • o    Execute Process Task

Data Flow basics

  • o    Introduction
  • o    Data Sources
  • o    ADO.NET Source
  • o    Excel Source
  • o    Flat File Source
  • o    OLE DB Source
  • o    XML Source
  • o    Raw File Destination

Data Flow Transformations

  • o    Introductions
  • o    Row Transformations
  • o    Copy Column
  • o    Data Conversion
  • o    Derived Column
  • o    Aggregate, Sort
  • o    Multicast
  • o    Union All
  • o    Merge & Merge Join

Debugging Packages

  • o    Debugging
  • o    Breakpoints
  • o    Data Viewer

Deployment Management

  • o     The deployment utility
  • o     Deployment options
  • o     Deployment security
  • o     Executing packages – DTExec & DTExecUI

Deployment Options   & Utilities

  • o    Package Execution Options
  • o    File System Security Limitations
  • o    SSIS Deployment & DB Engine
  • o    SSIS Catalog Project Files
  • o    Package Migration Utilities
  • o    Command-Line Deployments

Security

  • o    Security Options
  • o    Encrypting SSIS Packages
  • o    Event Logging Activities

Upgrading Packages

  • o    Migrating packages
  • o    DTS packages to SSIS migration

 

SSAS

Introduction to Analysis Services

  • Introduction
  • Business Intelligence Queries
  • Architecture Options
  • Database Developments
  • Development, Management and Client Tools
  • Summary

Dimensional Model Development

  • Introduction
  • Dimension wizard
  • Dimension designer
  • Unknown member
  • Attribute properties
  • Date dimension
  • User Hierarchies
  • Parent child hierarchy
  • Attribute relationship
  • Translation
  • Summary

Cube Development

  • Data Source and Data Source Views
  • Computed and Named Queries
  • Building Entity Relationships
  • Deciding Data Warehouse Schema
  • Creating Dimensions and Builds
  • Attributes and Member Names
  • Choosing Dimension Templates
  • Applying Time Based Dimensions
  • Need for Hierarchies and Limitations
  • Attribute Relations and Uses
  • Building Levels and Hierarchies
  • Need for Composite Attribute Keys

KPI Calculations and Partitioned Aggregations

  • Identifying Cube Entries for FASMI Rules
  • Measures and Additives (Full and Semi)
  • Defining Measure Groups and Measures
  • Cube Customizations and Options
  • BI Enhancements and Granularity
  • Building Fact Less Cube Dimensions
  • Calculations and Conditional Colors
  • MDX Scripting for Calculations
  • Defining KPIs and Goals using MDX
  • Perspectives using MDX Expressions
  • SSAS Actions with MDX and XMLA
  • Need for Cube Partitions and Query Binding
  • Local and Remote Server Partitions
  • Need for Storage Models – MOLAP  and ROLAP
  • Generation of Aggregations on Partitions
  • Storage Modes and Proactive Caching
  • Hierarchies and Relations in Tabular Mode

Security

  • Overview
  • User Security
  • Dimension Security
  • Cell Security
  • Administrator Security
  • Service amount configuration

SSRS

Introduction

  • o    Introduction to Business Intelligence Development Studio
  • o    Introduction to SSRS
  • o    Working with SSRS in BIDS

Basic Report Development

  • o    Data Sources
  • o    Creating a Data Source
  • o    Datasets
  • o    Adding Textbox, image etc
  • o    Tables

Tablix

  • o    Introduction
  • o    Table and Matrix
  • o    Tablix demo
  • o    Cell Contents

Expressions

  • o    Introductions
  • o    Placeholders
  • o    Global collections
  • o    Expression editor
  • o    Parameters in expression

Parameters

  • o    Introductions
  • o    Report parameters
  • o    Filtering data with Report Parameter
  • o    Parameter values from Dataset
  • o    Dynamic parameter values

Report Dataset

  • o    Introduction
  • o    Joining dataset

Delivering SSRS Reports

  • o    Report Delivery Options & Schedules
  • o    Accessing and controlling reports
  • o    Leveraging RS Web services
  • o    Choosing between Rendering Formats

Managing Reports

  • o    Report Manager Configurations
  • o    Managing Data Sources Security
  • o    Exporting and Importing Reports
  • o    Creating Global Schedules – Site Level
  • o    Snapshot Management & Schedules
  • o    Regenerating Snapshots for Tuning Options
  • o    ReportServerTempdb Usage
  • o    Tuning Reports with Caching Options

Scheduling and Subscriptions

  • o    Creating Standard Subscriptions
  • o    Data-Driven Subscriptions
  • o    Subscription & Logging Options

SSRS Report Security

  • o    Report Data Source Security
  • o    Report Server Security Levels

Report Server DB Security

 

 

Contact:

Shrabana – 8420594969

Sunit – 9903130500

Have questions about MSBI Training – SSIS, SSAS, SSRS Classroom in Kolkata? Contact PALIUM SKILLS

Save This Event

Event Saved

When & Where


Palium Skills Professional Training Institute in Kolkata
1/22 Poddar Nagar, Near South City Mall
Kolkata, WB 700068
India

Thursday, December 1, 2016 at 10:30 AM - Thursday, December 31, 2020 at 6:00 PM (IST)


  Add to my calendar

Organizer

PALIUM SKILLS

Who are we?

Palium is a training organization conducting trainings on Functional, Soft-Skills, IT and Project Management areas. We have conducted trainings for leading corporates like ITC, JUSCO, CMS and many others.

We also conduct trainings on Primavera P6, MS Project and other Project Management related topics.

 

Palium works with Infocareers, an approved REP of Project Management Institute.  Infocareer has conducted  numerous such programs and has helped individuals to achieve certification and work successfully in the Project Management domain.

Palium Software Services Private Limited

1st Floor, ‘Sheeba Bhavan’,

1/22, Poddar Nagar

(Near South City Mall/Dominos Pizza),

Kolkata, West Bengal 700068

P: +91-842 059 4969 L: +91-33-4001 7947

E: trainings@paliumsoftware.in

www.paliumtrainings.biz 

  Contact the Organizer
MSBI Training – SSIS, SSAS, SSRS Classroom in Kolkata
Things to do in Kolkata Class Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.