Fundamental Tool: Microsoft Analysis Services
Microsoft Analysis Services is a business intelligence (BI) platform that enables organizations to create and deploy online analytical processing (OLAP) and data mining models for use in BI and analytics applications.
It is a component of the Microsoft SQL Server database software, and it is designed to provide fast and efficient access to large volumes of data for analysis and reporting.
Analysis Services supports two main types of models: multidimensional models and tabular models.