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