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.|
|Tableau is a very powerful, yet easy-to-use tool to statistically-analyze data and present engaging and intuitive 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.|