Business Intelligence (BI) encompasses leveraging descriptive and inferential statistical analysis upon massive organizational data stores to enable strategic decision-making.
SQL Server Analysis Services (SSAS) is Microsoft’s solution to the organization’s needs for Online analytical processing (OLAP) which leverage a data warehouse to provide self-service business intelligence capabilities to end users.
SQL Server Integration Services (SSIS) is the most-used tool for Extract-Transform-Load (ETL) operations inherent within BI solutions.
SQL Server Reporting Services (SSRS) represents the most popular reporting platform, even for non-Microsoft data sources due to the rich features available to SSRS reports.
Excel Analysis illustrates the rich feature set provided to end users with the most popular application within the Office suite.
Statistical Analysis illustrates the two primary areas within statistics – descriptive and inferential statistics.