This course is intended for students who want to learn the important components of the Microsoft Business Intelligence Stack, learn how to load and process SQL Server Analysis Server cubes and creates reporting solutions that will rapidly and accurately retrieve the correct data.

Topics Covered

Learning Objective: SSIS: Architecture and Introduction to SQL Server Integration Services. Designing and Implementation of SSIS packages. Designing and Implementation of Control Flow & Data Flow. Debugging and Managing Package Execution. Detecting and Handling Processing Errors. Securing and Deploying SSIS Packages. SSAS : Understanding BI and Data warehousing Architecture and Understanding Analysis Services Designing and Creating Dimensions. Designing Measures, Measure Group and Aggregations. Implementing Security and Managing Deployment. SSRS : Architecture and Introduction to SQL Server Reporting Services. Designing and Implementation of Reporting Services Projects. Use report models to implement reporting for business users. Configure report publishing and execution settings. Implementing subscription for reports.

Who should attend

Any graduates, Masters, MBA, B.Com, BE, B. Tech, any Professional aspire to Become Business analyst.

Pre-requisites

Knowledge of SQL Server.

What you need to bring

Note book, Laptop (not compulsory )

Key Takeaways

Participants complete exposure of Micosoft Business Intelligence, reporting , analysis and integration knowledge. hand on real time challenges.