Overview

Introduction

It is an analysis tool to create cube to perform multidimensional analysis. Cube is used to store summarized data and make BI application as super faster. SSRS – SQL Server Reporting Services – It is a Reporting tool to create reports such as table, Matrix, Drill down, Drill through, indicator, gauge and chart reports. This reports can be deploy to the web and end users can download them in wide variety of formats such as PDF, CSV, Excel, Etc.

Course highlights

  • High Quality Trainings
  • Not Happy with Quality. 100% Fees Returned. No Questions Asked!
  • Ask for Free Demo. Any time and for any course.
  • 100% interactive training
  • Talk to our students for feedback.
  • Payment can be made in 02 Instalments.
  • Video Recordings will be provided for all students.
  • Theory material in Advance
  • All Classes are conducted with real time project ,case studies and real time scenarios
  • Interview Questions and Tips are provided.
  • CV Preparation guidance will be provided

Course Content

Integration Service- SSIS

Chapter-1

  • Introduction to BI and other BI tools
  • Introduction to BI
  • Introduction to Data Warehouse
  • OLTP Vs OLAP
  • Difference between BI, DWH, Data Mining and Data Mart
  • Uses and Application of BI
  • Future for BI
  • MSBI and its Modules

Chapter -2

  • Introduction to SSIS
  • SSIS Components
  • SSIS Framework/Architecture
  • SSIS Overview of Components
  • Blocked and Non-Blocked Transformations
  • Synchronous and Asynchronous Transformations

Chapter -3

  • Control Flow Elements
  • Containers in Control flow
  • Tasks in Control flow
  • Script Tasks (Basic Script like pop-up window and Message Window)

Chapter-4

  • Data Flow Tasks
  • ETL Process
  • Types of Source and Destinations
  • Transformations
  • Error Configurations
  • Error Handling and Event Handling Techniques
  • Audit Errors
  • Different type of Events
  • Configure Check Points
  • Break Points
  • Transactions in SSIS Packages

Chapter-5

  • Deployment and Scheduling the Packages
  • Configuration Files and Deployment
  • Different Deployment Options
  • Deployment Utilities
  • Create SQL Server Agent Jobs and Schedule
  • Monitor Jobs

Chapter-6

  • Data Profiling and Data Cleansing
  • Data Profiling Tasks
  • Data Cleansing

Analysis Service- SSAS

Chapter-1

  • Introduction to SSAS
  • Brief Introduction to SSAS and ITS Components
  • BIDS Environment for SSAS
  • Creating Project SSAS

Chapter-2

  • Dimensional Modeling
  • Introduction to Dimensions and Fact Tables
  • Building Data Warehouse with Dimension and Fact Tables
  • Snowflake and Star Schema Methodology
  • SSAS Architecture

Chapter-3

  • Data Source and Data Source Views
  • Named Queries
  • Options in DSV
  • Named Queries

Chapter-4

  • Cube Designing and development
  • Different Ways to Create CUBE
  • Measures and Measure Groups
  • Diff between BUILD, DEPLOY and PROCESS
  • Calculated Columns

Chapter-5

  • Hierarchies
  • Creating and Managing Hierarchies
  • Translations
  • Cube Development Life Cycle
  • Exploring all the options in CUBE Development

Chapter-6

  • Processing Options
  • Understanding Processing
  • Different Processing Options

Chapter-7

  • Relationships
  • Different Types of Relationships
  • Creating Relationship between Fact and Dimensions

Chapter-8

  • MDX
  • Intro to MDX
  • Tuple, Set, Attribute, Hierarchy
  • Functions in MDX
  • Storage Modes
  • Different Storage Modes
  • How to select different Storage Modes

Chapter-9

  • Partitions-Aggregations
  • What are Partitions and How to create Partitions?
  • On what basis a Partition are created?
  • Aggregations

Chapter-10

  • Actions, Calculated Fields and KPI’S
  • What are Actions and How to create IT?
  • How to Configure CF’s?
  • What Are KPI’s? How to use KPI’s
  • Configuring KPI’s

Chapter-11

  • Deploying
  • Different Approaches to Deployment
  • Deployment Process and Documentations

Apply

Getting Started

Please reach our Kosmik HR for more Details of the Course Register your self Today or Kindly send us the mail for more Information

Download