Multiple SQL Services

There are multiple SQL services available to support the system

SQL Server Analysis Services

1. SQL Server Analysis Services (or we can say SSAS) supports advanced features for data mining & analytics.

2. It is designed & developed in such a way as to support large volumes of data & process them quickly & provide analytical results.

3. SSAS provides features to create Key Performance Indicators (KPIs) and scorecards.

4. SSAS provides multiple facilities like multidimensional data modeling, developers can design & create complex data models, etc.

SQL Server Integration Services

1. It is also known as SSIS. 

2. SSIS is a very powerful tool.

3. It provides the feature to Extract, Load, and transform data. 

4. SSIS provides features to developers to develop their modules using C# or VB.NET.

5. We can easily transform data from other sources like SQL Server, Excel, SharePoint, and Azure.