MSBI Training Online

MSBI Training Online

MSBI Online Training course Content

SSIS Management and Security

Deployment Procedures
- Preparing for Deployment
- Primary Pre-requisites
- Deployment Phases
- Securing Manifest Files
- Deployment Options
- Verification Techniques
File System Deployment
- File System Deployment
- Package Execution Options
- File System Security
SQL Server Deployment
- SQL Server Deployment
- Package Execution Options
- SQL Server Security
- File System Versus MSDB
Deployment Management
- Configuration Limitations
- Command-Line Deployments
- SSIS Utilities and Usage
- Package Backup Procedures
- Fine-tuning Deployment

SSRS Development

Introduction to SSRS
- Need For Reporting
- Introduction to Reporting Services
- Why SQL Server Reporting Services?
Reporting Services Architecture
- Three-Phase Life Cycle
- Reporting Engine Architecture
- SSRS 2005 and IIS
- Configuring SSRS 2005
Introduction to SSRS Tools
- Report Designer
- Report Builder
- Report Manager
- RSCONFIG Tool
Report Planning and Design
- SSRS Report Planning
- Using SSIS to extract Data Sources
- Enterprise and Ad-hoc Reports
- Optimizing Data Sources
Report Data Sets
- Creating Data Sets
- Configuring Dynamic Data Sets
Report Designs
- Designing Wizard based Reports
- Designing Custom Reports
- Using Tables and Matrix
- Chart Based Reports and Images
- Using SSRS Expressions
- Using SSRS Globals
- Sub Reports and Usage
- Deployment Options
- BUILD and DEPLOY Options

Advanced Reports

Using Report Designer
- Parameters and Dynamic Populations
- Report Filters in Data Sets
- Sub Reports
- Pie Charts and Data Bars
- Exporting Reporting Data
- Understanding RDL Entries
Delivering Reports
- Report Delivery
- Accessing and controlling reports
Report Builder
- Using Report Builder 1.0
- Report Designer Vs Report Builder
Monitoring Reports
- Report Manager Tool
- Report Server Configurations
- Report Designer Vs Report Builder

Managing Reports

Managing Reports
- Report Manager Configurations
- Managing Data Sources Security
- Exporting and Importing Reports
- Creating Global Schedules
- Snapshot Management and Schedules
- ReportServerTempdb Usage
- Managing Reporting Engine
- System Events and Audits
- Event Handling
- Fine-Tuning Reports
Scheduling and Subscriptions
- Creating Standard Subscriptions
- Data-Driven Subscriptions
- Deciding the Target Paths
- Subscription Logging Options
SSRS Security
- Data Source Security
- Report Server Security Levels
- Report Server DB Security
SSRS Configurations
- Configuration Options
- Managing Configurations Files
- Choosing correct Config Values
Server Upgrades
- Upgrading SSRS Reports
- Upgrading SSRS Databases
- Scale-out Deployment

SSAS

Building and Modifying an OLAP Cube

Designing a Unified Dimension Model (UDM)
- Identifying measures and their suitable granularities
- Adding new measure groups and creating custom measures
Creating dimensions
- Implementing a Star and Snowflake Schema
- Managing Slow Changing Dimensions (SCD)
- Identifying role-play dimensions

Extending the Cube with Hierarchies

Creating hierarchies
- Building natural hierarchies
- Many-to-many hierarchies
- Creating attribute relationships
- Distinguishing between ragged, balanced and unbalanced hierarchies
- Discretizing attribute values with the Clusters and Equal Areas algorithms
Parent-child relationships
- Defining parent and key attributes
- Generating level captions with the Naming Template feature
- Removing repeated entries with the MembersWithData property

Exploiting Advanced Dimension Relationships

Storing dimension data in fact tables
- Building a degenerate dimension
- Configuring fact relationships
Saving space with referenced dimension relationships
- Identifying candidates for referenced relationships
- Utilizing the Dimension Usage tab to configure referenced relationships
Including dimensions with many-to-many relationships
- Implementing intermediate measure groups and dimensions
- Reporting on many-to-many dimensions without double counting

Designing Optimal Cubes

Assembling cube components
- Selecting the appropriate fact tables
- Adding cube dimensions
- Distinguishing between additive, semiadditive and nonadditive measures
Designing storage and aggregations
- Choosing between ROLAP, MOLAP and HOLAP
- Partitioning cubes for improved performance
- Designing aggregations with the Aggregation Design Wizard
- Leveraging the Usage-Based Optimization Wizard
Automating processing
- Exploiting XMLA scripts and SSIS
- Refreshing cubes with Proactive Caching

Performing Advanced Analysis with MDX

Retrieving data with MDX
- Defining tuples, sets and calculated members
- Querying cubes with MDX
- Navigating hierarchies with MDX and utilizing set functions
Monitoring business performance with KPIs
- Building goal, status and trend expressions
- Using PARALLELPERIOD to compare with past time periods
Creating calculations with MDX
- Adding runtime calculations to the cube
- Comparing MDX calculations with DSV calculated columns

Securing Cube Data

Securing data and simplifying the user interface

Gaining Business Advantage with Data Mining

Determining the correct model
- Identifying business tasks for data mining
- Training and testing data mining algorithms
- Comparing algorithms with the accuracy chart and classification matrix
- Optimizing returns with the Profit Chart
Performing real-world predictions
- Classifying with the Decision Trees, Neural Network and Naive Bayes algorithms
- Predicting with the Time Series algorithm
Deploying models
- Predicting new cases with algorithms
- Utilizing DMX to perform batch and singleton predictions
- Exploring results with data mining viewers

SSIS

SSIS Architecture

Basic SSIS Entities
- SSIS Data Types
- SSIS Variables
- Dynamic Precedence Constraints
- Connection Managers
- Data Flow Tasks usage
- Monitoring Data Migrations
- Handling Enumerations in SSIS
SSIS Customizations
- SCRIPT Task in SSIS
- Custom Scripting and Tuning
- Expressions and Iterations
SSIS Expressions
- Dynamic Connection Managers
- Dynamic Scripting
- Expression Builder Usage
SSIS Debugging Options
- Control Flow Breakpoints
- Data Flow Data Viewers
- Limitations of SSIS Debugging
Data Flow Transformations
- Column Transformations
- Combining and splitting data
- Data Profiling
- Managing BLOB & CLOB data
- Performing database operations
- Lookup and Fuzzy Grouping
- MERGE Vs UNION ALL Transformations
- SORT Vs AGGREGATE Transformations
- OLE-DB Command Tranformation

Advanced SSIS Development

Operating system level tasks
- FTP and SMTP Operations
- MSMQ Operations
Custom Activities
- Data Analytics and Debugging
- Custom Code Handling
- Event Notifications
- Sampling Techniques
- Type I and Type II SCDs
- Performing PIVOT operations
- Data Profiling
Package Controls
- SSIS Transactions & Isolation Levels
- Package and Task Options
- Checkpoints and usage
- Package Properties
Package Configurations
- Configurations and benefits
- Applying Configuration Options
- Choosing correct providers
- Practical Applications
Error Handling
- System Events and Audits
- Package Event Handling
- Container Event Handling
- Limitations of Event Handling
SSIS Logging
- Benefit of SSIS Logging
- Different Logging Options
- Environment Variables
- Windows Event Logs and SSIS
- SQL Server Logging Limitations
- Choosing correct log providers
- Managing Log Providers
- Package Execution Audits

Enquiry