About the Course
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 CoveredLearning Objective:
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.
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.
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 attendAny graduates, Masters, MBA, B.Com, BE, B. Tech, any Professional aspire to Become Business analyst.
Pre-requisitesKnowledge of SQL Server.
What you need to bringNote book, Laptop (not compulsory )
Key Takeaways Participants complete exposure of Micosoft Business Intelligence, reporting , analysis and integration knowledge. hand on real time challenges.