List your primary requirements for this solution.Please list your primary requirements for this solution.
Prospective vendors should clearly demonstrate their capabilities for provision of the aforementioned services. The following are the minimum requirements.
They should demonstrate experience in conducting architectural design and performance assessment of the Microsoft Business Intelligence stack. The College runs on SQL Server 2019 and has licensing for the entire stack. However, only the ETL tool, the database and the Warehouse are in use. The vendors should demonstrate expertise in designing an end-to-end solution leveraging the college’s existing investments.
SSAS multidimensional development is purely for the on-premises datasets for reporting and analysis purposes. The scope does not include SSAS tabular models, which will be implemented on the cloud platform. A key requirement will be experience and/or certification in Microsoft Multidimensional Expressions (MDX) language that is used in SSAS.
As the Data Lake is implemented, some data that already exists on other cloud platforms will require to be Extracted, Loaded and Transformed (ELT). This requirement is critical for the smooth integration of disparate data types. The architectural design should also address acquisition of unstructured data into the Data Lake. For the time being, the college favors Adobe Spark, though open to suggestions/alternatives