Why Write Code?
Clearly, I love SQL. But do I use it anymore? Rarely. Instead, I use visual workflows for my data integrations.
data warehousing
Peak of Data Integration: 2022 FME User Conference
Automated data integration enabled Douglas College to generate a staged release of course registration timeslots over a two week timespan, which will grant over 20,000 students access to registration. This dynamic timeslot process better adapts to evolving registration policy and practices.
Tips for Moving to Near-Real-Time Data in Higher Education
Learning to work with daily or real-time data feels like learning to drink from a firehose. As more universities and colleges move to having near-real-time data, we offer these helpful tips.
The Data Only Updates 3x Per Year?
Snapshots can also be helpful with enrolment forecasting – in particular, many users I speak to don’t want their forecast to change daily, instead every second week or even every month.
Still Rolling Over Manually?
We used to update our scenario data monthly during the fall term and at end of the fiscal year. After this all was quiet until the dreaded rollover to the next academic year in summer.
Using a Database for your Enrolment Forecast
Databases are great at storing the inputs and outputs of your enrolment forecast. Depending on your configuration, horsepower, and forecast design however, they may be very subpar for the steps that happen between input and output.