MICROSOFT BUSINESS INTELLIGENCE (MSBI: SSIS, SSAS, SSRS)

Module 1 - SQL Server Integration Services (SSIS)

SSIS Architecture and DW Concepts Event Logging and Event Handling

Need of SSIS for ETL Operations Configurations and benefits
Data Warehouse Design and SSIS System Events and Audits
DW Components and SSIS Tools Package Event Handling
SSIS Configuration and Catalog DB Limitations of Event Handling
Control Flow Tasks Architecture Event Bubbling Escalations
Data Flow Tasks Architecture Benefits of SSIS Logging
Data Pipelines and Buffer Usage Environment Variables Usage
SSIS Data Types and Conversions Windows Event Logs and SSIS
SSIS Local & Global Variables SQL Server Logging Limitations
Dynamic Precedence Constraints Choosing correct log providers
Dynamic Connection Managers Package Execution Audits
Data Flow Transformations usage
Handling Enumerations in SSIS Deployment Procedures
Expressions and Iterations Deployment Versioning & Options
SCRIPT Task usage in SSIS SSIS Deployment Phases & Manifest Files
Project Packaging and ISPAC Files
SSIS Expressions & Debugging Validation & Verification Techniques
Conditional Precedence Expressions SSIS Checkpoints and Usage
SSIS Parameters Usage and Variable Data Analytics and Debugging
Control Flow Breakpoints Data Profiler & ADO Connections
Data Flow Data Viewers and Audits
Deployment Options & Utilities
Data Flow Transformations Package Execution Options
Row and Column Transformations File System Security Limitations
Combining and splitting datasets SSIS Deployment & DB Engine
Performing database operations SSIS Catalog Project Files
MERGE Vs UNION ALL Transformations Package Migration Utilities
Lookup, Fuzzy Grouping, OLE-DB Command Command-Line Deployments
SORT Vs AGGREGATE Transformations TDS Sizing and Tuning Options
Custom Code Handling in DW
Event Notifications and Emails SSIS Package Security and Upgrades
Data Sampling and Data Delta Encrypting SSIS Catalogs
Type I and Type II SCDs Package Store and SSISDB
Performing PIVOT operations Security Audits and Reports
SSIS Transactions & Isolation Levels Container and Package Logging
CHECKSUM Transformation in DW DTS packages to SSIS migration
Iterating XML nodes and Data Upgrading 2008 Packages to 2012
CACHE Transformation & Performance MSDB and SSIS Catalog Files
Applying Configuration Options Comparing SSIS 2008 R2 & 2012
Parent Child Parameters & Options ISPAC Files & Package Migrations

_____________________________________________________________________________________
SQL School (SequelGate Innovative Technologies Pvt. Ltd.) #302, Sai Manor Complex, SR Nagar,
Hyderabad - 38, India. Tel: 040 64577244 (Off), +9109666440801 (Mobile) www.sqlschool.com
Module 2 - SQL Server Analysis Services (SSAS)

Introduction to SSAS and DW Storage MDX Functions, FILTERS and JOINS

Need of OLAP Databases and DW Store MDX Language Syntax & Statements
Tabular & Multidimensional Modes MDX Functions & JOINS
Need for Cubes and Measures Complex MDX Queries & FILTERS
Identifying Facts and Dimensions PARALLELPERIOD, TIME Functions
Identifying Measures and Aggregates Conditional FILTERED JOINS in MDX
Identifying Attributes and Hierarchies Cube and Dimension Write backs
MDX Transactions & Limitations
SSAS Design Entities & Cube Usage
Data Source and Data Source Views Data Mining and Forecast
Computed and Named Queries Need for Data Mining Structures
Building Entity Relationships Data Mining Algorithms and Rules
Deciding Data Warehouse Schema DMX Queries and Forecast Reports
Creating Dimensions and Builds Data Mining Scope and Ranking
Attributes and Member Names Prediction Functions and Analysis
Choosing Dimension Templates
Applying Time Based Dimensions Deployment (Tabular & Multidimensional)
Need for Hierarchies and Limitations Deployment Options and Tools
Attribute Relations and Uses Creating OLAP (SSAS) Databases
Building Levels and Hierarchies Processing Options and stages
Need for Composite Attribute Keys SSAS Database and Cube Audits
Managing SSAS Log Providers
KPI Calculations and Partitioned Aggregations OLAP & Tabular Database Backups
Identifying Cube Entries for FASMI Rules Restore Options and Partitions
Measures and Additives (Full and Semi) Scripting DB Backups and XMLA
Defining Measure Groups and Measures Scheduling Backups and Jobs
Cube Customizations and Options DB Synchronizations and XMLA
BI Enhancements and Granularity Managing Partitions & Aggregations
Building Fact Less Cube Dimensions
Calculations and Conditional Colors OLAP Management (Tabular & Multidimensional)
MDX Scripting for Calculations Need for Optimizations and Audits
Defining KPIs and Goals using MDX Designing Aggregations using UBO
Perspectives using MDX Expressions OLAP Restore Options and XMLA
SSAS Actions with MDX and XMLA SSAS Security Roles and Scope
Need for Cube Partitions and Query Binding Object Level Access and MDX
Local and Remote Server Partitions Drill-Through Security and MDX
Need for Storage Models MOLAP and ROLAP Item Level Security and DAX Filters
Generation of Aggregations on Partitions Dynamic Security Implementation
Storage Modes and Proactive Caching Security Audits and Cube Access Logs
Hierarchies and Relations in Tabular Mode Upgrading OLAP Databases (DW)
TIME Dimensions in Tabular Mode OLAP DB Synchronization Script

_____________________________________________________________________________________
SQL School (SequelGate Innovative Technologies Pvt. Ltd.) #302, Sai Manor Complex, SR Nagar,
Hyderabad - 38, India. Tel: 040 64577244 (Off), +9109666440801 (Mobile) www.sqlschool.com
Module 3- SQL Server Reporting Services (SSRS)

Reporting Services Architecture Report Builder Usage & Schedules

Introduction to Reporting Services Using Report Builder Wizards
Three-Phase Report Life Cycle Map Reports with UI and Site Settings
Reporting Engine Architecture Report Parts and Web Services
SSRS 2012 and Web Service URLs Report Designer Vs Report Builder
SSRS 2012 Configuration & Ports Report Server Configurations Tools
Report Migrations and Precautions
Report Design with Data Sets & Aggregates
Report Designer Usage and Scope Delivering SSRS Reports
Report Builder Usage and Scope Report Delivery Options & Schedules
Report Manager and Options Accessing and controlling reports
Report Delivery & Layout Planning Leveraging RS Web services
Enterprise and Ad-hoc Reports Choosing between Rendering Formats
Working with Multiple DataSets
Configuring Dynamic DataSets Managing Reports
Report Manager Configurations
Sub Reports Parameters & Filters Managing Data Sources Security
Designing Wizard based Reports Exporting and Importing Reports
Designing Custom Reports Creating Global Schedules Site Level
Using Tables and Matrix Snapshot Management & Schedules
Chart Based Reports and Images Regenerating Snapshots for Tuning Options
Using SSRS Expressions & Global Fields ReportServerTempdb Usage
Sub Reports and Report Options Tuning Reports with Caching Options
Report Testing and auto Refresh
BUILD and DEPLOY Options Scheduling and Subscriptions
Parameters and Dynamic Populations Creating Standard Subscriptions
Report Filters in Data Sets Data-Driven Subscriptions
Sub Reports and Nested Reports Subscription & Logging Options
Gauge Reports, Indicator Reports
Pie Charts and Data Bars SSRS Report Security
Exporting Reporting Data Report Data Source Security
Report Server Security Levels
Cube Reports and Report Models Report Server DB Security
Designing Reports using OLAP DBs
Identifying KPIs and Measures SSRS Configurations
MDX Queries in Cube Reports Report (RDL) Configurations
Report Models and parameters Email Based Report Subscriptions
Identifying Report Entities Managing Configurations Files
Identifying different Attributes Choosing correct Configuration Values
Aggregations Based Expressions Calculations RDL Reports Upgrades & Downloads
Remote Data Sources & Data Sets Scale-out Deployments in SSRS
Linked Reports and Graphs Execution Accounts and SSRS Schedules

_____________________________________________________________________________________
SQL School (SequelGate Innovative Technologies Pvt. Ltd.) #302, Sai Manor Complex, SR Nagar,
Hyderabad - 38, India. Tel: 040 64577244 (Off), +9109666440801 (Mobile) www.sqlschool.com
Pre-requisites:
To attend for our practical MSBI Trainings, the participant needs to have basic SQL Server knowledge on Database
Design, Table Design, T-SQL Data Types, Constraints, Views, Indexes, Stored Procedures and Functions.

All the concepts will be discussed practically. We provide Study Material, Interview & Certification Guidance along
with one Real Time Case Study for this course. 24x7 LIVE Server access with Virtual Lab facility available.

About Trainer:
Mr. Sai Phanindra Tholeti, having 7+ years of experience exclusively on SQL Server & BI is a Database Consultant
working for his own company - SequelGate Innovative Technologies Pvt. Ltd. He renders technical and support
services for corporate clients involving Database Hosting, Business Consulting, CLOUD Storage (AZURE) and Data
Support activities. All training sessions are completely practical, real-time and highly interactive.
Complete profiler of the trainer available @ http://www.linkedin.com/in/saiphanindra

Training Highlights:
Real-time Sessions and Completely Interactive
Complete Practical Sessions
Study Material
Screenshot based Practice Material
Session wise notes & Doubts Clarifications
Certification Material
Resume Preparation
Interview Questions and Guidance
Free Workshops & Technical Support
Videos for missing sessions
THREE Real-time Case Studies
24x7 LIVE Server Access
Virtual Lab Facility

Joining Procedure:
Participant needs to attend for a free demo. Registrations accepted after attending the demo session. Payment
details to be shared after you attend free demo.

For Free demo / Further Clarifications:

Reach us: 0 9666440801 (Mobile) (Country: India. Telephone Code: 0091)
040 64577244 (Office)
040 66343536 (Office)

Mail us: contact@sqlschool.com

Skype: SQL School

For Course Fee and Free Demo schedules, you may also refer to http://sqlschool.com/contact.html

Training Faqs available at http://sqlschool.com/faq.html

_____________________________________________________________________________________
SQL School (SequelGate Innovative Technologies Pvt. Ltd.) #302, Sai Manor Complex, SR Nagar,
Hyderabad - 38, India. Tel: 040 64577244 (Off), +9109666440801 (Mobile) www.sqlschool.com