For training related to .net,OOPS,design patterns, MVC,WCF and .net fundamentals
contact at sukeshmarla@gmail.com or Click Here

22 December 20123

Technical Training at reasonable price

For technical training on various topics including asp.net,WCF,MVC and Design Patterns contact SukeshMarla@Gmail.com

20 March 2014

Learn SSIS SSAS SSRS

Course Fee - 23k
  • Introduction to Data warehousing and Business Intelligence
  • SSIS vs SSAS vs SSRS
  • Understand Facts and Dimensions,
  • Understand OLTP and OLAP
  • SSIS - Introduction to SSIS
  • SSIS - Simple SSIS Example
  • SSIS - Creating and deploying SSIS Package
  • SSIS – Control Flow Introduction
  • SSIS – Connection Managers
  • SSIS – Demo on Execute Sql Task
  • SSIS – Demo on Send Mail Task
  • SSIS –  Precedence and Annotations
  • SSIS – Demo on File Task
  • SSIS – Demo on FTP Task
  • SSIS – Demo on Web Service Task
  • SSIS – Demo on Xml task
  • SSIS – Demo Data profiling Task
  • SSIS – Demo on Message Queue
  • SSIS – Demo on Bulk insert Task
  • SSIS – Conatiners
  • SSIS – Data Flow Introduction
  • SSIS – Demo on Different Data Flow sources
  • SSIS – Demo on Different Data Flow Destinations
  • SSIS – Demo on Copy Column
  • SSIS – Demo on Data Conversion
  • SSIS – Demo on Derived column
  • SSIS – Demo on Sort
  • SSIS – Demo on Pivot
  • SSIS – Demo on Lookup
  • SSIS – Demo on Conditional split
  • SSIS – Demo on Lookup
  • SSIS – Demo on Union all
  • SSIS – Demo on MultiCast
  • SSIS – Demo on Merge
  • SSIS – Demo on Merge Join
  • SSIS – Demo on Audit
  • SSIS – Demo on Expressions
  • SSIS – Demo on Scripting
  • SSIS – Demo on Debugging Packages
  • SSIS – Demo on Error handling
  • SSIS – Slowly Changing Dimension
  • SSIS – Demo on Fuzzy lookup
  • SSIS – performance
  • Introduction to SSAS
  • SSAS – Creating Dimensions
  • Understand Normalization and Denormalization
  • Star Flex vs Snow Flex Design
  • Creating Cube
  • Working with Calculated members
  • Parent Child relationship
  • Aggregations
  • SSAS - Deployment
  • Security
  • MDX
  • SSRS – Introduction
  • SSRS Architecture
  • Connect SSRS to cubes
  • Working with parameters
  • Cross matrix reports
  • Aggregated values
  • Gauge and Chart report
  • Formatting
  • Sorting
  • Security
  • Report by web services
  • Introduction to Power pivot