Ambedkara

Years of Experience in ETL Training

11

Teaching Experience in detail in ETL Training

Having 11+ years of experience in IT, speciallly into DW& BI technologies Having 5 years experience in provide training on Talend, MSBI , SAP BO Will provide running notes and material Will provide interview assistance and job support.

Years of Experience in Data Warehouse Training

11

Years of Experience in MSBI Training

11

Teaching Experience in detail in MSBI Training

Data warehousing & Business Intelligence Introduction to Data warehousing & Business Intelligence SQL Server 2008R2 Business Intelligence Course Agenda: SQL Server 2008R2 Integration Services (SSIS) SQL Server 2008R2 Analysis Services (SSAS) SQL Server 2008R2 Reporting Services (SSRS) SQL Server 2008R2 Integration Services Introduction to SQL Server Integration Services SSIS Package Architecture Overview Development and Management Tools The Import and Export Wizard Guided tour of Business Intelligence Development Studio Introduction to Data Flow Data Flow Overview Data Sources Data Destinations Data Flow Transformations Data Viewers Data Sources Excel Source Flat File Source OLE DB Source XML Source Data Flow Transformations Aggregate Transformation Audit Transformation Character Map Transformation Conditional Split Transformation Copy Column Transformation Derived Column Transformation Data Conversion Transformation Multicast Transformation OLE DB Command Transformation Percentage Sampling Transformation Row Count Transformation Sort Transformation Union All Transformation Advanced Data Flow Lookup Transformation Merge Transformation Merge Join Transformation Slowly Changing Dimension Transformation Pivot Transformation Export Transformation Import Transformation Unpivot Transformation Data Flow Destinations Data Reader Destination Excel Destination Flat File Destination OLE DB Destination Introduction to Control Flow Control Flow Overview Precedence Constraints The Execute SQL Task The Bulk Insert Task The File System Task The FTP Task The Send Mail Task Bulk Insert Task Data Flow Task Execute DTS 2000 Package Task Execute Package Task Execute Process Task Web Service Task XML Task Advanced Control Flow For Loop Container For Each Loop Container Sequence Container Variables and Configurations Variables Overview Variable scope SSIS system variables Using variables in control flow Using variables in data flow Using variables to pass information between packages Property expressions Configuration Overview Configuration options Configuration discipline Debugging, Error Handling and Logging SSIS debugging overview Breakpoints in SSIS Control Flow: The On Error event handler Data Flow: Error data flow Configuring Package Logging Built-in log providers Extending SSIS through Custom Code – Scripting Introduction to SSIS scripting The SSIS script editor The SSIS object model Script in Control flow: The Script Task Script in Data flow: The Script Component Introduction to SSIS component development SSIS Package Deployment Configurations and deployment The deployment utility Deployment options Deployment security Executing packages – DTExec and DTExecUI SSIS Package Management The SSIS Service Managing packages with DTUtil Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent