Created by Shivprasad Koirala
PREVIEW THIS COURSE - GET COUPON CODE
- Should be able to work on professional MSBI projects. Design database using star schema and snow flake ,Create ETL using SSIS , Cubes using SSAS and display reports using SSRS.
- Learn SSIS Data flow , control flow, error handling, variables , for loop containers, SCD ,Sort , merge , merge joins ,look up , transactions and checkpoints.
- Displaying report in SSRS, Tabular reporting , Matrix reporting , report parameters , sorting , interactive sorting, expressions, running total , cascading drop downs and importance of RDL files.
- In SSAS you will learn MDX , tabular , hierarchical dimension , KPI , Calculated members , Aggregations , perspectives , translations , Many to many relationship , reference relationship and processing SSAS cubes at background.