Follow Us:

Microsoft Business Intelligence Training in Chennai


Course Duration

40 Hours
Sign in with Facebook Sign in with Facebook

About Microsoft Business Intelligence

  • MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries.
  • This tool uses Visual studio along with SQL server. It empower users to gain access to accurate and up-to-date information for better decision making in an organization.
  • It offers different tools for different processes which are required in Business Intelligence (BI) solutions.
  • 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.