header photo
Rahul Chatterjee cleared his PMP Certification in his first attempt! Sumana Halder cleared her ITIL V3 Foundation exam with high marks! Monojit offered a job by Hindalco after completing his Oracle course! Subhamay placed with HP as an Oracle DBA
 

Microsoft MSBI Training

Palium offersMSBI training in all 3 modules 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 around 52 hours.

Our Trainer is an IT Industry professional with many years of experience in this domain.

Course will cover the topics as well –

SSIS: Integration Services

 

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: Analysis Services

Introduction to Analysis Services

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

Dimensional Model Development

  • Introduction
  • Dimension wizard & 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 & Query Binding
  • Local and Remote Server Partitions
  • Need for Storage Models–MOLAP. ROLAP
  • Generation of Aggregations on Partitions
  • Storage Modes and Proactive Caching
  • Hierarchies & Relations in Tabular Mode

Security

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

SSRS – Reporting Services

 

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 & Tables

o   Adding Textbox, image etc

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

Learning Centers:

1st Floor, ‘Sheeba Bhavan’,                                        8th Floor, RDB Boulevard

1/22, Poddar Nagar, (Nr South City Mall)           Salt Lake Sector V

Kolkata 700068  +91-4001 47947                         Kolkata - 700091

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

 

 

About the Faculty

The program will be conducted by an experienced professional with many years of IT Service Management exposure and experience. He has helped numerous individuals to achieve PMP certification.


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.

For Registration Contact:               

Barindra De:  + 91 – 90510  92035   or

Shrabana Pal: + 91 – 84205  94969

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

Plz call +91-9051092035 for more details -
 

 


Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save