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 19th Nov 2020 and Sun 20th Nov 2022.

How to Join?

Click Here

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)

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)
    • 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.
  • Just come with your laptop(i5 processor/min 8 GB RAM) having Community Edition, VS 2017-SSDT & SQL Server 2017 developer edition installed, refer to the link for complete steps
  • Tea/Coffee as refreshment 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.