MSBI

Home / MSBI

MSBI

MSBI stands for Microsoft Business Intelligence. Best MSBI training institute in Chennai, is strongly suite and is controlled of tools which helps in providing excellent solutions for Business Intelligence and Data Mining Queries. Best MSBI Coaching institute in Chennai empowers users to gain access to correct and up-to-date information for best resolution in an organization. This MSBI tool uses Visual studio along with SQL server and provides different tools for varies processes which are required in Business Intelligence (BI) solutions.  SSRS approach with Crystal Reports and dissimilar business intelligence tools. SSAS is manipulated as a tool by organizations to inspect and make sense of data possibly spread out across multiple databases, or in different tables or files. Microsoft Integration Services includes a powerful set of built-in tasks and transformations, tools for constructing packages, and the Integration Services for running and managing packages.

SSIS:

Introduction to SSIS:
1.Need for SSIS
2.SSIS Development Environment
3.SSIS Tools and DTS Comparisions
SSIS Architecture:
1.Control Flow Tasks Architecture
2.Data Flow Tasks Architecture
3.Data Pipelines and Usage
4.Conditional Precedence
Basic SSIS Entities:
1.SSIS Data Types and Conversions
2.SSIS Local & Global Variables
3.Dynamic Precedence Constraints
4.Dynamic Connection Managers
5.Data Flow Transformations usage
6.Handling Enumerations in SSIS
SSIS Customizations:
1.SCRIPT Task (.NET) in SSIS
2.Expressions and Iterations
SSIS Expressions & Debugging:
1.Expression Builder Usage
2.SSIS Parameters Usage and Variable
3.Control Flow Breakpoints
4.Data Flow Data Viewers and Audits
5.Limitations of SSIS Debugging
Data Flow Transformations:
1.Column Transformations
2.Combining and splitting data
3.Performing database operations
4.MERGE Vs UNION ALL Transformations
5.Lookup and Fuzzy Grouping
6.SORT Vs AGGREGATE Transformations
7.OLE-DB Command Tranformation
Custom Activities:
1.Data Analytics and Debugging
2.Custom Code Handling
3.Event Notifications and Emails
4.Data Sampling Techniques
5.Type I and Type II SCDs
6.Performing PIVOT operations
7.TDS Sizing and Tuning Options
Package Controls:
1.SSIS Transactions & Isolation Levels
2.SSIS Checkpoints and Usage
3.CACHE Transformation & Performance
4.CHECKSUM Transformation
Package Configurations:
1.Configurations and benefits
2.Applying Configuration Options
3.Global Configurations in DENALI
4.Choosing correct providers
Error Handling:
1.System Events and Audits
2.Package Event Handling
3.Limitations of Event Handling
4.Event Bubbling Escalations
SSIS Logging Actions:
1.Benefit of SSIS Logging
2.Environment Variables Usage
3.Windows Event Logs and SSIS
4.SQL Server Logging Limitations
5.Choosing correct log providers
6.Package Execution Audits
Processing XML Data:
1.Iterating XML nodes and Data
2.Data Profiler & ADO Connections
Deployment Procedures:
1.Preparing for Deployment
2.SSIS Deployment Phases
3.Securing Manifest Files
4.Deployment Options & ISPAC
5.Validation & Verification Techniques
File System Deployment:
1.File System Deployment
2.Package Execution Options
3.File System Security
SQL Server Deployment:
1.SQL Server Deployment
2.SSIS Catalog Files and Security
3.SQL Server Security
4.File System Versus MSDB
Deployment Management:
1.Package Migration Utilities
2.Command-Line Deployments
3.Package Backup Procedures
4.Fine-tuning Deployment
Managing Security:
1.SSIS Package Security Options
2.Encrypting SSIS packages
3.Package Store and msdb
4.Security Audits and Proxies
5.MSDB and File System Comparisions
6.Event Logging Activities
Upgrading Packages:
1.DTS packages to SSIS migration
2.Upgrading 2005 Packages to 2008
3.MSDB and SSIS Catalog Files
4.Comparing SSIS 2008 R2 & 2012
5.ISPAC (DENALI) & Package Migrations

SSRS:

Introduction to SSRS:
1.Need For Reporting Solutions
2Introduction to Reporting Services
Reporting Services Architecture:
1.Three-Phase Report Life Cycle
2.Reporting Engine Architecture
3.SSRS 2012 and Web Services
4.Configuring SSRS 2008 and 2008 R2
5.Configuring SSRS 2012 Report Server
Introduction to SSRS Tools:
1.Report Designer Usage and Scope
2.Report Builder Usage and Scope
3.Report Manager and Usage
4.RSCONFIG Tool and Limitations
Report Planning and Design:
1.SSRS Report Planning
2.Enterprise and Ad-hoc Reports
3.Optimizing Data Sources
Report DataSets:
1.Working with Multiple DataSets
2.Configuring Dynamic DataSets
Report Designs:
1.Designing Wizard based Reports
2.Designing Custom Reports
3.Using Tables and Matrix
4.Chart Based Reports and Images
5.Using SSRS Expressions & Globals
6.Sub Reports and Report Options
7.Report Testing Options
8.BUILD and DEPLOY Options
Using Report Designer:
1.Parameters and Dynamic Populations
2.Report Filters in Data Sets
3.Sub Reports and Nested Reports
4.Guage Reports, Indicator Reports
5.Pie Charts and Data Bars
6.Exporting Reporting Data
SSRS using OLAP Sources:
1.Designing Reports using OLAP DBs
2.Identifying KPIs and Measures
3.Coding MDX Queries
Report Models:
1.Need for Report Models
2.Identifying Report Entities
3.Identifying different Attributes
4.Numerical Aggregations
5.Time Calculations and Measures
6.Managing Data Source Statistics
7.Understanding SMDL Entries.
Delivering Reports:
1.Report Delivery
2.Accessing and controlling reports
3.Leveraging RS Web services
Report Builder :
1.Using Report Builder 3.0
2.Using Report Builder 4.0
3.Report Designer Vs Report Builder
Monitoring Reports:
1.Report Server Configurations Tools
2.Report Migration Wizard Usage
Managing Reports:
1.Report Manager Configurations
2.Managing Data Sources Security
3.Exporting and Importing Reports
4..Creating Global Schedules
5.Snapshot Management & Schedules
6.ReportServerTempdb Usage
7.Managing Reporting Engine
8.System Events and Audits
9.Fine-Tuning Reports
SSRS Logging:
1.Benefit of SSRS Logging (Server)
2.SSRS 2012 Logging Options
3.Report Execution Audits
4.Scheduling and Subscriptions:
5.Creating Standard Subscriptions
6.Data-Driven Subscriptions
7.Subscription & Logging Options
SSRS Security:
1.Report Data Source Security
2.Report Server Security Levels
3.Report Server DB Security
SSRS Configurations:
1.Configuration Options
2.Managing Configurations Files
3.Choosing correct Config Values
Server Upgrades:
1.Upgrading SSRS Reports
2.Upgrading SSRS Databases
3.Scale-out Deployments

SSAS:

Introduction to SSAS:
1.Datawarehouse Concepts
2.Analysis Services Architecture
3.Introduction to SSAS 2008 R2 & 2012
Data warehouse Architecture:
1.Need for Cubes and Measures
2.sIdentifying Facts and Dimensions
3.Identifying Measures and Aggregates
4.Identifying Attributes and Hierarchies
5.Datawarehouse Design Principles
6.Staging operations and usages
Basic SSAS Entities:
1.Data Source and Data Source Views
2.Manipulating structures in DSV
3.Computed and Named Queries
4.Building Entity Relationships
5.Deciding Datawarehouse Schema
Dimension Wizard:
1.Creating Dimensions and Builds
2.Attributes and Member Names
3.Choosing Dimension Templates
4.Applying Time Dimensions
5.Need for Hierarchies and Limitations
6.Attribute Relations and Uses
7.Building Levels and Hierarchies
8.Need for Composite Attribute Keys
9.Creating empty Dimensions
Cube Wizard:
1.Planning for Cube Design
2.Identifying Cube Entries
3.Measures and Additives
4.Creating Measure Groups
5.Cube Customizations and Options
6.Empty Cubes and Enhancements
Cube Operations:
1.Dimension Usage and Flexible Cubes
2.Building Fact Dimensions
3.Calculations and Conditional Colors
4.MDX Scripting for Calculations
5.Calculation Sets and Options
6.Defining KPIs and Goals
7.Perspectives and Uses
8.SSAS Actions and Coding
SSAS Partitions and Aggregations:
1.Need for Cube Partitions
2.Local and Remote Partitions
3.Need for Storage Models
4.Generation of Aggregations
MDX Specifics and Functions:
1.Need of MDX Language
2.Complex MDX Queries
3.MDX Functions & Limitations
4.PARALLELPERIOD specifics
Conditional MDX JOINS
5.Cube and Dimension Writebacks
6.MDX Transactions & Limitations
Data Mining and Forecast:
1.Need for Data Mining Structures
2.Data Mining Algorithms and Rules
3.DMX Queries and Forecast Reports
4.Data Mining Scope and Ranking
5.Prediction Functions and Analysis
SSAS Deployment:
1.Deployment Pre-requisites
2.Deployment Options and Tools
3.Creating OLAP (SSAS) Databases
4.Processing Options and stages
5.Managing Deployment Process
SSAS Logging:
1.Benefits of SSAS Logging
2.Choosing correct log providers
3.Managing SSAS Log Providers
OLAP Database Management:
1.OLAP Database Backups
2.Compressions and Encryptions
3.Restore Options and Partitions
4.Scripting Backups and XMLA
5.Scheduling Backupsand Jobs
6.DB Synchronizations and XMLA
7.Managing Partitions & Aggregations
8.DB Reports and Dashboards
9.Monitoring Execution Plans
Usage Based Optimizations (UBO):
1.Need for Optimizations and Audits
2.Designing Aggregations using UBO
3.OLAP Restore Options and XMLA
Managing Security:
1.SSAS Security Roles and Scope
2.Object Level Access and MDX
3.Drill-Through Security and MDX
4.Item Level Security and MDX
5.Dynamic Security Implementation
6.Windows Level Authentications
7.Security Audits and Query Logs
Schedules and Upgrades:
1.Using SSIS for DW Management
2.Using SSIS for XMLA Operations
3.MDX and DMX Operaitons in SSIS
4.Scheduling SSAS operations
5.Upgrading OLAP Databases (DW)
6.Comparing SSAS 2008 R2 & 2012
7.New SSAS Features in DENALI