twg-group-chennai

MSBI TRAINING IN CHENNAI :

SYLLABUS :


SQL Server Integration Services (SSIS) :


  • Introduction to SSIS Packages and Legacy DTS Packages
  • Introduction of (BIDS) and Explanation of All tool boxes, Solution Explorer, Package variables
  • Import and Export Wizard, Control Flow and Dataflow tasks
  • Control Flow tasks like Execute SQL Task, BULK insert tasks, File System tasks , The FTP Task and Send mail task
  • Dataflow tasks and transformations introduction
  • Data sources, Data transformations, Copy column Transformation, Derived Column transformation, Conditional Split and Aggregate Transformation, Sort Transformation and Data Viewers.
  • Slowly Changing Dimension (SCD) Concepts and its Transformations.
  • Debugging, Error Handling and Logging
  • How to implement Check points.
  • SSIS Package Deployment and Package Management like how to schedule package , DTUtil and DTExec command.
 

SQL Server Analysis Services (SSAS) :


  • Introduction to Data Warehousing, OLTP, OLAP, Star Schema and Snow Flake schema.. etc
  • Understanding Dimension Modeling
  • Creating Data source and Data source views
  • Creating the Cube through Wizard and through UDM.
  • Creating Dimensions and Measures in SSAS and how to add those in Cube.
  • Partitions and Aggregations Design in cube and Processing Options in cube.
  • Key Performance Indicators(KPI) , Perspectives and Translations .
  • What is Build , Deploy and process in cube.
  • How to do Slice and Dice in the Cube .
  • How to retrieve the data in Cube i.e Through MDX .
  • Full Coverage of MDX and its functions from Basics to Advanced.
  • What is Role and How to give Cube access to a Login.
  • Different Options for Deploying a Cube.
  • How to take Cube backup and how to synchronize the cube from one server to another server and how to do that with XMLA query
  • How to take the report from Cube in Excel and Power Pivot
 

SQL Server Reporting Services (SSRS) :


  • What is the Terminology involved in SSRS, SSRS Architecture and how to configure SSRS.
  • What is Shared Data source and How to Create an Ad-hoc Report from Wizard.
  • Creating Expressions and Conditional Formatting.
  • How to Calculate Total and Percentage and how to create Drill-Down reports.
  • Creating Report Parameter and Debugging Parameter issues.
  • How to create a Basic Matrix Report , Tablix Report and Charts.
  • How to Create a Standard and Data-driven Subscription and managing subscriptions.
  • Managing Reports, Security and how to use Web-based Report Manager.

 

CONTACT ADDRESS :

CHENNAI BRANCH

no.5, boopathy street, virugambakkam,
virugambakkam - bus stop opposite chennai , tamil nadu , india.
tel: 044 - 420 77677, 044 - 430 72173
cell : 093845 77677
email : twggroupchennai@gmail.com

KOCHI BRANCH

Near LULU Shopping Mall
Edappally Toll Junction,
Opposite - Metro Bridge Piller No. 387,
V.P Marakkar Building,
V.P Marakkar Road,
Via - Vanitha and Vinitha Theatre
Edappally P.O, Kochi - Kerala
Contact :073580 27788 , 093810 48884,
Email : twggroupcochin@gmail.com ,
Email : twggroupchennai@gmail.com

MUMBAI BRANCH

crescent business square" No.810, kherani road,
opposite - sj studios sakinaka metro
junction, andheri (east) mumbai - 400 059.
cell : 093810 48884, 073580 27788, 093810 77677
email : twggroupmumbai@gmail.com
email : twggroupchennai@gmail.com

TRICHY BRANCH

sri gem plaza no.3, 4th floor,
sankaran pillai street, s.r.c.college road,
chathiram bus stand, trichy - 620 002
Tamil nadu , india.
contact : jenifer : 093845 77677, 93810 77677
contact : suganya : 093825 88890
email : twggroupchennai@gmail.com

COIMBATORE BRANCH

dheepam complex no.574 to 581, 100 feet road,
near g.p.signal, landmark: kalyan jewellery,
gandhipuram, coimbatore - 641 012 tamil nadu , india.
contact : jasmine : 093810 77677, 093845 77677,
contact : sandhiya : 093825 88890
email : twggroupchennai@gmail.com

VIZAG BRANCH

twg group vizag no. 8 - 12 - 1/1,
2nd floor, gayathri nilay, gokul nagar,
karur vysya bank back side opposite - holy cross church,
old gajuwaka junction, vishakapatnam - 530 026.
Andhra pradesh , india.
contact : 073580 27788, 093810 48884, 76692 48884.
email : twggroupchennai@gmail.com

BANGALORE BRANCH

No.54, 15th Main Road ,
2nd Floor,
East of Chord Road
Vijaya Nagar,
Opposite Vijaya Nagar Metro Station,
Bangalore - 560 040.
Karnataka, India.
Contact : 073580 27788 , 093810 77677
Email : twggroupchennai@gmail.com

HYDERABAD BRANCH

twg group hyderabad contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

DELHI BRANCH

twg group delhi contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

PUNE BRANCH

twg group pune contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRIVANDRUM BRANCH

twg group trivandrum contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

CALICUT BRANCH

twg group calicut contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRAINING COURSES