Tag Archives: Online MSBI Training

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