Microsoft Business Intelligence Training Module

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.
  • Duration

    40 Hours

    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

    You have gone through all the training and reading material, since you decided to choose your career. This might have given you initial understanding about the procedures and techniques and you are even able to pass your certification as well ...

    Best - SAP training center in London.