Follow Us:

Microsoft Business Intelligence Training in Chennai


Course Duration

40 Hours Sign in with Facebook Sign in with Facebook

Course Contents

Microsoft Business Intelligence
    MS BI Course Content Microsoft Business Intelligence(MSBI)
  • Introduction to BI
  • Introduction to data warehouse and data mart
  • Why MSBI?
  • Working with BIDS- Business Intelligence development studio
  • SQL Server Analysis Services (SSAS) Objectives:
  • Developing Analysis Services Solutions
  • Create cube
  • Schema- Star and Snow flacks
  • Create fact table
  • Create Dimension Table
  • Configuring Dimensions
  • Defining Hierarchies
  • Measures and Measure Groups
  • Working with Measures
  • Working with Measure Groups
  • Implement dimensions in an Analysis Services solution
  • Implement measures and measure groups in an Analysis
  • Services solution
  • Customize an Analysis Services cube
  • Deploy and secure an Analysis Services database
  • Cube Deployment, Browsing cube
  • Multiple Fact Table
  • Enhance Cube Functionality
  • KPI
  • Actions
  • Perspectives
  • Translations
  • SQL Server Reporting services (SSRS) Objectives:
  • Overview of SQL Server Reporting Services
  • Reporting Services Tools and Architecture-
  • Configure reporting service- IIS
  • Creating reports- using cube, data source,
  • Matrix report, Chart
  • Drill down , drill –through reports
  • Creating report parameters, dropdown parameters
  • Creating expression
  • Creating groups
  • Deploying reports and data source
  • Report Snap shots and subscription-
  • standard and data driven subscription
  • Managing subscription
  • Report using Microsoft Excel-
  • SQL Server Integration services (SSIS) Objectives:
  • Introduction to SQL server integration service
  • Working with SSIS packages
  • The import and export wizard for DBA’s using SQL server Management studio
  • SSIS Package designer
  • Control flow
  • Data flow-
  • Understanding Data Flow
  • Designing Data Flow Operations
  • Handling Data Changes
  • Error handling
  • Logging, Error Handling and Reliability
  • Logging ETL Operations
  • Handling Errors in SSIS
  • Implementing Reliable ETL Processes with SSIS
  • Contents: Planning for ETL
  • Identifying Data Sources and Destinations
  • Evaluating Source Data
  • Identifying Staging Requirements
  • Planning Packages
  • Planning Package Development
  • Designing Package Control Flow
  • Deploying and Operating an SSIS Solution
  • Deploying SSIS Packages
  • Operating an SSIS Solution
  • Multidimensional Expressions (MDX)
  • Basic MDX,
  • MDX Function
  • This Section for the people who does not have the prior SQL server experience or knowledge. Introduction to SQL Server 2008
  • Overview and Introducing SQL Server
  • Installation Microsoft SQL server 2005 including SSAS, SSIS, SSRS
  • SQL Server Management Studio
  • Building a Database
  • Create and alter tables
  • Create and alter tables
  • Create and alter indexes
  • Relations
  • T-SQL Basics
  • SELECT clause
  • FROM clause
  • WHERE clause
  • Using Joins- Different types of joins
  • ORDER BY
  • GROUP BY and HAVING
  • TOP N and TOP N%
  • OVER
  • Full-text search
  • DELETE
  • TRUNCATE TABLE
  • UPDATE
  • INSERT
  • SELECT INTO
  • Views, Stored Procedures, and Functions
  • Partitioning and Joining Tables with Views
  • Updateable views
  • Indexed Views
  • Information Schema Views
  • Catalog Views
  • Create and alter stored procedures
  • Functions
  • Triggers
  • INSERT triggers
  • DELETE triggers
  • UPDATE triggers
  • Security and SQL Server
  • Security modes and authentication
  • Database user accounts
  • Permissions
  • Database roles
Register Now

You will Learn How To :

Course Benefits :

Register Now

Please use the form below to make your career excellent.