IFS Analysis Models generally covers technologies, processes, and applications to analyze mostly internal structural data to support better business decision making.
Most of the development is done using Microsoft tools and is based in services as SSMS, SSAS, SSIS, SSRS and Excel etc. The main purpose is not to supply all details but rather to supply some basic concepts and guidelines on how to handle some special cases.
Use this page to find development specific guidelines related to IFS Analysis Models.
General information about SSIS packages used in the ETL process can be found via the following link >>
Implementation guideline details on how to implement support for incremental load of Facts in the ETL process can be found via the following link >>
SQL Server Data Tools is used to develop SSIS packages, SSAS data models and
SSRS reports. SSDT will install a minimal version of Visual Studio, so that the
full Visual Studio doesn't have to be available.
SSDT-BI for Visual Studio 2012 and SSDT for Visual Studio 2017 are recommended.