@ndelscott Consulting Limited


Home Page
 
    Data Marts

Andelscott Consulting Limited has developed bespoke database tools for collecting and analysing data.


   
    Case study The client used a spreadsheet to maintain metrics for companies operating in its target market for benchmarking and reference purposes. With increasing volumes of data, the solution was reaching the limit for practical use. In addition, the client wished to create a multi-user and 'self-service' tool to simplify the creation of customised tables and charts ready for inclusion in consultancy reports.  
    Solution and benefits

We developed a database schema and suite of routines to handle data input and data selection and extraction.

Technologies used: Microsoft IIS webserver, mySQL database, HTML, Javascript, PHP.

Benefits of the approach include the creation of an extensible data structure and provision for analysis using dimensions (such as time-series data) previously not considered practical.


   
   

© Andelscott Consulting Limited, 2003-2014.
Material contained herein may not be reproduced, copied or distributed in written, printed or electronic form without permission of the authors.
All Trade marks and copyrights acknowledged.
Contact details may not be used nor distributed within e-mail distribution lists or systems without permission.

   
  datamart1.htm     Updated: 06-May-2008