Learn MSBI(SSIS, SSAS and SSRS) in 2 days in Mumbai Andheri

Course Name: – Learn MSBI (SSIS, SSAS and SSRS)  in 2 days

Date: –  Sat 02nd Mar 2019 and Sun 03rd Mar 2019.

How to Join?

Click Here

Discounts: –

Booking between 03 Feb 2019 to 09 Feb 2019 – 1000 INR discount, you pay 6000 INR
Booking between 10 Feb to 23 Feb 2019 – 500 INR discount, you pay 6500 INR
Booking between 24 Feb to 01 Mar 2019 – 0 INR discount, you pay 7000 INR

Venue: –

3D4, 3rd Floor, D-Wing, Gundecha Onclave, Kherani Road, Next to Post Office, Sakinaka, Andheri (East), Mumbai – 400072.

Below is the syllabus: –

Day 1 

  • MSBI Fundamentals, Data flow, Control Flow, ETL, Dataware house. (SSIS)
  • Conditional split, Data conversion and Error handling. (SSIS)
  • For Loop, Variables, Parameters and Debugging. (SSIS)
  • For dimension, measures, star schema, snow flake, shared connection managers & packages tasks.(SSIS)
  • SCD, Type 0, Type 1, OLEDB Command and Unicode conversions.(SSIS)
  • Lookup, Data conversion optimization and updating SSIS package.(SSIS)
  • Sort, Merge and Merge Joins.(SSIS)
  • Creating SSAS Cube. (SSAS)
  • SSAS Time series and Excel display.(SSAS)
  • What are Transactions and CheckPoints in SSIS? (SSIS)
  • Simple SSRS report & implementing Matrix, Tabular, Parameters, Sorting, Expressions. (SSRS)
  • Using Data Profiling task to check data quality. (SSIS)

Day 2 

  • Hierarchical Dimensions. (SSAS)
  • SSAS Calculation.(SSAS)
  • Reference and Many-to-Many Relationship. (SSAS)
  • Script component(SSIS)
  • Partitions in SSAS. (SSAS)
  • Explain Asynchronous, Synchronous, Full, Semi and Non blocking Components. (SSIS)
  • SSRS Architecture and Deployment (SSRS)
  • DQS( Data Quality Services ) (SSIS)
  • Explain Tabular Model and Power Pivot (SSAS).
  • MDX (Multidimensional Expressions) Queries.(SSAS)
  • Data Mining (Fundamentals and Time Series Algorithm).(SSAS)
  • Aggregations in SSAS.(SSAS)
  • ROLAP, MOLAP and HOLAP.(SSAS)

Key Features

  • No PPT showcase, complete step by step Hands-on MSBI training.
  • Personal attention given to each candidate till topic is clear.
  • You have to just come with your laptop with VS 2013 – SSDT  & SQL Server 2012/2014 installed.
  • Tea & Lunch will be provided.
  • All at only 7000 INR.

Generally it is hard to believe about the teaching quality of anyone unless you go through their live session we totally agree with your point but equivalently it is also true that everytime it is not feasible to present live demo to everyone anytime. So here we have bought a video through which you can see explaining pace-style which will help you to judge and can get decide what to do next. So without keeping you wait and wasting your time much also thanking to you for reading this page post and giving your valuable time to view following full 50 mins video by the MSBI – SSIS, SSAS and SSRS trainer.