The client wanted to provide a replacement system that could be used to store and report on statistical and key performance indicators (KPI) for each program. Data to be reported includes province wide student, graduate and employer satisfaction as well as financial, enrollment and local survey information. The information was to be used in support of their new Program Planning application. Adaptability and maintain-ability were key
Prodigy developed a MS SQL based solution using SSIS and SRS frameworks. Over ten years of historic data was uploaded from 15 different file types and stored in a narrow & deep data structure (i.e. one record per data measure.) Data load and transform information was stored in tables to allow easy modification as input data formats change. Information for each measure includes names, labels, descriptive information and measure classification data. Information is reported both through multi-year tables (with indicators) of KPIs and individual graphs of each measure with links to connected supplementary or related measure graphs. Data can be selected and extracted for more detailed analysis.
The system allowed the client to load and report on ten-years of historical information, including information that previously could not be displayed. Comprehensive statistical data is now available to all faculty to review their program’s performance.
The client needed to replace a system that provided job site access to current job and labour costs for over 2,500 projects and which allowed site users to update cost to complete estimates. The system needed to pull information from the Microsoft GP Dynamics system and present large amounts of information in both summary and detail form.
Prodigy developed a web based solution using an MVC framework and an advanced Telerik control grid. Both row and column expansion capabilities were built into the grid as well as in-line editing and hyperlinking to secondary information presentation grids. As well as an Excel like grid, the application also provided several key measures in graph form. The system maintained the information retrieval queries in a table to allow for easy modification and potential adaptation to a new financial system as necessary.
The system allowed the client to expand and extend their review and forecasting processes. The system has been fully implemented and has improved information flow for both job site managers and the accounting department.
This startup is dedicated to the capture and analysis of digital advertising data for its clients. Tags embedded in the clients’ ads capture data concerning the user device and sites from which the ads are presented. This information is later connected to data from the company that “served” the ads and data from users who visit the client sites. This information is analyzed to identify factors that lead users to visit the client site and make purchases.
Prodigy developed a series of tags that can be embedded in the clients’ ads and sites and developed MS SQL and Hadoop processing routines to download, process, connect and store the information collected from these tags. After initial processing Azure Cortana machine learning analytics are used to identify factors that lead to conversion and predict behavior using this data.
The system processes some 40 million digital ad impressions per month and is providing valuable insights to the startup’s clients concerning more effective delivery of digital advertising.
Our client was a major school board using Trillium as its primary student information system. However, not all required functionality is provided by the system. The client uses a Powerbuilder based report generator application to both report on and update data held in Trillium. There are some eight mini-applications that have been developed to operate in this manner. Three of them were to be replaced with modern .Net applications through this engagement.
Prodigy reviewed the existing documentation of the system and any desired enhancements, next the code of the existing applications was reviewed and a session was held with the system owners to finalize requirements and changes. Prodigy then developed use cases and screen mock-ups for the revised applications. These were reviewed and approved. Next the applications were coded in .Net 4.0 using an MVC pattern and Telerik controls accessing the Trillium Oracle 11g database.
Application development and testing was completed on time. Revised applications and revised UI were well received by users.
