MSBI

MSBI

MS BI online training 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
•Update able 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