About msbi classroom training in hyderabad

• From: kosmik.adv@gmail.com
• Posted: 06/08/2015 09:26PM
• City: Hyderabad
• State: TELANGANA
• Phone Number: 9032337979
• Description:
• SQL Server Integration Service- SSIS Chapter-1 Introduction to BI and other BI tools * Introduction to BI * Difference between BI, DWH, Data Mining and Data Mart * Future for BI * MSBI and its Modules Chapter -2 - Introduction to SSIS * SSIS Framework/Architecture * SSIS Overview of Components * Blocked VS Non-Blocked Transformations * Synchronous and Asynchronous Transformations Chapter -3-Control Flow Elements * Precedence Constraints * Containers * For Loop Container * For Each Loop Container * Sequence Container * Tasks * 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 Package Task * Execute Process Task * Script Tasks Chapter -4-Data Flow Transformations * Sort Transformation * 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 * Union All Transformation * Advanced Transformations * Lookup Transformation * Merge Transformation * Merge Join Transformation * Slowly Changing Dimension Transformation * Export and Import Transformation * Pivot and Unpivot Transformation Chapter-5- Debugging, Error Handling and Logging * SSIS debugging overview * Configuring Package Logging * Breakpoints in SSIS * Event handler in SSIS * Configure Error output in Data Flow * Data Viewers * Configure Check Points * Transactions in SSIS * SSIS Security Chapter-6- Data Profiling and Data Cleansing * Fuzzy Lookup Transformation * Fuzzy Grouping Transformation Chapter-7-SSIS Deployment * Create Configuration Files * Implement Logging * Different Deployment Options * Executing packages using utilities – DTExec and DTExecUI * Schedule SSIS Packages with SQL Server Agent Jobs * Monitoring Jobs in SQL Server * Call SSIS Packages in Stored Procedures * Call SSIS Packages in cmd prompt * SQL Server Analysis Service- SSAS Chapter-1- Introduction to SSAS * Brief Introduction to SSAS and ITS Components * BIDS Environment for SSAS * Creating Project SSAS Chapter-2-Dimensional Modeling * Introduction to Dimensions and Fact Tables * Snowflake and Star Schema Methodology * Building Data Warehouse * Loading Data using OLTP to OLAP using SSIS Packages * Full and Incremental Loading of Data * Understand Dimensions and Facts * Types of Dimension and Facts * Fact less Fact Table * SSAS Architecture Chapter-3-Data Source and DSV * Introduction and Creation of DS, DSV * Named Queries * Options in DSV Chapter-4-Cube Designing and development * Different Ways to Create CUBE * Measures and Measure Groups * Diff between BUILD, DEPLOY and PROCESS * Calculated Columns Chapter-5-Hierarchies * Creating and Managing Hierarchies * Translations Chapetr-6-Intro to MDX * Syntax of MDX * Understanding MDX * About Members, Tuple and Sets * Common MDX Functions * New or Updated MDX Functions or Keywords * Understanding the Calculations * Adding Calculated Members Chapter-7-Processing Options * Understanding Processing * Different Processing Options Chapter-8- Relationships * Different Types of Relationships * Creating Relationship between Fact and Dimensions Chapter-9-Storage Modes * Different Storage Modes * How to select different Storage Modes Chapter-10-Partitions-Aggregations * What are Partitions and How to create Partitions? * On what basis a Partition are created? Chapter-11-Actions, Calculations, Perspectives and KPIs * What are Actions and How to create IT? * Understand KPIs and Create KPIs * Understand Calculations and Create Calculations * Creating Perspectives Chapter-12-Deploying the Cube * Generate XMLA Script and Deploy a Cube in SQL Server * Create Jobs to process the cube in SQL Server * Different Approaches to Deployment * Client Interactions with Excel * SQL Server Reporting Services – SSRS Chapter-1-Introduction to SSRS * Architecture of SSRS * Components in SSRS * Phases of Report Development Life Cycle * What is a Report? Chapter-2-Creating Basic Report in SSRS * Wizard to develop SSRS Report * Shared Vs. Embedded Data Sources & Data Sets Chapter -3-Report Authoring * Table Reports and Matrix Reports * Report Designer Paging Options * Drill-down Reports * Chart Reports, Indicator, Gauge Control Reports * List Reports * Use Page Header and Page Footer * Drill-Through or Linked Reports * Sub Reports * Create Report Template and use it in new Reports * Parameter Reports * Single Parameter * Multiple Parameters * Cascading Parameter * Create Calendar in Parameters * Default Values and Drop Down list options * Expressions in SSRS * Understand conditional formatting * Adding images * Grouping and Sorting * Page Header and Page Footer * Aggregate Functions * Sub Totals and Grand Totals * Document Map Reports * Create Reports with Stored Procedures * Create Reports with SSAS Cube Chapter-4- Deploying Reports * Report Server Configuration * Configure Report Server details in SSRS Project * Report Deployment to Report Server Chapter-5-Report Manager and Delivery * Report Builder to create ad-hoc Reports * Create Linked Reports * Create Subscriptions * Standard Subscriptions * Data Driven Subscriptions * Cache a Report * Snapshot a Report * Report Logging For any further details please contact +91-9032337474 or visit www.kosmiktechnologies.com Please mail your queries to trainings@kosmiktechnologies.com