Texas State Technical College (TSTC) would also like to engage augmented support services to stabilize the BI tools — extract, transform and load (ETL) and enterprise data warehouse (EDW) — and develop multidimensional models to accelerate BI and analytics self service.
The college’s environment is a hybrid landscape, and it has elected to adopt data virtualization. It will partner with Denodo to abstract data and provide a seamless transition to cloud. The initial Denodo instance will be on premise. The college is equally evaluating but leaning toward Snowflake for the data lake and data warehousing and cloud storage. Both will be conducting proof of concepts over the next few months.
The vendor will:
- Review current ETL and data warehouse architectures.
- Develop SSAS cubes (currently 8/9 domains x 2 multidimensional cubes per domain — open to HyperCube).
- Design data pipeline architecture for data lake (preferably Azure Data Factory). Knowledge of Spark is a major advantage for unstructured data.
- Provide support service in the maintenance of the ETL (such as fine tuning, stored procedures, etc.), support and configuration of Microsoft DQS and MDS.
The contact people are Catherine Lopez, 254-867-3734, ext. 13734; and Glendoris Wynn, (254)-867-3757. Proposals are due by 2 p.m. Oct. 10.
