Live Faculty based Quick start Hands-on training for registered QuestPond subscribers on Sunday's
Sunday training on MSBI Handson training covering SSIS, SSAS and SSRS topic
We at QuestPond conduct weekend training through Microsoft Live Meeting on Sunday for 5 years and 2500 INR MSBI training paid package registrants QuestPond active members. At QuestPond, we along with trainer simplify complex topics and deliver it in simpler training. Starting from Sun 28th Feb 2020 to Sun 21st Mar 2021 training on MSBI training covering SSIS, SSAS and SSRS topics dedicated Handson evening, timing 08:00 PM(IST) India time onwards.
Below are the features of the training: -
- Training are conducted by MVP's or trainer from corporate with vast experience and technical expertise.
- Training agenda along with dates are e-mailed prior in advance to all subscribers.
- Training is provided with real world examples.
- Queries related to training or topics which is not understood is explained again.
- If queries is not solved during training you can email us and we will reply all your queries.
Starting from Sun 28th Feb 2021 to Sun 21st Mar 2021 on MSBI Handson training covering SSIS, SSAS and SSRS topic scheduled evening 08:00 PM(IST) India time onwards
Agenda for MSBI Handson training covering SSIS, SSAS and SSRS topic training
- MSBI 2019 Installation* SSIS Architecture
- ETL Process and understanding Conditional Split, Derived Component, Union All and Data Conversion Components
- SSIS Error Handling using Redirect Row and EventHandler : OnError : using SQL Execute Task, Multiple PAckages set as start up object.
- ForLoop, ForEachLoop, Sequence Container, Script Task, Execute SQL Task, Variables, Debugging, Break Point.
- Send Mail Through Send Script Task
- Transaction and CheckPoints.
- File System Task, Package Deployment, Scheduling SSIS Package From SQL Server Agent.
- Understand Sort and Types of Joins in SSIS and Insert Update Data using Merge Join. Incremental Load.
- Understand OLAP, Star Schema, SnowFlake, Dimension and Facts and SSIS SCD and Lookup.
- Adding SSAS cube with Time Series to Star Schema with Excel Display.
- SSRS Reports (Matrix Tabular, Expression Parameters), SSRS DrillDown and Subreports.
- SSAS Hierarchical Dimensions, KPI, Calculations and Many-to-Many Relationship.
- MDX (Multidimensional Expressions) Queries.
- Transaction and CheckPoints.
How to login into virtual training room?
Training link and other training related info is available under “Training section” of subscription portal, kindly login into your subscription account and check updated training link on Sunday evening time after 7 PM(IST) India time for updated info. You can enter in to training room on or after 7:30 PM(IST) India time.