Facebook Twitter google plus LinkedIn

Email:contact@psntrainings.com
india:Whatsapp No+91 86860 29160 USA:+1 228 586 3560

MSBI Training



PSN Trainings is the Best MSBI Microsoft Business intelligence training(SSIS, SSAS, SSRS)Training institute in Hyderabad,India

Course Description

SQL SERVER ANALYSIS SERVICE

Introduction

  • Overview of Analysis Service
  • Advantages of Analysis Service
  • Terminology
  • Analysis Service Architecture
  • Features
  • Types of Schema
  • OLAP Types

Building Basic Analysis Service Solutions

  • Defining Data Sources
  • Defining Data Sources View
  • Defining Cubes
  • Deploying , Processing and Browsing

Working with Dimensions

  • Creating a Dimension
  • Configuring Dimension
  • Defining Hierarchy
  • Configuring Attribute Relationships
  • Sorting and Grouping Attributes

Measures and Measure Groups

  • Measures and Aggregations
  • Measure Groups
  • Dimension/Measure Group Relationships

Calculations

  • Calculated Members
  • Named Sets
  • Defining Scopes

Customizing Cube Functionality

  • Implementing Aggregations
  • Implementing KPI's
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Securing an Analysis Service Database

  • Security Features
  • Administrative Security
  • Data Security

Maintaining a Analysis Service Database

  • Configuring Processing Settings
  • Logging , Monitoring and Optimizing an analysis service solution
  • Deploying , Backup and Restoring a Analysis Service database

Introduction to Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating Data Mining Models

SQL SERVER INTEGRATION SERVICE

Introduction

  • Understanding SSIS
  • Bids
  • Building and Executing a Package

Planning for ETL

  • Source Identify Data Source and Destinations
  • Evaluating Data
  • Identity Staging Requirements

Planning an SSIS Solutions

  • Planning Packages
  • Planning Package Development
  • Designing Package Control Flow

Designing Data Flow

  • Understanding Data Flow
  • Designing Data Flow Operations
  • Handling Data Chances
  • Data Flow Scripting

Variables

  • Understanding Variables
  • Control Flow Variables
  • Data Flow Variables

Logging Error Handling and Reliability

  • Logging ETL Operations
  • Handling Errors in SSIS
  • Implementing Reliable Packages

Optimizing an SSIS Solutions

  • Monitoring SSIS Packages
  • Optimizing SSIS Packages
  • Scaling out SSIS Packages

Deploying and Operating an SSIS Solutions

  • Deploying SSIS Packages
  • Installing an SSIS Solution
  • Managing Packages
  • Packages and Security

SQL SERVER REPORTING SERVICE

Introduction

  • Reporting Service History
  • Reporting Challenges
  • Advantages of SQL 2008
  • Tour
  • Building Your First Application
  • Architecture
  • Building Reports
  • Enhance Reports
  • Parameters
  • Chart & Gauges
  • Security Overview

Report Designer Basics

  • Creating a Report Server Project
  • Data Sources & Datasets
  • Data Region Basics
  • Grouping Data
  • Adding Totals
  • Adding Images
  • Formatting the Report
  • Data Formatting
  • Using Matrix Regions
  • Using List Regions

Enhancing Your Reports

  • Sorting
  • Adding Headers
  • Adding a Footers
  • Moving & Resizing
  • Inserting Page Breaks
  • Text Box Expressions
  • Adding Calculated Fields
  • Sub Reports
  • Controlling Visibility

Parameters

  • Overview of Using Parameters
  • Report Parameters
  • Query parameters
  • Report Parameters Options

Charts

  • Using Charts
  • Chart Formatting
  • Using Gauges
  • Gauges Formatting

Deploying Reports

  • Reports Deployment Overview
  • Deploying Reports
  • Reports Execution Options

Administrating Reporting Service

  • Reporting Execution Process
  • Understanding Report Caching
  • Understanding Schedules
  • Understanding Snapshots
  • Report History
  • Report Delivery Options
  • Subscription Types
  • Reporting Service Security
  • Managing Security
We are offered Abinitio online training also


Enquiry