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
  • Course Overview
  • Course Duration
1. What is Microsoft BI?
2. Using SSAS in BIDS
3. Intermediate SSAS 
4. Cube Storage and Aggregation
5. MDX
6. New MDX Functions
1. Introduction to SQL Server Intigration services
2. SSIS for DBAs: Using SQL server Management Studio
3. Business Intelligence Development Studio (BIDS) 
4. Introduction to control Flow
5. Advanced Control Flow
6. Introduction to Data Flow
7. Variable and Configurations
8. Debugging Error Handling And Logging
9. Advanced Data Flow
10. Extending SSIS through Custom Code 
11. SSIS Package Deployment
12. 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
20 Days
4 Hrs per day
enroll here
Please get in touch so we can answer any questions you may have.