Facebook Twitter google plus LinkedIn

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

MSBI Training in Hyderabad



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

Course Description

Introduction

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Reasons for using, uses
  • Characteristics of DWH
  • OLTP Vs OLAP Databases

Data Marts and Star Schema Design

  • Design of Dimension and Facts
  • Definition of Star Schema
  • Snow Flake Star Schema
  • Slowly Changing Dimensions
  • Type of Facts
  • Conformed Dimensions

Implementation Methodology

  • Kimball Methodology
  • Inmon Methodology

Types of Loads

  • First Time Load
  • Full Load
  • Incremental Load

I) SQL Server Integration Services (SSIS)

1. Introduction to SQL Server Integration Services

  • Product History
  • SSIS Package Architecture Overview
  • Development and Management Tools
  • Deploying and Managing SSIS Packages
  • Source Control for SSIS Packages

2. SQL Server Data Tools(Visual Studio)

  • Launching Data tools
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu

3. Introduction to Control Flow

  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task

4. Advanced Control Flow

  • Containers - grouping and looping
  • The Analysis Services tasks
  • The Execute Process Task
  • The Execute Package Task

5. Introduction to Data Flow

  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Transformations
  • The Copy Column Transformation
  • The Derived Column Transformation
  • The Data Conversion Transformation
  • The Conditional Split Transformation
  • The Aggregate Transformation
  • The Sort Transformation
  • Data Viewers

6. Variables and Configurations

  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages

7. Debugging, Error Handling and Logging

  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The On Error event handler
  • Data Flow: Error data flow
  • Configuring Package Logging

8. Advanced Data Flow

  • The Lookup Transformation
  • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
  • The Multicast Transformation
  • The Slowly Changing Dimension Transformation

9. Extending SSIS through Custom Code

  • Introduction to SSIS scripting
  • The SSIS script editor
  • The SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development

10. SSIS Package Deployment

  • Configurations and deployment
  • Managing packages with DTutil
  • Managing packages with SQL Server Management Studio

II) SQL Server Reporting Services (SSRS)

1. Introducing SQL Server Reporting Services

  • Features
  • Reporting Services Architecture
  • Reporting Services Terminology
  • Reporting Services Editions

2. Creating Reports

  • Shared Data Sources
  • Creating Reports from Scratch

3. Calculations and Formatting

  • Reporting Services Items
  • Basic Expressions
  • Using the Global Collections
  • Formatting Fields
  • Conditional Formatting

4. Grouping and Sorting

  • Creating Groups
  • Interactive Sorting
  • Creating Drill-Down Reports
  • Calculating Totals and Percentages

5. Report Parameters

  • Creating Report Parameters
  • Binding Report Parameters to Dataset Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters

6. Creating Matrix Reports and Charts

  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating Chart Reports
  • Exploring the Charting Possibilities
  • Charting Add-ons

7. Managing Reporting Services

  • Using the Web-Based Report Manager
  • Using SQL Server Management Studio- based Reporting Services Manager
  • Deploying Reports and Data Sources

8. Reporting Services Security

  • Reporting Services Security
  • Managing Roles

9. Distributing Reports via Subscriptions

  • How Subscriptions Work
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Managing Subscriptions

10. Ad-Hoc Reporting with Report Builder

  • The Report Builder Architecture
  • Creating Report Model Projects
  • Running Report Builder

III) SQL Server Analysis Services (SSAS)

1. Introduction to Microsoft SQL Server Analysis Services

  • Overview of Data Analysis Solutions
  • Overview of SQL Server Analysis Services.
  • Installing SQL Server Analysis Services.

2. Creating Multidimensional Analysis Solution

  • Developing Analysis Services Solutions.
  • Data Sources and Data Source Views
  • Creating a Cube

3. Working with Dimensions

  • Configuring Dimensions
  • Defining Hierarchies
  • Sorting and Grouping Attributes

4. Working with Measures and Measure Groups

  • Working with Measures.
  • Working with Measure Groups.

5. Querying Multidimensional Analysis Solutions

  • MDX Fundamentals
  • Adding Calculations to a Cube

6. Customizing Cube Functionality

  • Implementing Key Performance Indicators.
  • Implementing Actions
  • Implementing Perspectives.
  • Implementing Translations.

7. Deploying and Securing an Analysis Services Database

  • Deploying an analysis Services Database.
  • Securing an Analysis Services Database.
We are offered Abinitio online training also


Enquiry