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.

Prerequisites:

• 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