Enquiry
Courses Images

Course Details

MSBI stands for Microsoft Business Intelligence. MSBI deals with transforming organizational data into insights that result in better decision-making in business.

This process includes maintaining data accuracy and security, discovering insights quickly and bringing information from data.

We provide the best Microsoft Business Intelligence Training In Chennai, in which one can learn SSAS, Cube Deployment, SSRS, SSIS, MDX, T-SQL Basics, Triggers, Security and SQL Server.

Lessons 1: Introduction

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

Reviews

CLIENTS

Vikapri Training WhatsApp