MSBI (SSIS, SSAS, SSRS)

MSBI Training in Chennai

We provide the best MSBI training in Chennai in tools like SSIS, SSRS, SSAS using SQL Server. Complete practical oriented training by our expert trainers.

The overview of the course content is provided below with the pre-requisites. If need the customized or detailed course content mail us at info@blackcloud.in . 

MSBI training (SSIS, SSRS, SSAS) - Course Overview

MS SSIS

An Overview of Database Concepts
Data Warehouse – an Introduction
What is ETL?
SSIS Objects – a definition
Data Flow Task & Connection Managers
Sources & Destinations
     Flat File
     OLE DB
     Excel
     ADO.NET
Row Transformations
     Copy Column
     Data Conversion
     Derived Column
     Script Component
     OLE DB Command

Rowset Transformations
     Aggregate
     Sort
     Percentage Sampling
     Row Sampling
     Pivot
     Unpivot
Split and Join Transformations
     Conditional Split
     Multicast
     Merge
     Merge Join
    Union All
    Lookup

Other Transformations
     Export Column
     Import Column
     Audit
     Row Count
     Slowly Changing Dimension
Control Flow components
Precedence Constraints
Containers
     Sequence Containers
     For Loop Containers
     Foreach Loop Containers
Tasks
     Script Task
     Send Mail Task
     Expression Task
     Execute SQL Task
     File System Task
     Execute Package Task
     Backup Database Task
     Execcute SQL Server Agent Job Task

Error Handling
     Event Handlers
     Error output configuration
     Precedence Constraints
Logging
      Providers
      Log events
      Advance Options
      Transaction and Check points
      Save Checkpoints
      Transaction Option
      Isolation Level
Debugging Control Flow
      Breakpoints
      Watches
Securing Packages
     Protection Level
     Package Password
Deploying Packages
     Package and Project Parameters
     Package Level and Project Level deployments
     Environments
Package Execution Methods                                     Running packages  from SSMS                             DTEXEC Utility

Scheduling Packages

     Jobs
     Steps
     Schedules 

MS SSRS

SQL Server Reporting Services Architecture
SSRS Objects – Definition
Data Source & Data Sets
       Shared sources
Graphical Query Designer
Tablix and Data Regions
      Table
      Matrix
      Lists
Fixed & Dynamic – columns and rows
Groups
      Row & Column Groups
      Dynamic Grouping
      Grouping the “details” region
Drill-down facility
      Visibility option

Report Parameters
      Cascading parameters
      Multivalued Parameter
      Available & Default values
      Multiselect parameters
Expressions
      Using Built-in Fields in reports
      Using stored procedures
      Specifying “Scope” in aggregate functions
      Using VB.NET expressions to – control properties, calculate values & specify a dataset query
Formatting
      Rich formating
      Page layout
      Page breaks and Floating Headers

Headers and Footers
      Multi-line header and footers
Interactive Sorting
Subreports
      Using in a table
      Drill-down a subreport
Other features
      Nested data regions
      Filtering the Tablix
      Multiple column reports
Navigations
      Drill-through
      Document Map
     Bookmarks
     Hypertext links
Images
      Embedded Images
      Background Images
      Database Images

     Charts
     Guages
     Images
     Data Bar
     Indicator & Sparkline Report Items
Reports from Analysis Service Cube
      Creating data set with MDX Query builder
Ad Hoc reporting
      Report Builder
      Sematic Model
      Data Governance
      Report parts deployment
Preview Data Caching
The Report Manager
     Accessing reports from browser
     Subscriptions
     Caching options
     Snapshots
      Linked reports
      Report History
      Managing Securit

MS SSAS

Business Intelligence and Data Warehousing Concepts
       Multidimensional Data Analysis
       Fact Table and Dimensions
      Surrogate Keys and SCDs
Understanding OLAP and Analysis Services
Dimensions
      Standard Dimension
      Time Dimension
      Parent-Child Dimension
      Role-Playing Dimension
User defined Hierarchies
Creating Levels
      Adding Key and Name property
Attribute Relationships
     Resolving relationship issues
     Setting Rigid property

Building a Cube
      Data Source and Data Source View
      Previewing Cube Data
      Formatting Measures
      Interaction of Dimensions and Measure Groups
Working with MDX Queries
      Aggregate Functions
      Retrieve values from Cube using MDX Queries
Advanced Measures and Calculations
      Calcualted Members
      Calculation Scripting
Key Performance Indicators
       Calculate values and targets
       Setting the graphical icons

Dimension Relationships
      Dimension Usage
      Reference Dimensions
      Fact Dimensions
      Many-to-Many Dimensions
Perspectives
      Customized views
      Setting Languages
Tabular Data Model (BISM)
      Using PowerPivot for Excel
      Overview of Power View for Sharepoint
Actions
      URL Action
      Reporting Action
      Drillthrough Action
Writeback
      Dimension Writeback
      Cube Writeback
Designing Aggregations
      Design with wizard
      Factors affecting the Aggregations

Managing Partitions and Database processing
       Configuring a dimension for ROLAP or MOLAP
       Measure group partition
       Increment processing
      Proactive caching
Deployment
      Deploy from SSDT
      Deloyment Scripts
      Backup and restore Analysis Services databases
Security
      Server Administrative rights
     Database level rights
      Control access to Cubes, Dimensions and cell levels
Accessing SSAS using EXCEL & SSRS

Checking...

Ouch! There was a server error.
Retry »

Sending message...

Enquiry Form

Fill in the form below and we will be in touch soon

Courses

Our Services

  • Individual Training
  • Online Training
  • Corporate Training
  • Consulting Services

Connect with us

  • Opens in a new tab
  • Opens in a new tab