January 15, 2016
Score 9 out of 10
Read Robert Goodman's full review
Business Processes Supported
- We use the database platform to warehouse the data from our disparate admissions, student information, human resources, finance, and advancement systems.
- SQL Server Integration Services (SSIS) is used to move the data from these ERPs into staging - then onto our dimension model and SSAS cubes.
- SQL Server Reporting Services (SSRS) is used to report on this dimensional data and provide parameterized, drill-through reporting.
- SQL Server Analysis Services (SSAS) is used to build cubes for specific functional areas. These cubes can then connect back to the dimensional data as required for drill-through analysis.