Learn Hands-on MSBI (SSIS, SSAS and SSRS) in 2 days

3D4, 3rd Floor, D-Wing, Gundecha Onclave, Kherani Road, Next to Post Office, Sakinaka, Andheri (East),Mumbai,Mahārāshtra,India
Add Favorites Contact Author
no-image-58378

Learn Hands-on MSBI (SSIS, SSAS and SSRS) in 2 days

Start date: 2018-03-17 10:00:00

Venue:
STEP BY STEP SCHOOLS
3D4, 3rd Floor, D-Wing, Gundecha Onclave, Kherani Road, Next to Post Office, Sakinaka, Andheri (East),Mumbai,Mahārāshtra

End date:

Created on: 2017-12-17 03:18:04 by:evdb

Description
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)


Add your review