MSBI

Objectives of the Course

  • Business Intelligence Solution
  • Custom reporting solutions
  • Data transformation solutions

Pre-requisites:

  • Basic knowledge over Data Warehousing and SQL Server

Who should do the course:

  • BI Developers
  • Business Analyst
  • Data Mining professionals
  • Anyone who desire to make a career in the field of Business Intelligence.

Data warehousing & Business Intelligence

Introduction to Data warehousing & Business Intelligence SQL Server 2008R2 Business Intelligence

Course Agenda:

  • SQL Server 2008R2 Integration Services (SSIS)
  • SQL Server 2008R2 Analysis Services (SSAS)
  • SQL Server 2008R2 Reporting Services (SSRS)

SQL Server 2008R2 Integration Services

Introduction to SQL Server Integration Services

  • SSIS Package Architecture Overview
  • Development and Management Tools
  • The Import and Export Wizard

Guided tour of Business Intelligence Development Studio

Introduction to Data Flow

  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Flow Transformations
  • Data Viewers

Data Sources

  • Excel Source
  • Flat File Source
  • OLE DB Source
  • XML Source

Data Flow Transformations

  • Aggregate Transformation
  • Audit Transformation
  • Character Map Transformation
  • Conditional Split Transformation
  • Copy Column Transformation
  • Derived Column Transformation
  • Data Conversion Transformation
  • Multicast Transformation
  • OLE DB Command Transformation
  • Percentage Sampling Transformation
  • Row Count Transformation
  • Sort Transformation
  • Union All Transformation

Advanced Data Flow

  • Lookup Transformation
  • Merge Transformation
  • Merge Join Transformation
  • Slowly Changing Dimension Transformation
  • Pivot Transformation
  • Export Transformation
  • Import Transformation
  • Unpivot Transformation

Data Flow Destinations

  • Data Reader Destination
  • Excel Destination
  • Flat File Destination
  • OLE DB Destination

Introduction to Control Flow

  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task
  • Bulk Insert Task
  • Data Flow Task
  • Execute DTS 2000 Package Task
  • Execute Package Task
  • Execute Process Task
  • Web Service Task
  • XML Task

Advanced Control Flow

  • For Loop Container
  • For Each Loop Container
  • Sequence Container

Variables and Configurations

  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages
  • Property expressions
  • Configuration Overview
  • Configuration options
  • Configuration discipline

Debugging, Error Handling and Logging

  • SSIS debugging overview
  • Breakpoints in SSIS
  • Control Flow: The On Error event handler
  • Data Flow: Error data flow
  • Configuring Package Logging
  • Built-in log providers

Extending SSIS through Custom Code – Scripting

  • Introduction to SSIS scripting
  • The SSIS script editor
  • The SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development

SSIS Package Deployment

  • Configurations and deployment
  • The deployment utility
  • Deployment options
  • Deployment security
  • Executing packages – DTExec and DTExecUI

SSIS Package Management

  • The SSIS Service
  • Managing packages with DTUtil
  • Managing packages with SQL Server Management Studio
  • Scheduling packages with SQL Server Agent

SQL Server 2008R2 Analysis Services 

What Is Microsoft Business Intelligence?

  • Defining Microsoft Business Intelligence
  • Understanding the UDM
  • Building and Viewing a Sample Cube
  • Viewing a Cube Using Excel
  • Cubes in Reporting Services
  • Using SSAS in BIDS
  • Understanding BIDS
  • Creating Data Sources
  • Creating Data Source Views
  • Creating a Cube Using the Wizard
  • Refining Dimensions and Measures

Intermediate SSAS

  • Creating KPIs
  • Creating Perspectives
  • Creating Translations
  • Creating Actions
  • Advanced SSAS
  • Working with Multiple Fact Tables
  • Using Advanced Dimension Types
  • Working with Changing Dimensions
  • Using the Business Intelligence Wizard

Cube Storage and Aggregation

  • Basic Storage: MOLAP
  • Customized Aggregations
  • Advanced Storage: MOLAP, HOLAP, or ROLAP
  • Implementing Proactive Caching
  • Using Partitions: Relational or SSAS
  • Cube and Dimensions Processing Options

Beginning MDX

  • Understanding MDX
  • About Members, Tuples, and Sets
  • Common MDX Functions Explained
  • New or Updated MDX Functions or Keywords

Intermediate MDX

  • Understanding the Calculations Sub tab
  • Adding Calculated Members
  • Adding MDX Scripts
  • Adding Named Sets

SSAS Administration

  • Implementing SSAS Security
  • Implementing XMLA Scripts
  • Understanding SSAS Backup and Restore
  • Understanding Performance Optimization

Introduction to SSAS Clients

  • Using Excel 2007 Pivot Tables
  • Using SQL Server Reporting Services

SQL Server 2008R2 Reporting Services

SQL Server Reporting Services (SSRS) Architecture

  • Report types and formats
  • SSRS Web Services
  • Report Server
  • Report Builder
  • Model Designer
  • Data sources: SQL Server, Oracle, OLE DB

Authoring Reports

Creating basic reports

  • Tabular
  • List
  • Matrix
  • Chart
  • Constructing data sources and Datasets
  • Inserting a data region, fields and images

Leveraging expressions

  • Calculating fields
  • Integrating expressions in properties
  • Applying conditional formatting
  • Adding images

Grouping and sorting data

  • Grouping to multiple levels
  • Sorting the results
  • Employing aggregate functions

Implementing Parameters and Filters

Building parameters into reports

  • Returning subsets of data with query parameters
  • Mapping report parameters to query parameters
  • Building cascading report parameters
  • Passing parameters to stored procedures
  • Exploiting multivalve parameters

Restricting report data with filters

  • Enhancing performance with filters
  • Filters vs. query parameters
  • Localizing tables and queries

Leveraging Advanced Reporting Features

Combining data regions in one report

  • Utilizing sequential and nested regions
  • Producing master/detail reports
  • Linking sub reports

Presenting data with appropriate detail

  • Revealing report detail with drill down
  • Displaying related data with drill through
  • Navigating with document maps

Deploying and Delivering Reports

Deploying reports to the server

  • Preparing reports for publishing
  • Configuring project properties
  • Units of deployment: Individual reports, projects, solutions, data sources
  • Checking results with Report Manager

Securing Reporting Services

Securing the RS environment

  • Assigning users to roles
  • Setting permissions on report items
  • Granting and revoking system-level permissions

Creating reports with Report Builder

  • Deploying Report Builder to users
  • Dragging and dropping entities onto charts and tabular reports
  • Navigating data with infinite drill through

share training and course content with friends and students:

  • msbi contents
  • msbi classes hyderabad
  • msbi course details
  • msbi course duration
  • datawarehouse nareshtechnologies
  • msbi course fee in hyderabad
  • Msbi co
  • msbi course
  • msbi course content
  • msbi advanced topics