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

  • Distinguishing between perspective feature and security
  • Creating roles for administrative privileges
  • Securing dimension data
  • Implementing cell-level security

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

  • Basic SSIS Development
  • Introduction to SSIS
  • What is SSIS?
  • Need for SSIS
  • SSIS and Management Studio [SSMS]
  • SSIS and DTS Comparisons


SSIS Architecture

  • Control Flow Architecture
  • Data Flow Architecture
  • Data Pipeline Usage
  • Buffer Management
  • Precedence Constraints
  • 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