MS BI 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
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