Algorithm Development Data Mart

Palo Colorado Software developed a data mart and supporting Excel toolkit to support algorithm development for a medical device. The algorithms developed from this data mart were used in our client's commercial product.

Features of the solution include:

Scheduled and on-demand data mart generation
Data pulled from transactional SQL databases
Input databases have tens of millions of data points
Structured and guided SQL queries using Excel add-in toolkit
Import of data into formatted analysis spreadsheets
Export of data to analysis tools

Technologies used include VB.Net, VBA and Microsoft SQL Server.

Next Previous Back To Projects