Need of SSIS for ETL Operations, Data Warehouse Design and SSIS, DW Components and SSIS Tools, SSIS Configuration and Catalog DB, Control Flow Tasks Architecture, Data Flow Tasks Architecture, Data Pipelines and Buffer Usage, SSIS Data Types and Conversions, SSIS Local & Global Variables, Dynamic Precedence Constraints, Dynamic Connection Managers, Handling Enumerations in SSIS, Expressions and Iterations, SCRIPT Task usage in SSIS

Conditional Precedence Expressions, SSIS Parameters Usage and Variable, Control Flow Breakpoints

Row and Column Transformations, Combining and splitting datasets, Performing database operations, MERGE Vs UNION ALL Transformations, Lookup, Fuzzy Grouping, OLE-DB Command, SORT Vs AGGREGATE Transformations, Custom Code Handling in DW, Event Notifications and Emails, Data Sampling and Data Delta, Type I and Type II SCDs, Performing PIVOT operations, SSIS Transactions & Isolation Levels, CHECKSUM Transformation in DW, Iterating XML nodes and Data, CACHE Transformation & Performance, Applying Configuration Options, Parent – Child Parameters & Options, Data Flow Transformations usage, Data Flow Data Viewers and Audits

Configurations and benefits, System Events and Audits, Package Event Handling, Limitations of Event Handling, Event Bubbling Escalations, Benefits of SSIS Logging, Environment Variables Usage, Windows Event Logs and SSIS, SQL Server Logging Limitations, Choosing correct log providers, Package Execution Audits

Deployment Versioning & Options, SSIS Deployment Phases & Manifest Files, Project Packaging and ISPAC Files, Validation & Verification Techniques, SSIS Checkpoints and Usage, Data Analytics and Debugging, Data Profiler & ADO Connections

Package Execution OptionsFile System Security Limitations, SSIS Deployment & DB Engine, SSIS Catalog Project Files, Package Migration Utilities, Command-Line Deployments, TDS Sizing and Tuning Options

Encrypting SSIS CatalogsPackage Store and SSISDB, Security Audits and Reports, Container and Package Logging, DTS packages to SSIS migration, Upgrading 2008 Packages to 2012, MSDB and SSIS Catalog Files, Comparing SSIS 2008 R2 & 2012, ISPAC Files & Package Migrations

Need of OLAP Databases and DW Store, Tabular & Multidimensional Modes, Need for Cubes and Measures, Identifying Facts and Dimensions, Identifying Measures and Aggregates, Identifying Attributes and Hierarchies

Data Source and Data Source Views, Computed and Named Queries, Building Entity Relationships, Deciding Data Warehouse Schema, Creating Dimensions and Builds, Attributes and Member Names, Choosing Dimension Templates, Applying Time Based Dimensions, Need for Hierarchies and Limitations, Attribute Relations and Uses, Building Levels and Hierarchies, Need for Composite Attribute Keys

Identifying Cube Entries for FASMI Rules, Measures and Additives (Full and Semi), Defining Measure Groups and Measures, Cube Customizations and Options, BI Enhancements and Granularity, Building Fact Less Cube Dimensions, Calculations and Conditional Colors, MDX Scripting for Calculations, Defining KPIs and Goals using MDX, Perspectives using MDX Expressions, SSAS Actions with MDX and XMLA, Need for Cube Partitions and Query Binding, Local and Remote Server Partitions, Need for Storage Models – MOLAP and ROLAP, Generation of Aggregations on Partitions, Storage Modes and Proactive Caching, Hierarchies and Relations in Tabular Mode, TIME Dimensions in Tabular Mode

MDX Language Syntax & Statements, MDX Functions & JOINS, Complex MDX Queries & FILTERS, PARALLELPERIOD, TIME Functions, Conditional FILTERED JOINS in MDX, Cube and Dimension Write backs, MDX Transactions & Limitations

Need for Data Mining Structures, Data Mining Algorithms and Rules, DMX Queries and Forecast Reports, Data Mining Scope and Ranking, Prediction Functions and Analysis

Deployment Options and Tools, Creating OLAP (SSAS) Databases, Processing Options and stages, SSAS Database and Cube Audits, Managing SSAS Log Providers, OLAP & Tabular Database Backups, Restore Options and Partitions, Scripting DB Backups and XMLA, Scheduling Backups and Jobs, DB Synchronizations and XMLA, Managing Partitions & Aggregations

Need for Optimizations and Audits, Designing Aggregations using UBO, OLAP Restore Options and XMLA, SSAS Security Roles and Scope, Object Level Access and MDX, Drill-Through Security and MDX, Item Level Security and DAX Filters, Dynamic Security Implementation, Security Audits and Cube Access Logs, Upgrading OLAP Databases (DW), OLAP DB Synchronization Script

Introduction to Reporting Services, Three-Phase Report Life Cycle, Reporting Engine Architecture, SSRS 2012 and Web Service URLs, SSRS 2012 Configuration & Ports

Report Designer Usage and Scope, Report Builder Usage and Scope, Report Manager and Options, Report Delivery & Layout Planning, Enterprise and Ad-hoc Reports, Working with Multiple Datasets, Configuring Dynamic Datasets

Designing Wizard based Reports, Designing Custom Reports, Using Tables and Matrix, Chart Based Reports and Images, Using SSRS Expressions & Global Fields, Sub Reports and Report Options, Report Testing and auto Refresh, BUILD and DEPLOY Options, Parameters and Dynamic Populations, Report Filters in Data Sets, Sub Reports and Nested Reports, Gauge Reports, Indicator Reports, Pie Charts and Data Bars, Exporting Reporting Data

Designing Reports using OLAP DBs, Identifying KPIs and Measures, MDX Queries in Cube Reports, Report Models and parameters, Identifying Report Entities, Identifying different Attributes, Aggregations Based Expressions Calculations, Remote Data Sources & Data Sets, Linked Reports and Graphs

Using Report Builder Wizards, Map Reports with UI and Site Settings, Report Parts and Web Services,Report Designer Vs Report Builder, Report Server Configurations Tools, Report Migrations and Precautions

Report Delivery Options & Schedules, Accessing and controlling reports, Leveraging RS Web services, Choosing between Rendering Formats

Report Manager Configurations, Managing Data Sources Security, Exporting and Importing Reports, Creating Global Schedules – Site Level, Snapshot Management & Schedules, Regenerating Snapshots for Tuning Options, Report Server Temp database Usage, Tuning Reports with Caching Options

Creating Standard Subscriptions, Data-Driven Subscriptions, Subscription & Logging Options

Report Data Source Security, Report Server Security Levels, Report Server DB Security

Report (RDL) Configurations, Email Based Report Subscriptions, Managing Configurations Files, Choosing correct Configuration Values, RDL Reports Upgrades & Downloads, Scale out Deployments in SSRS, Execution Accounts and SSRS Schedules