Microsoft Bussiness Intelligence

About this course:

MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server. It empower users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.


  • Participant needs to have knowledge on SQL Server T-SQL Queries
  1. What is Microsoft BI?
  2. Using SSAS in BIDS
  3. Intermediate SSAS
  4. Cube Storage and Aggregation
  5. MDX
  6. New MDX Functions
  7. Introduction to SQL Server Intigration services
  8. SSIS for DBAs: Using SQL server Management Studio
  9. Business Intelligence Development Studio (BIDS)
  10. Introduction to control Flow
  11. Advanced Control Flow
  12. Introduction to Data Flow
  13. Variable and Configurations
  14. Debugging Error Handling And Logging
  15. Advanced Data Flow
  16. Extending SSIS through Custom Code
  17. SSIS Package Deployment
  18. SSIS Package Management

Reporting Services:

  1. Introduction to SQL Server Reporting Services.
  2. Creating Reports
  3. Calculations and Formatting
  4. Grouping and Sorting
  5. Report Parameters
  6. Creating Matrix Reports and Charts
  7. Managing Reporting Services
  8. Snapshots and Subscriptions
  9. Ad-Hoc Reporting with Report Builder

Course Duration : 20 days (80 Hrs)